Re: Datbase link doesn't work. Why?

Hi Stanislav,

It is easy - check that prod is written in tnsnames.ora of your SERVER, not only on client. Ping it on server too in order to check DNS.

Andrew Protasov

> Hi,
>
> this may be very simple, but I am at my wit's end.
>
> I'm trying to connect two databases using 'database link'.
>
> I'm connected to dtb. DEVEL and I issue a command like:
>
> >create public database link prod connect to sysadm identified by sysadm
> using 'PROD'
> Database link created.
>
> Follow-up:
>
> >select * from dual_at_prod;
> select * from dual_at_prod
> *
> ERROR at line 1:
> ORA-12154: TNS:could not resolve service name
>
> Why?
>
> Separately I can connect to both instances( as sysadm/sysadm ).
> There is a record for both databases in tnsnames.ora
>
> ( I suspect the wrong ( missing param. ) init<SID>.ora for a database. )
>
> Thank you in advance.
>
> Please, if you reply could you bc: to svnuk_at_usa.net
> Stano.
>
>
>
>
Received on Thu Nov 05 1998 - 05:38:22 CST