Skip to content

Inspect Problems in Oracle RAC using Autonomous Health Framework (AHF)

    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:

    Oracle Clusterware

    Components of Autonomous Health Framework