1. Oracle GoldenGate Classic Documentation
  2. Performance
  3. Tuning the Performance of Oracle GoldenGate
  4. Using Healthcheck Scripts to Monitor and Troubleshoot
  5. Installing, Running, and Uninstalling Healthcheck Scripts

Installing, Running, and Uninstalling Healthcheck Scripts

The Healthcheck script is available for Oracle GoldenGate Classic and Microservices.

The Healtcheck directory contains three files to install, run and deinstall the Healthcheck script. Once the PL/SQL package is installed with ogghc_install.sql, you can frequently run the ohgghc_run.sql script to generate an output file. You can deinstall the Healthcheck script with the ogghc_deinstall.sql script.

The Healthcheck script is located in:

  • $OGG_HOME/lib/sql/healthcheck for MA

  • $OGG_HOME/healthcheck for CA

To gather information, Oracle recommends you to install and run the Healthcheck as a SYS user. However, you can also install and run the script as an Oracle GoldenGate Administration User. In this case, some system information is not available. The Healthcheck output displays the information that requires SYS privileges.