Problems creating Db-links

From: popop <poppop_at_ole.com>
Date: Wed, 11 Aug 1999 13:17:01 +0200
Message-ID: <7ormcd$2ek$1@diana.bcn.ttd.net>

We have two machines running different instances of Oracle. One is a NT running Oracle 8.0.5.0.0 and the other is a Sun running Oracle 8.0.4.0.0.

The NT machine is called BACUS. His db_name is 'SGI' and his db_domain
'WORLD'.
The Sun machine is called AKIRA. His db_name is 'SIG' and his db_domain
'WORLD'.
We want to create a dblink from BACUS to AKIRA named 'akira'. We want to do "select sysdate from dual_at_akira", for example.

We also have defined 'BACUS' in the TNSNAMES.ORA file like this

BACUS.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 13.291.322.234)(PORT = 1521))     (CONNECT_DATA = (SID = SGI))
  )

If we try to do it with the sentence:

CREATE PUBLIC DATABASE LINK BACUS CONNECT TO JARL IDENTIFIED BY MYPASSWD USING 'BACUS'; and we try the sentence

select sysdate from dual_at_bacus;

we receive the following error:

Ora-02085: Database link BACUS.WORLD connects to SGI.WORLD

If we try to name the databaselink "SGI" instead of "BACUS" and we try

select sysdate from dual_at_SGI;
it works well!

But we don't want this name. We wan't to call it "BACUS".

Any ideas?

Thank you! Received on Wed Aug 11 1999 - 06:17:01 CDT