pl/sql 远程连接oracl服务器方法

在Oracle/network/admin中的tnsnames.ora中添加对应的如下代码:
  LISTENER_ORCL =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.25.51.209)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )
其中LISTENTER_ORCL为随意名称。SERVICE_NAME是对应的sid

posted @ 2018-07-31 15:31  泛舟青烟  阅读(129)  评论(0编辑  收藏  举报