db link 连接不上

  identified by xx    --密码

  using ‘(DESCRIPTION =
    (source_route = yes)
    (ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1521))   ----对方数据库的ip，和端口
    (ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1521))     -----本地数据库的ip和端口
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)    ---本地数据库名
    )
  )‘;

db link 连接不上

标签：