Friday, July 11, 2014

ORA-12162 TNS:net service name is incorrectly specified

The error message ORA-12162 "TNS:net service name is incorrectly specified", is very misleading.

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.

In Linux, these commands sets ORACLE_HOME and $ORACLE_SID as follows:

export ORACLE_HOME=/u01/oracle/product/11.2.0/db_1/

export ORACLE_SID=orcl

Thank you,
Arihant Baid