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 11g rac 叢集操作命令Oracle
- Oracle10g RAC叢集基本命令Oracle
- 小知識:使用oracle使用者檢視RAC叢集資源狀態Oracle
- Oracle10g RAC叢集基本命令(轉)Oracle
- 【RAC】Oracle Clusterware 診斷收集指令碼Oracle指令碼
- rac叢集日常維護命令
- 【巨杉資料庫SequoiaDB】巨杉Tech | 四步走,快速診斷資料庫叢集狀態資料庫
- ORACLE 11G RAC--叢集應用層命令掃盲Oracle
- RAC常見命令檢查狀態
- RAC常用管理命令--查詢RAC叢集各種資訊命令-更新中
- RAC故障診斷指令碼指令碼
- 如何檢視Oracle RAC叢集的叢集名稱(CLUSTER NAME)Oracle
- Oracle系列:Oracle RAC叢集體系結構Oracle
- ORACLE 11G RAC--維護叢集的OCR命令介紹Oracle
- Oracle RAC維護命令集Oracle
- Oracle RAC叢集、程式、日誌簡介Oracle
- 3 安裝配置oracle叢集和RACOracle
- 【RAC】使用crsctl工具控制Oracle RAC叢集的啟停Oracle
- OracleRAC管理 之 叢集狀態&資訊檢視Oracle
- 收集Oracle RAC跟蹤診斷資訊的幾個工具Oracle
- 用更雲原生的方式做診斷|大規模 K8s 叢集診斷利器深度解析K8S
- ORACLE診斷案例Oracle
- Oracle故障診斷Oracle
- ORACLE診斷事件Oracle事件
- Oracle叢集(RAC)時間同步(ntp和CTSS)Oracle
- Oracle RAC 10g叢集節點增加Oracle
- 轉OracleRAC管理 之 叢集狀態&資訊檢視Oracle
- 轉 OracleRAC管理 之 叢集狀態&資訊檢視Oracle
- iostat -x命令診斷iOS
- RAC更改叢集VIP
- streams capture狀態PAUSED FOR FLOW CONTROL原因分析和診斷APT
- 如何診斷RAC系統中的
- 【RAC】Oracle RAC叢集環境下日誌檔案結構Oracle
- oracle 效能診斷工具Oracle
- Oracle診斷事件列表Oracle事件
- ORACLE診斷事件(zt)Oracle事件
- ORACLE RAC叢集配置管理工具-SRVCTLOracle
- ORACLE 11g RAC 叢集互連延遲Oracle