20 December 2010

ORA-12162

The error message ORA-12162 "TNS:net service name is incorrectly specified" is not exactly what it meant.

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.