Thursday, December 15, 2011

ORA-12154: TNS:could not resolve the connect identifier specified

OK, Almost everbody who has worked in Oracle would have seen this error message. This is one of most frustrating and most common error

What does "ORA-12154: TNS:could not resolve the connect identifier specified"  mean ?


Say from SQLPlus, you are issuing the following command

SQL> Conn scott/tiger@orcldb;

SO, SQLPlus, looks for the entry "orcldb" in your client tnsnames.ora file.

If it cannot find orcldb in tnsnames.ora, then you get ORA-12154: TNS:could not resolve the connect identifier specified

 Fix your tnsnames.ora, and you should be fine.

No comments:

Post a Comment