Monday 22 July 2019

Check Master node on Grid 12c R1


At OS level check master node by entering command at OS level. Set first Environment variable.


[root@srv1 trace]# oclumon manage -get MASTER

Master = srv1
[root@srv1 trace]#


[root@srv2 trace]# . oraenv
ORACLE_SID = [root] ? +ASM2
The Oracle base has been set to /u01/app/grid
[root@srv2 trace]# oclumon manage -get MASTER

Master = srv1
[root@srv2 trace]#


############################# Using crsd and ocssd Trace file ##################
/u01/app/grid/diag/crs/srv1/crs/trace
[root@srv1 trace]# cat crsd.trc | grep master

2019-07-18 11:43:22.462047 :UiServer:4000261888: {2:27589:9} Master change notification has received. New master: 1

/u01/app/grid/diag/crs/srv2/crs/trace
[root@srv2 trace]# cat crsd.trc | grep master

2019-07-18 11:42:56.622388 :UiServer:4081030912: {1:21827:2} Master change notification has received. New master: 1

/u01/app/grid/diag/crs/srv1/crs/trace
[root@srv1 trace]# cat ocssd.trc |grep MASTER


############################  Using Query #######################################


select MASTER_NODE from v$ges_resource;

No comments:

Post a Comment