January 1, 2019

How to find out the master node ?

How to find out the nodes in RAC cluster (or) 
How to find out the master node in Oracle RAC?

There are several ways to find out which is the master node or all the nodes which are part of Oracle RAC cluster.

Use any one of the below.

i) # olsnodes -- Which ever displayed first, is the master node of the cluster.

ii) select MASTER_NODE from v$ges_resource;

iii) check ocssd.log file and search for "master node number".
$ grep "master node number/u01/app/crs/`hostname -s`/cssd/ocssd.log

iv) oclumon manage -get master        (in Oracle RAC 12c)

v) ocrconfig -manualbackup

Related Articles: