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 details
- Analysis
- The integrated capture and apply process history
- Table constraints check
- The detailed view information for diagnostic purposes
- Statistics
- The runtime state of database-integrated component processing
- Logminer-detailed statistics
- Patch Inventory
- The database patch-level details
Here is the summary from the Oracle GoldenGate Integrated Extract/Replicat Health check (v3.1.31):
This is an example of a configuration check with advice:
++ Configuration checks ++ ++ + ERROR: The DBA_REGISTRY status information for component 'CATALOG' requires attention. Status is INVALID. Please recompile the component + In addition, the following healthcheck report provides GoldenGate process wait event details that are invaluable to troubleshoot performance issues:
It is important that you obtain the latest version of the health check script because Oracle Support frequently adds new functions.