My Oracle Support Banner

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

Last updated on MAY 20, 2020

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.

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.