GoldenGate health check

Since Oracle GoldenGate 11g Release 2, a health check script has been made available on the MOS portal at https://support.oracle.com.

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 11.2.0.3 (integrated capture only)
  2. Oracle database 11.2.0.4
  3. Oracle database 12.1.0.1

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

Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial