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 laterInformation 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.
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 |