Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Datbase link doesn't work. Why?

Datbase link doesn't work. Why?

From: Stanislav VNUK <vnukst_at_logica.com>
Date: Wed, 4 Nov 1998 18:17:04 +0100
Message-ID: <71q26m$s6a@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 Wed Nov 04 1998 - 11:17:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US