Book Image

Oracle Goldengate 12c Implementers Guide

Book Image

Oracle Goldengate 12c Implementers Guide

Overview of this book

Table of Contents (21 chapters)
Oracle GoldenGate 12c Implementer's Guide
About the Author
About the Reviewers
GGSCI Commands
GoldenGate Installed Components

GoldenGate health check

Since Oracle GoldenGate 11g Release 2, a health check script has been made available on the MOS portal at

The SQL script comes in three flavors for each database version and provides a health check report for integrated capture and apply processes. The supported database versions are:

  1. Oracle database (integrated capture only)

  2. Oracle database

  3. Oracle database

Once logged in to MOS, search for Doc ID: 1448324.1 and download the required version. Copy the script to your database server and execute it as follows:

sqlplus /nolog
SQL> spool /tmp/icrhc_12101.html
SQL> @icrhc_12101.sql

When the script completes, the HTML file can be opened and viewed using a web browser.

The report provides a wealth of information that comprises the following areas:

  1. Summary

    • The overview information

    • Advice and warnings of potential issues with configuration

  2. Configuration

    • The generic database information

    • Integrated Extract/capture process configuration...