SQL-Oracle-创建Dblink

复制代码
create database link DBLINK_IMARK_RAC
  connect to imark identified by  imarkDB12345
  using '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.7.114)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.7.116)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = center)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
复制代码

 

posted @   伍叶春  阅读(294)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示