Whenever I try to login or connect into SQL command line or SQL*Plus (11g Standard Edition Win64) I get an error
ORA-12154: TNS:could not resolve the connect identifier specified.
I have tried to solve this problem with google help but I can't.
so please help me out of this!
Oracle – ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
oracleoracle11gsqlplus
Best Answer
You are trying to connect to a database v. "v" is the connect identifier. However, your Oracle client does not know of v. This is what the error message is trying to tell you.
Try
Hopefully this will give you something like this:
What you can extract from this is the location:
This is where your tnsnames.ora file resides. Edit this file and add the correct information for your database v. Substitute servername for the machine your Oracle database is on.