Ask the Expert

ORA-12541 after Oracle 10g Client re-install

I'm getting "ORA-12541:TNS:no listener" when trying to connect to Oracle in Visual Studio 2005 / SQL Server 2005 Reporting Services. This was not happening until I recently did a re-install of Oracle 10g Client / ODP.Net (via OUI). I can connect via Toad and have run the ODP.NET setup (after running the client setup). I'm using a Windows XP Professional workstation. Other developers are able to connect fine; it's not the database. I do not have any way to start or stop the listener, not in my services, and the DOS command is not on my machine. Very frustrating....

    Requires Free Membership to View

Since you've mentioned that others can connect to the database, the problem likely stems from a configuration setting on your workstation. In your TNSNAMES.ORA file, make sure the value of HOST and PORT match the value of HOST and PORT in the LISTENER.ORA file on the database server. If this does not resolve the problem, change HOST in your tnsnames.ora file to use an IP address of the database server rather than host name. You may also want to set the environment variable TNS_ADMIN on your workstation and server to ensure you are using the correct set of configuration files. Finally, firewalls on both the client and server can cause this error. Ensure that firewalls are configured correctly to allow connections to the database server.

This was first published in May 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: