DBA Handy 19c grid Cluster manage Comands with snaps.

Dear All,

In this post will share the Cluster status hands-on commands for day to day work..

oracle clusterware resources and components we can mange with CRSCTL Utility.

1. How to connect to opc instance and switch to Grid user .

sudo su - grid

2.How to  stop and start Cluster : ( run from root user) to check the cluster status you can connect grid user and and set the grid home and check it , you can connect to root user if you want to stop and start the cluster services .

Note :  we have to stop the all the running database instnace prior to Cluster stop .

$GRID_HOME/bin/crsctl stop crs

$GRID_HOME/bin/crsctl start crs

3. Enable/Disable auto restart of CRS.

$GRID_HOME/bin/crsctl disable crs

$GRID_HOME/bin/crsctl enable crs

4. we can Find the cluster name by using below commands.

$GRID_HOME/bin/cemutlo -n

or

$GRID_HOME/bin/olsnodes -c

5.how to  Find the grid version:

 $GRID_HOME/bin/crsctl query crs softwareversion 

$GRID_HOME/bin/crsctl query crs softwareversion devdb01

[grid@devdb01 grid]$ crsctl query crs softwareversion devdb01

Oracle Clusterware version on node [devdb01] is [19.0.0.0.0]

6. check cluster component status

$GRID_HOME/bin/crsctl stat res -t

$GRID_HOME/bin/crsctl check crs

$GRID_HOME/bin/crsctl check crsd

$GRID_HOME/bin/crsctl check cssd

$GRID_HOME/bin/crsctl check evmd

7. Find voting disk and OCR location

$GRID_HOME/bin/crsctl query css votedisk

$GRID_HOME/bin/ocrcheck

8. Find cluster interconnect details

$GRID_HOME/bin/oifcfg getif

select NAME,IP_ADDRESS from v$cluster_interconnects;

 9. Check CRS status of local node and staus of  all crs resourcs

crsctl check crs

$GRID_HOME/bin/crsctl stat res -t

$GRID_HOME/bin/crsctl stat res -t -init

10. Stop and start high availability service ( HAS)

crsctl stop has

crsctl start has

11. Check CRS status of remote nodes

crsctl check cluster

crsctl check cluster -all

12. Disk timeout from node to voting disk(disktimeout) and Network latency in the node interconnect (Misscount)

crsctl get css disktimeout

crsctl get css misscount

crsctl replace votedisk +OCRVD

13. Add , Delete , another voting disk:

crsctl add css votedisk

crsctl delete css votedisk

14 . Get ocr disk backup details and Check whether standard or flex ASM

ocrconfig -showbackup

crsctl get cluster mode status

15 . Check CRS /cluster configuration information:

crsctl config crs

crsctl get cluster configuration

16 .Node roles in cluster

crsctl get node role status -all

17. crsctl has commands for standalone grid infrastrcuture

crsctl check has

crsctl config has

crsctl disable has

crsctl enable has

crsctl query has releaseversion

crsctl query has softwareversion

crsctl start has

crsctl stop has

Thanks,

Srini