RAC
How to check session memory across all RAC instances in Oracle
Rank Oracle sessions by PGA memory across every RAC instance from GV$SESSTAT.
How to get a compact RAC status overview with rac-status.sh
Colored terminal overview of every database, listener, and service across an Oracle RAC cluster with per-node state, from Fred Denis' rac-status.sh utility.
How to check the voting disk location in Oracle RAC
Show Oracle RAC voting disk locations, state, and ASM disk group from crsctl query css votedisk.
How to list all sessions across all RAC instances in Oracle
List every Oracle session across all RAC instances with instance id, OS user, program, and logon time from GV$SESSION.
How to list OLR backups and take a manual OLR backup in Oracle RAC
List Oracle Local Registry (OLR) backups and take a manual backup with ocrconfig -local.
How to list OCR backups and take a manual OCR backup in Oracle RAC
List Oracle Cluster Registry (OCR) backups from ocrconfig -showbackup and take a manual on-demand backup.
How to check the OLR location and status in Oracle RAC
Show Oracle Local Registry (OLR) location, size, and integrity check from ocrcheck -local.
How to check the RAC cluster status in Oracle
Check Oracle RAC cluster status: all resources with crsctl stat res -t and the core daemons (CRS, CSSD, CRSD, EVMD).
How to check the OCR location and status in Oracle RAC
Show Oracle Cluster Registry (OCR) device locations, size, and integrity check from ocrcheck.
How to check the Grid Infrastructure version in Oracle RAC
Show the Oracle Grid Infrastructure software version with crsctl query crs softwareversion.
How to check the RAC cluster name in Oracle
Get the Oracle RAC cluster name from olsnodes -c.
How to check the cluster interconnect configuration in Oracle RAC
Show Oracle RAC cluster interconnect network interfaces and their roles from oifcfg getif.
How to check session waits across all RAC instances in Oracle
List every Oracle session wait across all RAC instances from GV$SESSION_WAIT, ranked by seconds in wait.