Tuesday 21 January 2014

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

Simply put, it means that you have named the database you wish to be connected to and Oracle doesn’t know who the heck you’re talking about.

This error is often caused by typos, maybe in your connection string, but possibly in your tnsnames.ora file.

Best thing to do is open a command prompt and issue following command. I am assuming that connection name is "ORCL"

tnsping orcl

It is also possible that the tnsnames.ora file is not accessible or does not even exist. If it does, ensure that it contains the service name you are using.

No comments:

Post a Comment