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
Printable View
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
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.
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
TNS_ADMIN would be that parameter