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
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
No comments:
Post a Comment