I am looking for some perspective of real world cases with respects to configuring Oracle GoldenGate 11.2 for HA with Oracle Clusterware 18.104.22.168.
I have seen essentially two methods for this configuration:
<OL><LI>Using the Bundled Agents (XAG) with Clusterware 22.214.171.124 , specifically the agent for GoldenGate</LI>
<LI>Using crsctl to add the GoldenGate instance process(s) as standard application cluster resources , configured with application action script(s).</LI></OL>
I have reviewed both options covered in these documents and either seem like they'd work fine.
Option 1 covered in this doc which came out in Sept 2012:
Option 2 covered in this doc which was released in March 2013:
Its curious to see that Option 2, which does not use the agents is the more recent doc.
Also, as some background information, I have a 2 node Grid Infrastructure cluster on OEL 6.3. On this 2 node cluster, I am running an single instance Oracle database configured for HA as an application cluster resource; similar to the configuration defined in this doc:
My plan is to implement GoldenGate Integrated capture on the same cluster..either on the same node as the database, or on the 2nd node as a Downstream Integrated Capture instance.
I can see some benefits of both options, and was curious to know if anyone has this type of configuration running in an active dev/test/prod environment.
If so, was there a decision point that made one option better than the other ?
Bundled Agents(XAG) is the way to go. You can define a dependency to your database resource to co-locate the GG instance with the database instance. Or you can run on a different node and configure Services for GG to connect to the database.