Rac Components
Rac installation
Step By Step: Install 10g R2 RAC on Oracle Enterprise Linux 5
11.2.0 Grid Infra
ASM
Rac start and-stop
Oracle restart
Clusterware *
Voting disk
Vip resource diagnostic
Rac-listeners
Rac listener load balancing , taf , fan ,fcf
Log locations
Clock time offset
RAC Activities
Convert Single Instance to RAC
New Node addition using Cloning
How to Backup and Restore a RAC Database
Restore rac database from tape restore
RAC Refresh
http://www.oracledba.org/upgrade/Upgrade_10gR2_RAC_to_11gR1_RAC.htm
Oracle Clusterware Rolling Upgrades
RAC rolling upgrade 11203 to 11204
RAC rolling upgrade from 11g to 12c
Rac rolling psu patch
how-to-drop-a-rac-database-manually
Cloning-oracle-home-in-rac
RAC Troubleshooting
10g :OCR corruption add nodeapps,ASM,Listener,Instance again
OCR Corruption : Could not find Vip
Master node and node eviction
RAC Performance Tuning
http://www.oracledba.org/11g/rac/11g_RAC_Admin_Maintenance_Tasks.html
https://shivanandarao-oracle.com/2014/11/16/loss-of-ocr-voting-disks-with-no-backups-of-ocr-voting-disks-in-oracle-11gr2/
High Availability Services startup failure :
Check /etc/inittab file contains the entry to start the ohasd process automatically.
./crsctl check cluster –n <nodename> // ./crsctl check cluster –all
Check $GRID_HOME/log/alert_hostname.log and $GRID_HOME/log/ohasd.og files
CSSD startup failure :
ps –ef |grep cssd.bin
Check $GRID_HOME/log/alert_hostname.log and $GRID_HOME/log/ocssd.log files
check the network heart beat between the nodes
ocrcheck -- If there's any ocr corruption
crsctl query votedisk -- if any issue in accessing OCR/Voting Disks
crsctl stat res –t –init
$ ./crsctl start res ora.cssd –init -- Start manually if required
CRSD startup failure :
ps –ef |grep crsd.bin
Check $GRID_HOME/log/alert_hostname.log and $GRID_HOME/log/crsd.logs
ocrcheck -- If there's any ocr corruption
crsctl query votedisk -- if any issue in accessing OCR/Voting Disks
crsctl stat res –t –init
$ ./crsctl start res ora.crsd –init -- Start manually if required
Tracing CRS Components :
Oracle Binaries RAC to NON RAC :
=============================
Check if Binaries are RAC or non RAC : nm -r $ORACLE_HOME/rdbms/lib/libknlopt.a | grep -c kcsm.o
To Convert to Non RAC
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk rac_off
and then relink Oracle
$ make -f ins_rdbms.mk ioracle
How to Rename directory on an ASM ?
If not system generated it can be renamed . If system generated we will have to change DB_UNIQUE_NAME
http://samiora.blogspot.in/2015/02/rename-directory-on-asm.html
Relocating RAC database and instances across nodes
Commands
srvctl commands help
https://valehagayev.wordpress.com/2016/04/16/useful-oracle-rac-commands/
RAC Questions
Rac questions
