Show Menu
Cheatography

Oracle RAC Cheat Sheet (DRAFT) by [deleted]

Oracle RAC

This is a draft cheat sheet. It is a work in progress and is not finished yet.

RAC Status

Show all
crsctl stat res -t
Databases Only
crsctl stat res -t -w "TYPE = ora.da­tab­ase.ty­pe"
Listeners Only
crsctl stat res -t -w "TYPE = ora.li­ste­ner.ty­pe"
Res Details
crsctl stat res <re­sou­rce> -f

RAC Stoppi­ng/­Sta­rting

Stop DB
srvctl stop database -d <Uniq Name> -o immediate
Stop Instance
srvctl stop instance -d <Uniq Name> -i <in­st>-o immediate
Stop CRS
as root. crsctl stop crs
Start CRS
as root. crsctl start crs
 

RAC Create Resource

 

RAC Acronyms

CRS
Cluster Ready Service.
OCR
Oracle Cluster Registery