My Oracle Support Banner

Database Link fails with ORA-12154 even after setting TNS_ADMIN environment variable (Doc ID 470933.1)

Last updated on DECEMBER 04, 2017

Applies to:

Oracle Net Services - Version 9.0.1.0 to 12.2.0.1 [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.

Symptoms

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

 

 

Changes

This is likely a new database link or the environment has changed.  If $TNS_ADMIN has been set recently, this article may apply.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.