oracle动态注册和静态注册监听器

50次阅读

共计 1545 个字符，预计需要花费 4 分钟才能阅读完成。

自动写代码机器人，免费开通

oracle 动态注册和静态注册的区别：动态监听不需要在 listener.ora 文件中记录关于数据的任何信息，只需要将监听器的配置信息写入到该文件。例如：

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS=(PROTOCOL = IPC) (KEY=EXTPRO1))
(ADDRESS=(PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
)

客户端的 tnsnames.ora 配置信息，需要加入每个 service_name, 其他的任何东西不需要改动，例如

YUCESHI1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test1)
)
)
YUCESHI2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test2)
)
)
YUCESH3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test3)
)
)

动态监听步骤：

服务器端配置如下：

设置 service_names:

alter system set service_names=test1,test2,test3;

2. 编写 listener.ora 文件：

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS=(PROTOCOL = IPC) (KEY=EXTPRO1))
(ADDRESS=(PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
)

3. 重新启动 oracle 实例，这样做才能使 service_names 生效。（前提是 oracle 处于 open 状态下才执行）

conn /as sysdba;

shutdown immediate;

startup;

客户端配置：

1. 编辑 tnsnames.ora, 保存后立即生效。

YUCESHI1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test1)
)
)
YUCESHI2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test2)
)
)
YUCESH3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test3)
)
)