Remote or Local Connections to the Database Fail With: ORA-12162: TNS:net service name is incorrectly specified
Last updated on JUNE 21, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.4 to 184.108.40.206 [Release 10.1 to 12.1]
Oracle Net Services - Version 10.1.0.4 to 220.127.116.11 [Release 10.1 to 12.1]
Information in this document applies to any platform.
Affects any platform.
Mostly UNIX and Linux but not as frequent on Microsoft Windows (possibly due to differences in BEQ communication)
***Checked for relevance on 26-nov-2012***
1. When trying to connect locally (BEQUEATH) to the database, you may get an error:
ORA-12162: TNS:net service name is incorrectly specified
This is unusual because a TNS:net service name is not being specified, nor is the environment variable TWO_TASK set (which will force TNS service names use).
2. This may also happen if you are trying to connect from a location other than the Local ORACLE_HOME.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms