Have you ever been able to establish a connection to the database server from this client? If so, what has changed recently that may explain this problem?
This error usually indicates that your connection to the database cannot be established because it does not know where to find the database. Check the tnsnames.ora on the client workstation to ensure that you are using the correct host name or IP address of the database server. Also check that the service name is correct in the tnsnames.ora. Finally, check to see whether there is a default domain identified in the sqlnet.ora. If so, try using the default domain in the connect string. For example, if you are trying to connect to a database called PROD and there is a default domain of .WORLD identified, trying connecting to PROD.WORLD rather than just PROD.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
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 ... Continue Reading
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." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.