Re: dblink no listener - normal connection works
From: Carlos <miotromailcarlos_at_netscape.net>
Date: Wed, 14 Jul 2010 02:35:14 -0700 (PDT)
Message-ID: <96a4a948-9508-4d6a-a9be-74a79601b46d_at_d8g2000yqf.googlegroups.com>
On Jul 14, 10:29 am, Krzysztof Cierpisz <ciape..._at_gmail.com> wrote:
> > but now even when I change it back (the service name) to TEST and try
> > to create dblink using 'TEST' it's not working.
>
> correction to the above,
>
> replacing OXO with TEST in tnsnames.ora and in dblink creation works.
>
> I don't understand now why OXO as tnsname is not working returning no
> listener.
>
> thanks,
> chris
Date: Wed, 14 Jul 2010 02:35:14 -0700 (PDT)
Message-ID: <96a4a948-9508-4d6a-a9be-74a79601b46d_at_d8g2000yqf.googlegroups.com>
On Jul 14, 10:29 am, Krzysztof Cierpisz <ciape..._at_gmail.com> wrote:
> > but now even when I change it back (the service name) to TEST and try
> > to create dblink using 'TEST' it's not working.
>
> correction to the above,
>
> replacing OXO with TEST in tnsnames.ora and in dblink creation works.
>
> I don't understand now why OXO as tnsname is not working returning no
> listener.
>
> thanks,
> chris
global dbname / GLOBAL_NAMES issue?
Cheers.
Carlos. Received on Wed Jul 14 2010 - 04:35:14 CDT