Hey Guys, I am trying to establish HA for a GoldenGate setup running on a 3 node Oracle 11.2.0.4.4 RAC on RHEL 6.3 64-bit environment. Trying to use XAG for this ahead of the 'action' scripts route.
I am following the Oracle GoldenGate HA best practice documents
http://www.oracle.com/technetwork/products/clusterware/overview/ogg-xag-bp-1915977.pdf
http://www.oracle.com/technetwork/products/clusterware/overview/ogiba-v2-1916262.pdf
As part of the setup, I have done the following:
1. Downloaded the latest version of the xagpack_6.zip
2. Installed this on all 3 nodes in the RAC using "xagsetup.sh --install --directory $XAG_HOME --all_nodes". The install has gone through fine
3. Created an Application VIP, started the vip
4. Created a Cluster resource
Attempts to start the Cluster resource fails with "*** Could not open error log ggserr.log (error 13,Permission denied) ***" error
Here is all what I have done:
Create the application vip
su -
$GRID_HOME/bin/appvipcfg create -network=1 -ip=10.1.40.41 -vipname=au-ogg-auapprod-vip -user=grid -group=oinstall
Grant permission to oracle and grid users
$GRID_HOME/bin/crsctl setperm resource au-ogg-auapprod-vip -u user:grid:r-x
$GRID_HOME/bin/crsctl setperm resource au-ogg-auapprod-vip -u user:oracle:r-x
Start the application vip
$GRID_HOME/bin/crsctl status resource au-ogg-auapprod-vip
$GRID_HOME/bin/crsctl start resource au-ogg-auapprod-vip
[grid@prod-ora-n1][+ASM1][~]
[20:40:23]$ $GRID_HOME/bin/crsctl status resource au-ogg-auapprod-vip
NAME=au-ogg-auapprod-vip
TYPE=app.appvip_net1.type
TARGET=ONLINE
STATE=ONLINE on prod-ora-n1
Create Cluster resource
su - grid
$XAG_HOME/bin/agctl add goldengate auapprod_source --gg_home /u02/GG/Source/AUAPPROD --instance_type source --nodes prod-ora-n1,prod-ora-n2,prod-ora-n3 --vip_name au-ogg-auapprod-vip --filesystems ora.registry.acfs --databases ora.auapprod.db --oracle_home /u01/app/oracle/product/11.2.0/dbhome_1 --monitor_extracts XUAP01,PUAP01 --critical_extracts XUAP01,PUAP01
[grid@prod-ora-n1][+ASM1][~]
[20:40:31]$ $XAG_HOME/bin/agctl config goldengate auapprod_source
GoldenGate location is: /u02/GG/Source/AUAPPROD
GoldenGate instance type is: source
Configured to run on Nodes: prod-ora-n1 prod-ora-n2 prod-ora-n3
ORACLE_HOME location is: /u01/app/oracle/product/11.2.0/dbhome_1
Databases needed: ora.auapprod.db
File System resources needed: ora.registry.acfs
Extracts to monitor: XUAP01,PUAP01
Replicats to monitor:
Critical extracts: XUAP01,PUAP01
Critical replicats:
Autostart on DataGuard role transition to PRIMARY: no
Autostart JAgent: no
Attempts to start the resource takes a long time and it finally fails
$XAG_HOME/bin/agctl start goldengate auapprod_source
Looking into the XAG_HOME/../log drectory, I see that the resource start attempts are failing.
Questions:
1. GI Home is owned by 'grid', Oracle DB home by 'oracle' and GG home by 'oggadm'. Who should be the user when I create the application vip? Sure I run this as root, but in the following command, user=grid. Is this correct?
$GRID_HOME/bin/appvipcfg create -network=1 -ip=10.1.40.41 -vipname=au-ogg-auapprod-vip -user=grid -group=oinstall
2. Do I need to setperm to grant oggadm' the privilege including rw?
3. Do you see anything incorrect in what I am doing?
Thanks
Sridhar