DB Link issue while using it remotely
- From: "Mandal, Ashoke" <ashoke.k.mandal@xxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Oct 2013 21:49:05 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
