12c Client: TNS-3505 or ORA-12154 Using TNSNAMES.ORA
Last updated on FEBRUARY 06, 2018
Applies to:Oracle Net Services - Version 126.96.36.199 to 188.8.131.52 [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.
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
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
Million Knowledge Articles and hundreds of Community platforms