Q

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.

This was first published in June 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close