前端之家收集整理的这篇文章主要介绍了
Oracle 11g RAC 监听日常管理,
前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
@H_
404_0@需要必须掌握的命令,上周遇到了一个小问题,就是需要重启
数据库监听,有的同学竟然使用oracle
用户重启监听,原理就搞错了怎么行。以下操作都需要再grid
用户下进行操作。
@H_
404_0@1、查看监听状态
<roidb2:+ASM2:/home/grid>$srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): roidb1,roidb2
<roidb2:+ASM2:/home/grid>$srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node roidb2
<roidb2:+ASM2:/home/grid>$
@H_
404_0@2、
关闭监听
<roidb2:+ASM2:/home/grid>$srvctl stop listener -n roidb1
<roidb2:+ASM2:/home/grid>$srvctl status listener -n roidb1
Listener LISTENER is enabled on node(s): roidb1
Listener LISTENER is not running on node(s): roidb1
<roidb2:+ASM2:/home/grid>$
<roidb2:+ASM2:/home/grid>$srvctl stop scan_listener
<roidb2:+ASM2:/home/grid>$srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
<roidb2:+ASM2:/home/grid>$
@H_
404_0@3、启动监听
<roidb2:+ASM2:/home/grid>$srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): roidb1,roidb2
<roidb2:+ASM2:/home/grid>$srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node roidb2
<roidb2:+ASM2:/home/grid>$