Re: DB Link issue while using it remotely

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Mon, 21 Oct 2013 16:56:29 -0500
Message-ID: <CAP79kiTbPZJ=Fjf5T6MsXrY-SMQpR=bqL6p=beOfVHRjTmT_qA_at_mail.gmail.com>

A db_link is *always* resolved on the server, not on your workstation. So, if a db_link is defined in the database, it is up to the database to resolve the link name using the local version of the tnsnames.ora file (or ldap.ora or whatever). Similarly, when you enter a DB Name in Toad, it us up to the Oracle client on your workstation to resolve the alias in your local tnsnames/ldap file on your PC.

HTH
Chris Taylor

On Mon, Oct 21, 2013 at 4:49 PM, Mandal, Ashoke < ashoke.k.mandal_at_medtronic.com> wrote:

> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 21 2013 - 23:56:29 CEST