Components of Autonomous Health Framework
Diagnostic components that are part of Oracle Autonomous Health Framework.
- Introduction to Oracle ORAchk and Oracle EXAchk
Oracle ORAchk and Oracle EXAchk provide a lightweight and non-intrusive health check framework for the Oracle stack of software and hardware components. - Introduction to Cluster Health Monitor
Cluster Health Monitor is a component of Oracle Grid Infrastructure, which continuously monitors and stores Oracle Clusterware and operating system resources metrics. - Introduction to Oracle Trace File Analyzer
Oracle Trace File Analyzer is a utility for targeted diagnostic collection that simplifies diagnostic data collection for Oracle Clusterware, Oracle Grid Infrastructure, and Oracle Real Application Clusters (Oracle RAC) systems, in addition to single instance, non-clustered databases. - Introduction to Oracle Cluster Health Advisor
Oracle Cluster Health Advisor continuously monitors cluster nodes and Oracle RAC databases for performance and availability issue precursors to provide early warning of problems before they become critical. - Introduction to Memory Guard
Memory Guard is an Oracle Real Application Clusters (Oracle RAC) environment feature to monitor the cluster nodes to prevent node stress caused by the lack of memory. - Introduction to Hang Manager
Hang Manager is an Oracle Real Application Clusters (Oracle RAC) environment feature that autonomously resolves hangs and keeps the resources available. - Introduction to Oracle Database Quality of Service (QoS) Management
Oracle Database Quality of Service (QoS) Management manages the resources that are shared across applications.
Download and setup.
yum install -y perl-Digest-MD5 perl-Data-Dumper
$ cd /u01/software $ unzip -oq AHF-LINUX_v19.3.0.zip $ $ mkdir -p $ORACLE_HOME/ahf $ ./ahf_setup -ahf_loc $ORACLE_HOME/ahf AHF Installation Log : /tmp/ahf_install_28615_2019_10_29-08_53_47.log Starting Autonomous Health Framework (AHF) Installation AHF Version: 193000 Build Date: 201910181720 AHF Location : /u01/app/oracle/product/19.0.0/dbhome_1/ahf/oracle.ahf AHF Data Directory stores diagnostic collections and metadata. AHF Data Directory requires at least 5GB (Recommended 10GB) of free space. Choose Data Directory from below options : 1. /u01/app/oracle/product/19.0.0/dbhome_1/ahf/oracle.ahf [Free Space : 89823 MB] 2. Enter a different Location Choose Option [1 - 2] : 1 AHF Data Directory : /u01/app/oracle/product/19.0.0/dbhome_1/ahf/oracle.ahf/data Do you want to add AHF Notification Email IDs ? [Y]|N : Enter Email IDs separated by space : [email protected] Extracting AHF to /u01/app/oracle/product/19.0.0/dbhome_1/ahf/oracle.ahf Configuring TFA in Standalone Mode... Build Version : 193000 Build Date : 201910181720 Discovering Nodes and Oracle Resources AHF is deployed at /u01/app/oracle/product/19.0.0/dbhome_1/ahf/oracle.ahf AHF binaries are available in /u01/app/oracle/product/19.0.0/dbhome_1/ahf/oracle.ahf/bin AHF is successfully installed Moving /tmp/ahf_install_28615_2019_10_29-08_53_47.log to /u01/app/oracle/product/19.0.0/dbhome_1/ahf/oracle.ahf/data/localhost/diag/ahf/ $
As shown above, the tfactl and orachk commands are available from the following directory.
$ORACLE_HOME/ahf/oracle.ahf/bin
Run ORAchk
With the installation complete we can use the orachk command to check the services running on the server. This can be done on-demand, or run as a background task, which will send an email to the notification email addresses.
# root cd /opt/oracle.ahf/bin # non-root cd $ORACLE_HOME/ahf/oracle.ahf/bin # on-demand ./orachk # background ./orachk -autostart
Aslso See: