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.