Oralce集群管理-RAC环境监听配置管理LOCAL_LISTENER

原创已于 2022-07-01 11:24:51 修改 · 1.6k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库 #服务器

于 2019-09-29 16:03:12 首次发布

ORACLE数据库RAC管理专栏收录该内容

134 篇文章

订阅专栏

本文详细介绍了在Oracle环境中如何配置监听器以监听多个端口，并通过srvctl命令进行监听器的添加与启动。同时，深入探讨了如何配置静态注册和动态注册，确保数据库实例能在不同端口上被正确识别与连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一个监听多个端口

LISTENER5=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST= 10.22)(PORT=1526)(RATE_LIMIT=YES))
(ADDRESS=(PROTOCOL=tcp)(HOST= 10.22)(PORT=1527)(RATE_LIMIT=YES))

(ADDRESS=(PROTOCOL=tcp)(HOST= 10.22)(PORT=1528)(RATE_LIMIT=YES))

(ADDRESS=(PROTOCOL=tcp)(HOST= 10.22)(PORT=1529)(RATE_LIMIT=YES))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc1555))))

1 添加监听程序

srvctl add listener -l listener_monidb -p 1522
srvctl add listener -l listener_app1 -p 1523

srvctl start listener -l listener_monidb
srvctl start listener -l listener_app1

2 配置程序静态注册

SID_LIST_LISTENER_monidb =
(SID_LIST=
(SID_DESC =
(GLOBAL_DBNAME=STD)
(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)
(SID_NAME=monidb1)
))

SID_LIST_LISTENER_ap1 =
(SID_LIST=
(SID_DESC =
(GLOBAL_DBNAME=STD)
(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)
(SID_NAME=monidb1)
))

SID_LIST_LISTENER_ap2 =
(SID_LIST=
(SID_DESC =
(GLOBAL_DBNAME=STD)
(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)
(SID_NAME=monidb1)
))

SID_LIST_LISTENER_ap3 =
(SID_LIST=
(SID_DESC =
(GLOBAL_DBNAME=STD)
(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1)
(SID_NAME=monidb1)
))

3 配置local_listener动态注册

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.224.10)(PORT=1521))','(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.224.10)(PORT=1522))','(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.224.10)(PORT=1523))','(ADDRESS=(PROTOCOL=TCP)(HOST=1
0.2.224.10)(PORT=1524))','(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.224.10)(PORT=1526))' sid='monidb1';

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.8.224.11)(PORT=1521))','(ADDRESS=(PROTOCOL=TCP)(HOST=10.8.224.11)(PORT=1522))','(ADDRESS=(PROTOCOL=TCP)(HOST=10.8.224.11)(PORT=1523))','(ADDRESS=(PROTOCOL=TCP)(HOST=1
0.8.224.11)(PORT=1524))','(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.224.11)(PORT=1526))' sid='monidb2';

测试停止1521端口本地地址，启动1522,1523,1524本地地址和1521的scan地址是否可以仍然进行数据库连接?

srvctl stop listener -l listener

客户plsql仍然能够连接

[grid@gzrac01 admin]$ netstat -an|grep 155
tcp 0 0 10.2.224.10:1526 10.2.15.14:51764 ESTABLISHED
tcp 0 52 10.2.224.4:22 10.2.15.35:3384 ESTABLISHED
tcp 0 0 10.2.224.10:1523 10.2.15.15:50155 ESTABLISHED