---- CREATE DATABASE LINK
CREATE PUBLIC DATABASE LINK sjck
CONNECT TO ZJ_WBCX IDENTIFIED BY cx123
USING
'(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxx)
)
CREATE PUBLIC DATABASE LINK sjck
CONNECT TO ZJ_WBCX IDENTIFIED BY cx123
USING
'(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxx)
)
)';
--tnsnames的配置
racdb=
(DESCRIPTION=
(ADDRESS_LIST=
(FAILOVER=on)
(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.88)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.89)(PORT=1521)))
(CONNECT_DATA=
(SERVICE_NAME=racdb)))