PL/SQL Developer连接远程Oracle数据库

转自:http://zhengdu.net/archives/152

一、首先看远程端oracle服务是否启动

fuwu

如果没有启动,请启动oracle服务

ps:创建或者删除oracle监听

YY图片20141219000546

二、远程端oracle配置

 

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = orcl)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

 

三、本地PL/SQL Developer配置

 

SERVER10 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

 

现在就可以用PL/SQL Developer连接远程Oracle数据库了。

posted @ 2014-12-22 14:28  11hxian.com  阅读(171)  评论(0编辑  收藏  举报