Saturday, May 14, 2016

How To find Master Node In RAC


We can find Master Node by querying CRSD and CSSD logs 

[root@tnc1 cssd]# pwd
/u01/app/11.2.0/grid/log/tnc1/cssd

Querying cssd logs to find Master Node information # 
[root@tnc1 cssd]# for x in `ls -tr ocssd.*`; do grep -i "master node" $x ; done | tail -1
2016-05-14 01:29:06.282: [    CSSD][4099299072]clssgmCMReconfig: reconfiguration successful, incarnation 358651350 with 2 nodes, local node number 1, master node number 1

We know that ocr is backuped by CRSD demon by master node 
query ocrconfig to find out Master Node in RAC Cluster # 
[root@tnc1 dbs]# ocrconfig -showbackup

--Nikhil Tatineni--
--RAC -- 


Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...