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....
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.
Dig Deeper on Oracle database installation, upgrades and patches
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.