Useful commands for Manage Oracle RAC Environment

Check Cluster Status in Oracle RAC

crsctl check crs

crsctl check cluster -all

crsctl check has

Check cluster resources

crsctl stat res -t

NAME           TARGET  STATE        SERVER
ora.orcl.db    ONLINE  ONLINE       node1
ora.orcl.db    ONLINE  ONLINE       node2
...

-- Add detail view:
crsctl stat res -w -t

crsctl stat res -t | egrep "SCAN|VIP|services"

It shows:

• Resource name
• Target/Current state
• Node location
• Type of resource
• Details of services

Check version of clusterware

crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [19.0.0.0.0]

-- Check software version:
crsctl query crs softwareversion

Oracle Clusterware version on node node1 is [19.0.0.0.0]

Check Component Versions in RAC

olsnodes -v

olsnodes -c

Find Cluster home name

crsctl get crs home

Check the status of cluster ware services.

crsctl check crs

CRS-4638: Oracle High Availability Services is online
CRS-4535: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4530: Event Manager is online

crsctl check has

CRS-4638: Oracle High Availability Services is online

Check Entire Cluster Status on All Nodes

crsctl check cluster -all

Stop all the service of cluster

crsctl stop cluster -all

Start the cluster services

crsctl stop cluster -all

Check the status of crs

crsctl check crs

Check the location of OCR disk

ocrcheck

Check the status of votedisk

crsctl query css votedisk

Start the crs if not running

crsctl start crs

Check the status of crs

crsctl check crs

To stop or start CRS in Cluster

crsctl stop cluster -all
crsctl start cluster -all

Check the number of nodes in RAC

olsnodes -n

Start the crs resource in RAC

-- on single node command
crsctl start crs

-- on all nodes
crsctl start cluster -all

Check the thread is present in RAC

SELECT inst_id, instance_name, thread# 
FROM gv$instance;

Check the Redo log file present in RAC with Thread

SELECT group#, thread#, status, bytes/1024/1024 AS size_mb
FROM v$log
ORDER BY thread#, group#;

For enable the thread three for redo logs

alter database enable public thread 3;

Enabled now:

select thread#,status,enabled,instance from v$thread;

THREAD# STATUS ENABLED  INSTANCE
------- ------ -------- --------
1       OPEN   PUBLIC   ORCL_1
2       OPEN   PUBLIC   ORCL_2
3       CLOSED PUBLIC	ORCL_3

Note: Closed means instance is not started yet.