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

最新推荐文章于 2024-09-25 11:06:23 发布

Mr.Gu

最新推荐文章于 2024-09-25 11:06:23 发布

阅读量101

点赞数

文章标签：数据库网络

原文链接：http://www.cnblogs.com/haifg/p/4178139.html

版权

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

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

fuwu

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

ps：创建或者删除oracle监听

二、远程端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数据库了。

转载于:https://www.cnblogs.com/haifg/p/4178139.html