Q
Problem solve Get help with specific problems with your technologies, process and projects.

No errors in tnsnames.ora file

While connecting to the database through Toad or SQL*Plus, the "TNS name could not be resolved" error is appearing. After checking the TNSNames.ora file, I confirmed that there is no error in it. What could be other possibilities for this error coming so frequently?

While connecting to the database through Toad or SQL*Plus, the "TNS name could not be resolved" error is appearing. After checking the TNSNames.ora file, I confirmed that there is no error in it. What could be other possibilities for this error coming so frequently? Were to check other than where I did? Please help.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close