Re: dblink no listener - normal connection works
From: Sybrand Bakker <sybrandb_at_gmail.com>
Date: Thu, 15 Jul 2010 18:29:12 +0200
Message-ID: <endu36tjcnu7imjgmnf0notukbveqd7q02_at_4ax.com>
On Wed, 14 Jul 2010 23:24:17 -0700 (PDT), Krzysztof Cierpisz <ciapecki_at_gmail.com> wrote:
Sybrand Bakker
Senior Oracle DBA Received on Thu Jul 15 2010 - 11:29:12 CDT
Date: Thu, 15 Jul 2010 18:29:12 +0200
Message-ID: <endu36tjcnu7imjgmnf0notukbveqd7q02_at_4ax.com>
On Wed, 14 Jul 2010 23:24:17 -0700 (PDT), Krzysztof Cierpisz <ciapecki_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 Received on Thu Jul 15 2010 - 11:29:12 CDT