阿宽

Nothing is more powerful than habit!
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

Oralce 無法連接遠端數據庫解決

Posted on 2008-05-29 14:47  宽田  阅读(296)  评论(0)    收藏  举报
修改tnsnames.ora文件:在CONNECT_DATA 中加入(server = dedicated)
例:
sh2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 192.168.0.132)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (server = dedicated) (SID = sh2)
    )
  )