Database Link fails with ORA-12154 even after setting TNS_ADMIN environment variable
Last updated on DECEMBER 04, 2017
Applies to:Oracle Net Services - Version 184.108.40.206 to 220.127.116.11 [Release 9.0.1 to 12.2]
Information in this document applies to any platform.
This issue can occur on any platform and is limited in scope to the ORA-12154 error when attempting to use a database link or dblink.
Following the creation of a database link between 2 databases. The database link gets created but you
are unable to select across the dblink from a client.
The following error is returned when you attempt select * from dual@linkname;
ORA-12154: TNS:could not resolve the connect identifier specified
This is likely a new database link or the environment has changed. If $TNS_ADMIN has been set recently, this article may apply.
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