Installing, Running, and Uninstalling Healthcheck Scripts

The Healtcheck directory contains three files to install, run and deinstall the Healthcheck script. After 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 using the ogghc_deinstall.sql script.

The Healthcheck script is located in:

$OGG_HOME/lib/sql/healthcheck

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 administrator user role. In this case, some system information is not available. The Healthcheck output displays the information that requires SYS privileges.