oracle创建dblink

语法：

// drop database link lydsj_att;
// 若远程调用存储过程，则需要加 public 关键字
create [public] database link lydsj_att
 connect to user_name identified by "passwd"
  using
'(DESCRIPTION =
			(ADDRESS_LIST =
				(ADDRESS = (PROTOCOL = TCP)(HOST = 132.151.15.98)(PORT = 1521))
				(ADDRESS = (PROTOCOL = TCP)(HOST = 132.151.15.100)(PORT = 1521))
			)
			(CONNECT_DATA =
				(SERVICE_NAME = att)
			)
  )
'

创建dblink时报错：指定为连接标识符的 Net服务名太长

// 原始TNS内容如下， 语法中using后的 ' ' 中内容 直接填 下文中 att= 后的即可。
att=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 132.151.15.98)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 132.151.15.100)(PORT = 1521))
    (LOAD_BALANCE = no)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = att)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )