ORA-12162 TNS:net service name is incorrectly specified
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-12162 from Oracle 11g ?
How to deal with ORA-12162 from Oracle 11g ?
If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If using directory naming check the information provided through the administration used for directory naming.
This error message could also be cause by a wrong configuration of the envirronement variables ORACLE_HOME and ORACLE_SID.
So if your SID is <your_sid> and your Oracle home is <your_oracle_home> then :
In Windows, type the following commands :
C:\>set ORACLE_HOME=C:\<your_oracle_home> C:\>set ORACLE_SID=<your_sid>In Linux, sets ORACLE_HOME and ORACLE_SID as follows:
ORACLE_HOME=/<your_oracle_home>; export ORACLE_HOME ORACLE_SID=<your_sid>; export ORACLE_SID
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-12154 TNS:could not resolve the connect identifier specified
- ORA-12155 TNS:received bad datatype in NSWMARKER packet
- ORA-12156 TNS:tried to reset line from incorrect state
- ORA-12157 TNS:internal network communication error
- ORA-12158 TNS:could not initialize parameter subsystem
- ORA-12159 TNS:trace file not writeable
- ORA-12160 TNS:internal error: Bad error number
- ORA-12161 TNS:internal error: partial data received
- ORA-12163 TNS:connect descriptor is too long
- ORA-12164 TNS:Sqlnet.fdf file not present
- ORA-12165 TNS:Trying to write trace file into swap space.
- ORA-12166 TNS:Client can not connect to HO agent.
- ORA-12168 TNS:Unable to contact LDAP Directory Server
- ORA-12169 TNS:Net service name given as connect identifier is too long
- ORA-12170 TNS:Connect timeout occurred