Wednesday 3 July 2013

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

Hadn't seen this for a while and good reason.

After installing 12c locally and then closing down my system, I logged in tonight to play around.

What I had forgotten to do in my haste was set the ORACLE_SID, school boy error.

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

export ORACLE_SID=orcl

A simple fix from a misleading error message which might have you looking at your tnsnames.ora

No comments:

Post a Comment