Re: Datbase link doesn't work. Why?

Make sure that you have the PROD entry in the $ORACLE_HOME/network/admin/TNSNAMES.ORA file on the server on which you are creating the link. It is not sufficient to only have the PROD entry in the TNSNAMES.ORA file on the clients. Also make sure that your database has the distributed option.

M Zia, Toronto, Canada.
mqzia_at_sprint.ca

Stanislav VNUK <vnukst_at_logica.com> wrote in article <71q26m$s6a_at_romeo.logica.co.uk>...
> 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 Fri Nov 13 1998 - 20:37:54 CST