Thursday, June 23, 2011

Issue : ORA-12162 "TNS:net service name is incorrectly specified

Issue :
=============
ORA-12162 "TNS:net service name is incorrectly specified

Cause : ORACLE_SID is not properly specified... But the issue is pretty misleading where in we digged a lot for tnsnames.ora file.

Finally after setting it to our SID we successfully logged to sqlplus and able to do our administration tasks...



*********
It suggests that there is a problem with the tnsnames.ora file contents, but in reality the message ORA-12162 "TNS:net service name is incorrectly specified" results from improperly setting your ORACLE_SID value.
************

No comments:

Post a Comment