Re: dblink no listener - normal connection works
From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Wed, 14 Jul 2010 01:29:36 -0700 (PDT)
Message-ID: <9af98174-5b5e-419a-a6de-116fc0e842f9_at_d8g2000yqf.googlegroups.com>
>
> but now even when I change it back (the service name) to TEST and try
> to create dblink using 'TEST' it's not working.
>
Date: Wed, 14 Jul 2010 01:29:36 -0700 (PDT)
Message-ID: <9af98174-5b5e-419a-a6de-116fc0e842f9_at_d8g2000yqf.googlegroups.com>
>
> 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
Received on Wed Jul 14 2010 - 03:29:36 CDT