12c Client: TNS-3505 or ORA-12154 Using TNSNAMES.ORA (Doc ID 2152990.1)

Last updated on JULY 03, 2016

Applies to:

Oracle Net Services - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

A 12c client might fail to resolve a TNS connect string when there are multiple aliases separated by commas in a list.  This behavior would not have been present with previous versions of Oracle client. 

For example: 

MYDB,MYDB.us.oracle.com,MYDB.oracle.com =  <====Pre 12c clients would have been able to resolve any of these 3 TNS aliases without error.

    (DESCRIPTION =   (ADDRESS_LIST =   (ADDRESS = (PROTOCOL = TCP)(HOST = SCAN-HOST)(PORT = 1521)))   
        (CONNECT_DATA =   (SERVICE_NAME = MYDB.us.oracle.com)))

A 12c client may return the following error:  TNS-3505 or ORA-12154

ORA-12154: TNS:could not resolve the connect identifier specified
TNS-03505: TNS: Failed to resolve name

Changes

 This is a recent upgrade to a 12c client. 

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