Remote or Local Connections to the Database Fail With: ORA-12162: TNS:net service name is incorrectly specified (Doc ID 312348.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.4 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Net Services - Version 10.1.0.4 to 12.1.0.2 [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***

Symptoms

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms