oracle RAC 診斷叢集狀態命令

sambatuzi發表於2020-07-24

----------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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章