Connection String in DBLINK
627703Jan 6 2010 — edited Jan 8 2010Hi,
I created two dblinks in Oracle 10.2.0.2.0 (see below), DB_LINK2 works but DB_LINK1 does not work although they use the same account/password to connect to the same database. How to make it work?
1) CREATE DATABASE LINK DB_LINK1
CONNECT TO user1 IDENTIFIED BY 'password1'
USING 'DB_NAME';
With DB_NAME defined in tnsname.ora of the server
2) CREATE DATABASE LINK DB_LINK2
CONNECT TO user1 IDENTIFIED BY 'password1'
USING '(DESCRIPTION = (SDU = 32768) (enable = broken) (LOAD_BALANCE = yes) (ADDRESS = (PROTOCOL = TCP)(HOST = g80.xx.ff.com)(PORT = 1525)) (ADDRESS = (PROTOCOL = TCP)(HOST = g81.xx.ff.com)(PORT = 1525)) (CONNECT_DATA = (SERVICE_NAME = DB_NAME)))';
Thanks
Liz