Re: dblink no listener - normal connection works

From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Fri, 16 Jul 2010 00:48:17 -0700 (PDT)
Message-ID: <0fea4b24-cff9-41c0-b40a-eceafc57cb36_at_x1g2000prc.googlegroups.com>

On 15 Jul., 18:29, Sybrand Bakker <sybra..._at_gmail.com> wrote:
> On Wed, 14 Jul 2010 23:24:17 -0700 (PDT), Krzysztof Cierpisz
>
> <ciape..._at_gmail.com> wrote:
> >definitely I have only one Oracle home.
> >there is only one tnsnames.ora file on my system.
> >it's fairly new entry into tnsnames.ora file, and as mentioned above
> >when I change tnsname entry from OXO into TEST both connections
> >(sqlplus and dblink) work fine.
>
> >thanks,
> >chris
>
> Which tnsnames.ora are you referring to? The one  on the server?
> Because it is that one which will be used by the database link!
> You need to establish whether the source database server can connect
> to the target database, your client is irrelevant.
>
> ------
> Sybrand Bakker
> Senior Oracle DBA

I was referring to tnsnames.ora file on my local server (EMEADB11) it is actually the same entry used from my client when executing sqlplus (in this case client and server are same machines) tnsname entry points to remote server.

--
chris

Received on Fri Jul 16 2010 - 02:48:17 CDT