Below is a Quick Command Sheet for Oracle RAC / Clusterware in a single table — clean, ready to save/print.
Oracle RAC Command Sheet
Clusterware / CRS Commands
| Purpose | Command |
|---|
| Check Cluster Status (All Nodes) | crsctl check cluster -all |
| Check Local CRS Daemon | crsctl check crs |
| Start Cluster (All Nodes) | crsctl start cluster -all |
| Stop Cluster (All Nodes) | crsctl stop cluster -all |
| Start CRS Local Node | crsctl start crs |
| Stop CRS Local Node | crsctl stop crs |
| Clusterware Version | crsctl query crs softwareversion |
| Active Cluster Version | crsctl query crs activeversion |
| Clusterware Resource Status (Tree) | crsctl status resource -t |
| Specific Resource Details | crsctl status resource <resource> |
| Online a Resource | crsctl modify resource <resource> -attr "START_TIMEOUT=300" |
| Disable a Resource | crsctl stop resource <resource> |
srvctl Commands
| Purpose | Command |
|---|
| List Database Configuration | srvctl config database -d <db> |
| Check Database Status | srvctl status database -d <db> |
| Start Database | srvctl start database -d <db> |
| Stop Database | srvctl stop database -d <db> |
| List Services | srvctl config service -d <db> |
| Check Service Status | srvctl status service -d <db> |
| Start Service | srvctl start service -d <db> -s <service> |
| Stop Service | srvctl stop service -d <db> -s <service> |
| Listener Configuration | srvctl config listener -n <node> |
| Listener Status | srvctl status listener -n <node> |
| Start Listener | srvctl start listener -n <node> |
| Stop Listener | srvctl stop listener -n <node> |
| ASM Status | srvctl status asm -n <node> |
| ASM Config | srvctl config asm |
| Scan Status | srvctl status scan |
| Scan Listener Status | srvctl status scan_listener |
| SCAN Config | srvctl config scan |
| Nodeapps Status | srvctl status nodeapps -n <node> |
| VIP Status | srvctl status vip -n <node> |
OLSNODES Commands
| Purpose | Command |
|---|
| List Nodes | olsnodes |
| List Node With VIP | olsnodes -n |
| List Nodes With Status | olsnodes -s |
| List Hardware Address | olsnodes -t |
| Find Cluster Name | olsnodes -c |
| Find Inventory Loc | olsnodes -i |
ASM Commands
| Purpose | Command |
|---|
| List Diskgroups | asmcmd lsdg |
| List Disks | asmcmd lsdsk |
| Add Disk | ALTER DISKGROUP DG1 ADD DISK '/dev/sdX'; |
| Drop Disk | ALTER DISKGROUP DG1 DROP DISK <disk>; |
| Mount Diskgroup | ALTER DISKGROUP DG1 MOUNT; |
| Dismount Diskgroup | ALTER DISKGROUP DG1 DISMOUNT; |
| Check Power Limit | ALTER DISKGROUP DG1 REBALANCE POWER 8; |
OCR Commands
| Purpose | Command |
|---|
| OCR Check | ocrcheck |
| OCR Backup List | ocrconfig -showbackup |
| Manual OCR Backup | ocrconfig -manualbackup |
| Export OCR | ocrconfig -export <file> |
| Import OCR | ocrconfig -import <file> |
Voting Disk
| Purpose | Command |
|---|
| List Voting Disks | crsctl query css votedisk |
Network / SCAN / VIP
| Purpose | Command |
|---|
| SCAN Status | srvctl status scan |
| SCAN Listener Status | srvctl status scan_listener |
| VIP Status | srvctl status vip -n <node> |
| GPNP Status | srvctl status gpnptool |
Diagnostic Tools
| Purpose | Command |
|---|
| CRS Logs | tail -f $GRID_HOME/log/<node>/crsd/crsd.log |
| ASM Logs | tail -f $GRID_HOME/log/<node>/asm/alert+ASM.log |
| Cluster Dump | oradebug ipc |
| Cluster Health Monitor | chmos run |
| ADRCI Home List | adrci> show homes |
| ADRCI Show Alert | adrci> show alert |
Database Services
| Purpose | Command |
|---|
| Create Service | srvctl add service -d <db> -s <service> -r "<instances>" |
| Remove Service | srvctl remove service -d <db> -s <service> |
Resource Management
| Purpose | Command |
|---|
| List All Resources | crsctl status resource -t |
| Resource Details | crsctl status resource <name> |
| Resource Modify | srvctl modify service ... |
Cluster Interconnect
| Purpose | Command |
|---|
| Check Network | oifcfg getif |
| Show Interfaces | oifcfg iflist |
Node Operations
| Purpose | Command |
|---|
| Reboot Node | reboot |
| Shutdown Node | shutdown -h now |
Useful Scripts
| Purpose | Command |
|---|
| Get All Resources | crsctl status resource -t |
| Verify DB Instances | srvctl status database -d <db> |
| Logs Directory | $GRID_HOME/log |
Bonus: Useful Paths
| Item | Path |
|---|
| Grid Home | $GRID_HOME |
| Oracle Home | $ORACLE_HOME |
| ADRCI | $ORACLE_BASE/diag |
| Cluster Logs | $GRID_HOME/log/<node>/ crsd.log |
Related