12c Client: TNS-3505 or ORA-12154 Using TNSNAMES.ORA

(Doc ID 2152990.1)

Last updated on FEBRUARY 06, 2018

Applies to:

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


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.

        (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


 This is a recent upgrade to a 12c client. 


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