SQL> shutdown abort .com

About DBA Queries DBA Scripts Quick Guides Other Stuff Contact
Andy only 
 
TNS-03505: Failed to resolve name

The specified database name was not found in the tnsnames.ora, onames or ldap. This means that the client hasn't even got as far as trying to make contact with a server - it simply can't find any record of the database that you are trying to connect to. Make sure that you've spelled the database name correctly, and that it has an entry in the tnsnames.ora.

If you have a sqlnet.ora, look at for the setting NAMES.DEFAULT_DOMAIN. If it is set, then all entries in your tnsnames.ora must have a matching domain suffix.


Related article: Resolving Oracle networking problems.

For more useful DBA queries click here.
Copyright© 2007-2012 Andrew Barry