GoldenGate integration in clusterware

 1. To start/stop manager - It will start golden on a node where GG VIP is running:

$ crsctl start res ggate
$ crsctl stop res ggate

2. To start manager on a specific node:

$ crsctl stop res ggate
$ crsctl start res ggate -n nodename -f

3. To relocate goldengate resource from existing node to new node:

$ crsctl relocate resource ggate –s existing_node –n new_node –f 

4.If below parameters are added in mgr.prm then replicat/extract will be started along with manager as well.:

AUTOSTART EXTRACT *
AUTORESTART EXTRACT *
AUTOSTART REPLICAT *
AUTORESTART REPLICAT *

 Steps to integrate GoldenGate in to clusterware:

 1. As a root user create an application VIP for Oracle GoldenGate :

appvipcfg create -network=1 -ip= XX.XX.XX.XX -vipname=app-oragg-vip -user=root

2. As a root user set read and execute privilege for ORACLE and GRID user on newly added application VIP:

crsctl setperm resource app-oragg-vip -u user:oracle:r-x
crsctl setperm resource app-oragg-vip -u user:grid:r-x

3. As an Oracle user start application VIP resource :

 crsctl start resource app-oragg-vip

4. Prepare action script for handling GoldenGate resource in a cluster. 

5. As an Oracle users add clusterware resource for it:

crsctl add resource ggate -type cluster_resource -attr "ACTION_SCRIPT=

/path/ggs/gg_action.sh,CHECK_INTERVAL=30, START_DEPENDENCIES=

'hard(app-oragg-vip,ora.asm) pullup(app-oragg-vip)', STOP_DEPENDENCIES=

'hard(app-oragg-vip)'" 

6.As a root make Oracle as an owner of GoldenGate resource in the cluster :

 crsctl setperm resource ggate -o oracle

7. As an Oracle user start GoldenGate resource :

  crsctl start res ggate

Oracle Support Documents referred –

1. Doc ID - 1112506.1

2. Doc ID - 1313703.1