Category Archives: Oracle

In this we are handling Oracle Database Administration and development task. If provide solution of ORA Errors and configuration Steps for setup in Oracle.

Oracle RAC Clusterware – Quick Command Sheet

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`