RAC正确配置监听的方式

关注

原创最新推荐文章于 2026-03-11 14:36:59 发布 2.2k 阅读 AI 写同款· GEO 优化 ›

Oracle Rac Scan 负载均衡问题 Oracle Rac Scan 负载均衡问题问题描述问题复现现象观察现象分析解决方法再次验证问题描述客户生产环境上出现问题如下：应用程序配置了load_balance负载均衡； Oracle Rac集群上所有的会话都负载到了节点上1上，而节点2基本无会话连接问题复现 # 1. 服务器上的监听配置如下 [grid@rac1 ~]$ cd $ORACLE_HOME/network/admin [grid@rac1 admin]$ cat listener.ora LISTENER=(DESCRIPT 阅读详情

1 配置监听和检测配置监听是否正确

此操作只需要在一个节点中操作即可

[grid@qnsdb1 ~]$ srvctl remove listener
PRCR-1001 : Resource ora.LISTENER.lsnr does not exist
[grid@qnsdb1 ~]$ srvctl add listener
[grid@qnsdb1 ~]$ srvctl config listener
Name: LISTENER
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1521
[grid@qnsdb1 ~]$ srvctl start listener
[grid@qnsdb1 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): qnsdb2,qnsdb3,qnsdb1

2 配置监听文件

[grid@qnsdb1 admin]$ pwd
/u01/11.2.0/grid/product/network/admin
[grid@qnsdb1 admin]$ more listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line a
dded by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent

3 查看各节点的情况

[grid@qnsdb1 admin]$ ps -ef|grep inh
grid     12387     1 0 Nov19 ?        00:00:11 /u01/11.2.0/grid/product/bin/tnslsnr LISTENER_SCAN1 -inherit
grid     14867     1 0 21:40 ?        00:00:00 /u01/11.2.0/grid/product/bin/tnslsnr LISTENER_SCAN1 -inherit
grid     17467     1 0 21:49 ?        00:00:00 /u01/11.2.0/grid/product/bin/tnslsnr LISTENER -inherit

[oracle@qnsdb2 ~]$ ps -ef|grep inh
grid 395 1 0 21:50 ? 00:00:00 /u01/11.2.0/grid/product/bin/tnslsnr LISTENER -inherit
oracle 6606 6568 0 22:17 pts/1 00:00:00 grep inh

收录于