9.8 Monitoring the High Availability Features

This topic explains the monitoring of High Availability features for Oracle GoldenGate Management Pack. For the High Availability feature to properly function with Oracle GoldenGate plug-in, virtual IP (not the physical IP) of the Oracle GoldenGate host must be provided at the time of Oracle GoldenGate target discovery.

There can be two scenarios where High Availability is required:

• Oracle GoldenGate instance is failed over from one node to another in the cluster: In this scenario, the existing Master Agent continues monitoring the Oracle GoldenGate instance in a seamless manner and the Host Name parameter in the Oracle GoldenGate Manager page displays the physical host name of the new node.

• Current Master Agent stops functioning: In this scenario, the EM Agents that are currently running, must be marked as Slave for this Oracle GoldenGate instance. When the current Master Agent stops functioning, one of the Slave agents is assigned as Master for the Oracle GoldenGate instance, and monitoring continues.

This procedure uses both the Oracle Enterprise Manager Cloud Control portal and a console connection.

1. Start Oracle Enterprise Manager Cloud Control.
2. Login using the provided credentials.

   The user must have sysman privilege.

3. Select Setup, Manage Cloud Control, Agents to open the Agents page.

   All the agents are listed on this page.

4. Select Targets, GoldenGate.
5. Select Setup, Add target, Configure Auto Discovery.
6. Select the host and click Discovery Modules to provide credentials details by selecting Goldengate discovery.
   See Discovering Oracle GoldenGate Targets in the UI.
7. Click Discovered Targets for a particular Agent Host Name.
   The dialog lists all the targets on hosts, select a particular host.
   1. Click Promote to promote the particular process to display a confirmation dialog box (that says Do You Want to Manage Agents now?) when the promotion process is completed.
   2. In the confirmation dialog box, click Yes to Manage Agents.

      Note:

      You can bypass the Manage Agents page that displays a confirmation page. By bypassing this page, the promotion of the Oracle GoldenGate targets happens quickly.
8. Click Submit from the Manage Agents page to display a confirmation page. However, this is an optional step.

   This page displays after successful completion of the promotion of the targets. It includes the recently promoted Oracle GoldenGate instance with a list of all EM agents where Oracle GoldenGate plug-in is deployed.

   The agent through which these targets were discovered and promoted, is shown as Master for this Oracle GoldenGate instance. All other agents are marked as None, which means that they’re not associated with this Oracle GoldenGate instance. You can select any number of these agents as Slave, and click Submit to save the changes.

   If you don't want to make any such changes, you can click Oracle GoldenGate Home and navigate back to the Oracle GoldenGate plug-in home page.

   After the process promotion, you can see the promoted target in the Oracle GoldenGate Home page.
9. If you want to start, stop, or kill the process, then navigate to the corresponding process page and then select appropriate controls.
10. Click Targets, select GoldenGate, and then select the process, which you want to either start or stop.
    You can select any of the processes, such as Extract, Replicat, or Data Pump to start or stop.
    The status of the Oracle GoldenGate processes is reflected according to the option you selected (Start/Stop/Kill) and it gets reflected in both the OGG Home page as well as Process Details page. Click Refresh to view the updates.