需要必須掌握的命令，上周遇到了一個小問題，就是需要重啟數(shù)據(jù)庫監(jiān)聽，有的同學(xué)竟然使用oracle用戶重啟監(jiān)聽，原理就搞錯了怎么行。以下操作都需要再grid用戶下進(jìn)行操作。

堅(jiān)守“ 做人真誠 · 做事靠譜 · 口碑至上 · 高效敬業(yè) ”的價值觀，專業(yè)網(wǎng)站建設(shè)服務(wù)10余年為成都成都宴會酒店設(shè)計小微創(chuàng)業(yè)公司專業(yè)提供成都定制網(wǎng)頁設(shè)計營銷網(wǎng)站建設(shè)商城網(wǎng)站建設(shè)手機(jī)網(wǎng)站建設(shè)小程序網(wǎng)站建設(shè)網(wǎng)站改版，從內(nèi)容策劃、視覺設(shè)計、底層架構(gòu)、網(wǎng)頁布局、功能開發(fā)迭代于一體的高端網(wǎng)站建設(shè)服務(wù)。

1、查看監(jiān)聽狀態(tài)

$srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): roidb1,roidb2
$srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node roidb2
$

2、關(guān)閉監(jiān)聽

$srvctl stop listener -n roidb1
$srvctl status listener -n roidb1
Listener LISTENER is enabled on node(s): roidb1
Listener LISTENER is not running on node(s): roidb1
$
$srvctl stop scan_listener
$srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
$

3、啟動監(jiān)聽

$srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): roidb1,roidb2
$srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node roidb2
$