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

[bang_dba]

I am executing the below command as Oracle owner user, on the same host. But getting the following error.


SQL> connect / as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified

[davey23uk]

12162, 00000, "TNS:service name is incorrectly specified"
// *Cause: The connect descriptor corresponding to the service name in
// TNSNAMES.ORA is incorrectly specified.
// *Action: Make sure there are no syntax errors in the connect descriptor.
// Particularly look for unmatched parentheses or stray characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See Chapter 4
// in the SQL*Net V2 Administrator's Guide.

[Bore]

Look into your environment. You may have set default tns string ( I remember that can be done)
If not, trace the client and see what happens

[davey23uk]

TNS_ADMIN would be that parameter