Hi,
I am trying to create a DB Link FROM a GLOBAL_NAME enabled DB (SrcDB.WORLD) TO a GLOBAL_NAME disabled DB (RmtDB). The problem I am having is the DB link on the source DB appends .WORLD to the DB Link and then expects .WORLD for the remotre DB, and fails with the error:
"ORA-02085: database link RMTDB.WORLD connects to RMTDB"
I unserstand the connection is appending '.WORLD' to the remote DB and it is failling to connect as RMTDB.WORLD does not exist on the remote server. Is there a way of creating the DB link without disabling the global names on the source DB or enabling on the remote DB?
TNSPING and SQLPLUS to the remote DB succeeds.
TnsNames on the SRCDB Server
-------------------------
remotedb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = host1-scan)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RMTDB))
)
DB Link on SRCDB.WORLD pointing to RMTDB
-----------------------
DATABASE LINK RMTDB
CONNECT TO SCOTT
IDENTIFIED BY secret
USING 'remotedb';
RMTDB
-----------
SQL> show parameter global_name
NAME TYPE VALUE
global_names boolean
SRCDB
-----------
SQL> show parameter global_name
NAME TYPE VALUE
global_names boolean TRUE
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB.WORLD