My Oracle Support Banner

GoldenGate Integrated Capture and Integrated Replicat Healthcheck Script (Doc ID 1448324.1)

Last updated on OCTOBER 13, 2022

Applies to:

Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.
Oracle Database Enterprise Edition & Standard Edition for releases 11.2.0.3 onwards.








Purpose

To provide a script that quickly retrieves all the information related to the Oracle GoldenGate Integrated Capture and Integrated Replicat configuration in an Oracle database.

DISCLAIMER : This script is provided for diagnosis and troubleshooting purposes only.  The script has been tested and appears to work as intended.
Any modification or customization made by customer without support's approval is NOT supported by Oracle Support.

Scope

This note is intended for anyone interested in retrieving information about the current status of Oracle GoldenGate Integrated Capture and Integrated Replicat configuration in an Oracle database.

This report is useful to confirm that the pre-requisites for Oracle GoldenGate Integrated Capture/Replicat are met as well as to identify the database objects of interest for Oracle GoldenGate Integrated Capture/Replicat.

These scripts do not modify the Integrated Capture/Replicat configuration. Each script reports important information on the setup and operation of Integrated Capture/Replicat. This will provide a consistent basis upon which to understand what is happening in the environment and aid to diagnose issues.

Integrated Capture feature is available on combination of Oracle GoldenGate 11.2.1.0.0 and Oracle Database 11.2.0.3 onwards.

Integrated Replicat feature is available on combination of Oracle GoldenGate 12.1.2.0.0 and Oracle Database 11.2.0.4 and 12.1.0.2 onwards.

The script on this not is applicable from database version 11.2.0.4 to 12.1.0.2 and Goldengate versions 12.1.2.0.0 to 12.2.  For Database version 12.2 and above and GoldenGate 12.3 and above you should use the version of the Health Check script available in the healthcheck directory under the OGG_HOME. The ogghc_install.sql needs to be run for setup and ogghc_run.sql needs to be run to generate the Healthcheck report . Hence, we can use this script to generate the healthcheck for Oracle Database 12.2 and above.

For OGG MicroService Architecture, the Healthcheck will be found in <OGG MA HOME>/lib/sql/healthcheck

Please review the following note from additional information:

GoldenGate Integrated Capture and Integrated Replicat Healthcheck Script for Ogg v12.3.x and Above (Doc ID 2653026.1)

 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Scripts available 
 How to run the script
 Script output
 Configuration
 Extract
 Replicat
 Analysis
 Statistics
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.