In this post, I will demonstrate three methods to identify the oracle clusterware’s master node. Please note that clusterware master is different from Resource master in oracle database instance. To know about how to find the resource master,
Oracle ClusterWare Master’s Node information can be found
- By scanning ocssd logs from various nodes
- By scanning crsd logs from various nodes.
- By identifying the node which takes the backup of the OCR.
1st Method
[grid@host01 root]$ cat $ORACLE_HOME/log/host01/cssd/ocssd.log |grep ‘master node’ |tail -1 2016-12-30 15:19:36.949: [CSSD][2778696592]clssgmCMReconfig: reconfiguration successful, incarnation 248953243 with 3 nodes, local node number 1, master node number 3 [root@host02 cssd]# cat $ORACLE_HOME/log/host02/cssd/ocssd.log |grep ‘master node’ |tail -1 2016-12-30 15:19:36.953: [CSSD][778696592]clssgmCMReconfig: reconfiguration successful, incarnation 248953243 with 3 nodes, local node number 2, master node number 3 [root@host03 ~]# cat $ORACLE_HOME/log/host03/cssd/ocssd.log |grep ‘master node’ |tail -1 2016-12-30 15:19:37.001: [CSSD][778700688]clssgmCMReconfig: reconfiguration successful, incarnation 248953243 with 3 nodes, local node number 3,master node number 3
2nd Method
If I take the OCR backup right now, it will be taken by node3 (master node).
[root@host02 cssd]# ocrconfig -manualbackup host03 2016-12-30 12:55:48 /u01/app/11.2.0/grid/cdata/cluster01/backup_20161230_092685.ocr
3rd Method
select *from gv$ges_resource;
4th Method in 12c
[root@test1 ~]# oclumon manage -get MASTER Master = test1 [root@test1 ~]#
awesome…!!!!!!