Netsoftmate

Tag: DB Check

  • Different Oracle Health Check Tools

    Introduction

    There are quite a few health check tools provided by Oracle
    for both Engineered and Non-Engineered Systems. This article explains which
    tool is a best choice for a given system.


    Table showing different Health Check Tools available for
    Engineered and Non-Engineered Systems



























    ORAchk (1268927.2)

    Exachk

    Oracle Database Appliance (ODA)

    Exadata Database Machine (1070954.1)

    Non-Engineered Systems

    Exalogic (1449226.1)

     

    Exalytics (1566134.1)

     

    BIG Data Appliance  (BDA)  (1643715.1)

     

    Zero Data Loss Recovery Appliance (ZDLRA) (1643715.1)


    Examples executing
    Health Check utilities


    ORAchk
     
    Download ORAchk using MOS – ORAchk – Health
    Checks for the Oracle Stack (Doc ID 1268927.2)
     
    Non-Engineered
    Systems
     
    Run ORAchk Interactively.

    • Log in to the system as root user
       
    • Stage the appropriate orachk.zip kit in its own
      directory the node on which the tool will be executed. Eg:
      /u01/app/oracle/stage
       
    • Unzip orachk.zip kit, leaving the script and
      driver files together in the same directory
      # unzip orachk.zip –d /tmp/orachk
       
    • Validate the permissions for orachk are 755
      (-rwxr-xr-x). If the permissions are not currently set to 755, set the
      permissions on orachk as follows:
      #cd /tmp/orachk
      # chmod 755 orachk
       
    • Invoke the tool as follows:
      #cd /tmp/orachk
      #./orachk
       
      Follow the prompts while reading and
      understanding all messages.
       
    • Upon completion of ORAchk command the following
      (or similar) will be displayed:
    Detailed report (html) –
    /home/oracle/orachk_oradbnode1_orcl_100715_105241/orachk_oradbnode1_orcl_100715_105241.html
     
    Engineered
    System – Oracle Database Appliance (ODA)
     
    # /opt/oracle/oak/orachk -a

     
    Exachk

    Exadata Database Machine
     
    Download Exachk using MOS Oracle Exadata
    Database Machine exachk or HealthCheck (Doc ID 1070954.1)
     
    # ./exachk -a

     
    Conclusion

    In this article we have seen different Oracle
    Health Check tool available and how to use them.