Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Datbase link doesn't work. Why?
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
*
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 Wed Nov 04 1998 - 11:17:04 CST