创建dblink与tnsnames的配置

---- 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)
       )

    )';

--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)))