Oracle 11g RAC 監聽日常管理

標籤：roi   oracl   操作   重啟   listener   can   資料   acl   run   

需要必須掌握的命令，上周遇到了一個小問題，就是需要重啟資料庫監聽，有的同學竟然使用oracle使用者重啟監聽，原理就搞錯了怎麼行。以下操作都需要再grid使用者下進行操作。

1、查看監聽狀態

<roidb2:+ASM2:/home/grid>$srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): roidb1,roidb2<roidb2:+ASM2:/home/grid>$srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is running on node roidb2<roidb2:+ASM2:/home/grid>$

2、關閉監聽

<roidb2:+ASM2:/home/grid>$srvctl stop listener -n roidb1<roidb2:+ASM2:/home/grid>$srvctl status listener -n roidb1Listener LISTENER is enabled on node(s): roidb1Listener 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_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is not running<roidb2:+ASM2:/home/grid>$

3、啟動監聽

<roidb2:+ASM2:/home/grid>$srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): roidb1,roidb2<roidb2:+ASM2:/home/grid>$srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is running on node roidb2<roidb2:+ASM2:/home/grid>$

Oracle 11g RAC 監聽日常管理