oracle RAC 診斷叢集狀態命令
----------crsctl check 命令 ------------
$ crsctl check has ##檢查has元件狀態
CRS-4638: Oracle High Availability Services is online
$ crsctl check crs ##檢查crs元件狀態
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
$crsctl query crs activeversion ## 列出Oracle Clusterware操作版本
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
$crsctl query crs releaseversion ## 列出Oracle Clusterware發行版本
Oracle High Availability Services release version on the local node is [11.2.0.4.0]
$ crsctl query crs softwareversion ## 列出已安裝的Oracle Clusterware軟體的版本
Oracle Clusterware version on node [node1] is [11.2.0.4.0]
$ crsctl query crs softwareversion -all
Oracle Clusterware version on node [node1] is [11.2.0.4.0]
Oracle Clusterware version on node [node2] is [11.2.0.4.0]
$ crsctl query css votedisk ## 列出群集同步服務使用的裁決檔案
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 2dea0d4c4b964fa8bf51ee03537ca179 (/dev/asm-diskaq) [CRS]
2. ONLINE 70e8ca3eaa164f7bbf3d10a78cc7aa24 (/dev/asm-diskap) [CRS]
3. ONLINE 4f9f14a9d17a4f1dbf712cfefa75c345 (/dev/asm-diskar) [CRS]
$ crsctl query crs administrator ## 顯示管理員列表
CRS Administrator List: *
---------crsctl statu 可以顯示RAC叢集元件的相關資訊------------
$ crsctl status serverpool
NAME=Free
ACTIVE_SERVERS=
NAME=Generic
ACTIVE_SERVERS=node1 node2
NAME=ora.test
ACTIVE_SERVERS=node1 node2
$ crsctl status serverpool -p
NAME=Free
IMPORTANCE=0
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=
PARENT_POOLS=
EXCLUSIVE_POOLS=
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r-x
NAME=Generic
IMPORTANCE=0
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=node1 node2
PARENT_POOLS=
EXCLUSIVE_POOLS=
ACL=owner:grid:r-x,pgrp:oinstall:r-x,other::r-x
NAME=ora.test
IMPORTANCE=1
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=node1 node2
PARENT_POOLS=Generic
EXCLUSIVE_POOLS=
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
$ crsctl status serverpool ora.test -p
NAME=ora.test
IMPORTANCE=1
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=node1 node2
PARENT_POOLS=Generic
EXCLUSIVE_POOLS=
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
-------srvctl status 可以顯示叢集關係的相關資源的狀態資訊----------
$ srvctl status server -n node2,node1
Server name: node2
Server state: ONLINE
Server name: node1
Server state: ONLINE
$ srvctl status database -d test
Instance test1 is running on node node1
Instance test2 is running on node node2
$srvctl status instance -d test-i test1
Instance test1 is running on node node1
$ srvctl status nodeapps
VIP test_vip1 is enabled
VIP test_vip1 is running on node: node1
VIP test_vip2 is enabled
VIP test_vip2 is running on node: node2
Network is enabled
Network is running on node: node1
Network is running on node: node2
GSD is disabled
GSD is not running on node: node1
GSD is not running on node: node2
ONS is enabled
ONS daemon is running on node: node1
ONS daemon is running on node: node2
$ srvctl status nodeapps -n node1
VIP test_vip1 is enabled
VIP test_vip1 is running on node: node1
Network is enabled
Network is running on node: node1
GSD is disabled
GSD is not running on node: node1
ONS is enabled
ONS daemon is running on node: node1
$ srvctl status asm
ASM is running on node2,node1
$srvctl status diskgroup -g DATA
Disk Group DATA is running on node2,node1
$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): node2,node1
$ srvctl status listener -n node2
Listener LISTENER is enabled on node(s): node2
Listener LISTENER is running on node(s): node2
$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node node2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node node1
$ srvctl status scan -i 1
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node node2
$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node node2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node node1
$ srvctl status scan_listener -i 1
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node node2
$ srvctl status vip -n node2
VIP test_vip2 is enabled
VIP test_vip2 is running on node: node2
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31519308/viewspace-2706856/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 小知識:使用oracle使用者檢視RAC叢集資源狀態Oracle
- rac叢集日常維護命令
- 診斷叢集的潛在問題
- 【巨杉資料庫SequoiaDB】巨杉Tech | 四步走,快速診斷資料庫叢集狀態資料庫
- oracle 11.2.0.4 rac叢集等待事件enq: TM - contentionOracle事件ENQ
- Oracle叢集(RAC)時間同步(ntp和CTSS)Oracle
- ORACLE診斷案例Oracle
- Oracle RAC日常運維-NetworkManager導致叢集故障Oracle運維
- 【ASK_ORACLE】Relink RAC叢集詳細步驟Oracle
- Oracle Linux 6.7中 Oracle 11.2.0.4 RAC叢集CRS異常處理OracleLinux
- oracle rac的scan監聽狀態Not All Endpoints RegisteredOracle
- 沃趣微講堂 | Oracle叢集技術(二):GI與Oracle RACOracle
- Oracle診斷事件列表(轉)Oracle事件
- 用更雲原生的方式做診斷|大規模 K8s 叢集診斷利器深度解析K8S
- oracle 12C RAC 12.1.0.2 叢集日誌(cluster log)目錄Oracle
- oracle之 redo過高診斷Oracle
- 9 Oracle Data Guard 故障診斷Oracle
- Oracle診斷案例-Sql_traceOracleSQL
- [20191113]一行命令瞭解rac執行狀態.txt
- Mac OSX網路診斷命令Mac
- 設定gbase叢集節點離線狀態
- ORACLE RAC 11.2.0.4 FOR RHEL6叢集無法啟動的處理Oracle
- Oracle 12.1.0.2 impdp匯入慢診斷Oracle
- MongoDB分片叢集節點狀態stateStr:RECOVERING解決MongoDB
- Oracle 例項和RAC叢集下資料庫日誌目錄合集Oracle資料庫
- Oracle RAC叢集解除安裝步驟Oracle
- Kubernetes 叢集中 Ingress 故障的根因診斷
- Oracle 11G RAC叢集安裝(3)——安裝OracleOracle
- 一次ORACLE IO效能診斷案例Oracle
- 一次Oracle診斷案例-Spfile案例Oracle
- 私有IP丟失造成Oracle 12C RAC叢集節點不能啟動Oracle
- Oracle 11gR2 RAC 叢集服務啟動與關閉總結Oracle
- PingCAP Clinic 服務:貫穿雲上雲下的 TiDB 叢集診斷服務PingCAPTiDB
- 【RAC】Oracle rac修改IP地址及埠號命令參考Oracle
- 發電機過速診斷研究 - 基於LSTM進行狀態監測
- 使用MTR命令診斷網路問題
- 幾個常用的網路診斷命令
- 在GI安裝完成後檢視叢集狀態時發現,磁碟組狀態不對