Re: databse link... not connecting

Marco BANO wrote in message <3714795F.450B315C_at_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.

Newer versions of SQLNet (might be some other product, but I think it's enforced in SQLNet) require the DBLink name to be the same as the destination database name (from V$DATABASE). Thus for database A to create a DBLink to database B, regardless of the TNSNames.ORA aliases or the SIDs, the DBLink HAS to be named B, to match the actual name of the B database.

There was something else in the documentation that allows you to attach extra tags to your DBLink for when you have multiple DBLinks to the same remote database (for example they log in as different users.) I can't remember exactly what the format was but it would be something like naming the DBLink foo_at_b or foo.b or b_at_foo or b.foo or some thing like that. You might find it in the DBA guides; don't think it was in the CREATE DATABASE LINK command reference.

...Ru Received on Wed Apr 14 1999 - 10:50:58 CDT