DB Link issue while using it remotely

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Mon, 21 Oct 2013 21:49:05 +0000
Message-ID: <DD179917255B1146B9367DC5E7C0DDB001578DD9_at_MSPM1BMSGM36.ent.core.medtronic.com>



When I try to use the database link of a schema remotely then I get the error ORA-12154: TNS: could not resolve the connect identifier specified.

If I login to the server, hosting the database, login to the schema owner using SQL*PLus and use the database link then it works fine as my primary method of database connectivity resolution is LDAP. But if I try to use the DB link from toad or SQL*Plus from my laptop then I get the above error. After trial and error I found out that if I added the databases to tnsnmaes.ora file on the server then the DB link works from remote (TOAD or laptop). But no idea what is the root cause.

Let me know if you have experienced the similar issue and explain the root cause of the problem.

Thanks,
Ashoke

[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.  

To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 21 2013 - 23:49:05 CEST

Original text of this message