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

Home -> Community -> Usenet -> c.d.o.misc -> databse link... not connecting

databse link... not connecting

From: Marco BANO <bano_at_eumetsat.de>
Date: Wed, 14 Apr 1999 13:17:51 +0200
Message-ID: <3714795F.450B315C@eumetsat.de>


why I have in tnsnames.ora:

alias that point to host xxx sid yyy

in sqlplus user_at_alias it works ok.

when I create databse link .. pippo using 'alias'

and I try select table_at_databaselink...
it gives me:

error at line 1
ORA-02085 databselink pippo.world connects to yyy.world.

Any ideas .. I think in the way tnsnames is written

ok my client is 7.3.4 and server 8.0.5

THANK you
--
Marco BANO
Network administrator Consultant
EUMETSAT
Am Kavalleriesand 31
64295 DARMSTADT
Germany

Office : ++49 6151 807536 Received on Wed Apr 14 1999 - 06:17:51 CDT

Original text of this message

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