Oracle 11g RAC 監聽日常管理
需要必須掌握的命令,上週遇到了一個小問題,就是需要重啟資料庫監聽,有的同學竟然使用oracle使用者重啟監聽,原理就搞錯了怎麼行。以下操作都需要再grid使用者下進行操作。
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>$
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>$
3、啟動監聽
<roidb2:+ASM2:/home/grid>$srvctl start listener Listener LISTENER is enabled Listener LISTENER is running on node(s): roidb1,roidb2 <roidb2:+ASM2:/home/grid>$srvctl start scan_listener SCAN Listener LISTENER_SCAN1 is enabled SCAN listener LISTENER_SCAN1 is running on node roidb2 <roidb2:+ASM2:/home/grid>$
srvctl stop scan_listener
srvctl start scan_listener
srvctl status scan_listener
srvctl stop listener -n dcdbrac2
srvctl start listener -n dcdbrac2
srvctl status listener -n dcdbrac2
srvctl stop listener -n dcdbrac1
srvctl start listener -n dcdbrac1
srvctl status listener -n dcdbrac1
先啟動本地監聽,最後啟動 scan_listener
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/196700/viewspace-2220681/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle RAC日常管理命令Oracle
- 11g rac監聽配置解析
- 【原創】Oracle RAC 日常管理Oracle
- Oracle RAC 日常管理之CRS篇Oracle
- Oracle 11g 修改監聽埠Oracle
- oracle 11g 監聽檔案Oracle
- Oracle RAC 日常管理之CRS篇-3Oracle
- Oracle RAC 日常管理之CRS篇-2Oracle
- oracle rac scan監聽更改埠號Oracle
- 【RAC】lsnrctl 工具不適合管理監聽
- oracle 11g tns和監聽配置Oracle
- oracle 11G Rac service管理Oracle
- Oracle RAC Database 11.1.0.6監聽故障案例OracleDatabase
- Oracle 11g 檢視監聽日誌Oracle
- Oracle 11g 監聽相關檔案Oracle
- Oracle 10G R2 RAC 日常管理Oracle 10g
- Oracle 10G R2 RAC日常管理Oracle 10g
- Oracle10g RAC ASM 環境日常管理OracleASM
- rac scan listener log 清理監聽日誌 oracleOracle
- 【Oracle】11g RAC R2 日常巡檢--GridOracle
- Oracle RAC 日常維護Oracle
- oracle rac的scan監聽狀態Not All Endpoints RegisteredOracle
- Oracle 10g RAC客戶端配置監聽Oracle 10g客戶端
- Oracle 監聽Oracle
- Oracle 監聽器日誌配置與管理Oracle
- oracle 11g 修改預設監聽埠1521Oracle
- 關於oracle11g RAC 監聽器問題Oracle
- oracle 10g rac當監聽程式監聽對方vip時啟動監聽報錯TNS-12545Oracle 10g
- 管理oracle 11g RAC 常用命令Oracle
- rac監聽動態註冊
- Oracle DBA 日常管理Oracle
- Oracle監聽(1)Oracle
- [zt] 在Oracle11g RAC中加入靜態監聽Oracle
- ORACLE動態監聽與靜態監聽Oracle
- oracle靜態監聽和動態監聽Oracle
- 【oracle】動態監聽與靜態監聽Oracle
- Oracle RAC日常基本維護命令Oracle
- 12C RAC 修改監聽埠