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:
Oracle database 11.2.0.3 (integrated capture only)
Oracle database 11.2.0.4
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 provides a wealth of information that comprises the following areas:
Summary
The overview information
Advice and warnings of potential issues with configuration
Configuration
The generic database information
Integrated Extract/capture process configuration...