RAC正确配置监听的方式

来源：互联网发布：linux在线安装vsftpd 编辑：程序博客网时间：2024/05/17 23:14

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