Netsoftmate

Tag: Exadata Health Check

  • Oracle Exadata Database Machine Health Check – Exachk 18c

    Oracle has released Exachk utility 18c on May 18th, 2018. Let’s quickly check if there are differences in Exachk 18c or it is similar to Exachk 12c.


    Download latest Exachk 18c utility from MOS note:
    Oracle Exadata Database Machine exachk or HealthCheck (Doc ID 1070954.1)


    Changes in Exachk 18.2 can be found at:
    https://docs.oracle.com/cd/E96145_01/OEXUG/changes-in-this-release-18-2-0.htm#OEXUG-GUID-88FCFBC6-C647-47D3-898C-F4C712117B8B


    Steps to Execute Exachk 18c on Exadata Database Machine



    Download the latest Exachk from MOS note. Here I am downloading Exachk 18c.

    Download Completed

    Using WinSCP copy the exachk.zip file to Exadata Compute node

    Copy completed. List the Exachk file on Compute node

    Unzip the Exachk zip file

    Verify Exachk version

    Execute Exachk Health by running the following command

    Exachk execution completed

    Review the Exachk report and take necessary action


    Conclusion
    In this article we have learned how to execute Oracle Exadata Database Machine health Check using Exachk 18c. Using Exachk 18c is NO different than it’s previous releases.

  • Exadata Database Machine Health Check Using Exachk Utility
    Oracle provides “Exachk” utility to conduct a comprehensive Exadata Health Check on Exadata Database Machine to validate hardware, firmware and configuration.

    Exachk Utility is available for Oracle engineered systems such as Exadata (V2 and above), Exalogic, Exalytics, SuperCluster, MiniCluster, ZDLRA & Big Data. Exachk utility performs the following checks:


    • Configuration checks for Compute nodes, Storage cells and InfiniBand Switches
    • Grid Infrastructure, Database and ASM and Operating System software checks
    • MAA Scorecard which conducts an automatic MAA Review
    • Exadata Software Planner, Software prechecks, Exadata and Database Critical Issue alerts

    It is recommended to execute the latest exachk at the following situation:


    • Monthly
    • Before any planned maintenance activity
    • Immediately after completion of planned maintenance activity
    • Immediately after an outage or incident

    Steps to Exadata Health Exachk Using Exachk Utility
    • Download latest Exachk utility from the MOS note. As of writing the latest Exachk verion available is “12.2.0.1.4_20171212”
    Oracle Exadata Database Machine exachk or Health Check (Doc ID 1070954.1)

    Note: It is recommended to use latest Exachk to perform Exadata Health Check


    • As root user, create ‘Exachk’ directory on compute node 1 as follows
    [root@dm01db01 ~]# cd /root
    [root@dm01db01 ~]# mkdir Exachk


    • Using Winscp Copy the Downloaded Exachk utility from your desktop/laptop to the Exadata compute node 1 under /root/Exachk
    • As root user, Login to Exadata Compute node 1 and unzip the Exachk utility
    [root@dm01db01 ~]# cd /root/Exachk/

    [root@dm01db01 Exachk]# ls -ltr


    total 112576
    -rw-r–r– 1 root root 115158363 Apr 10 05:11 exachk.zip

    [root@dm01db01 Exachk]# unzip exachk.zip

    • Ensure that the SSH is setup across all Compute nodes, Storage cells and Ibswitches
    [root@dm01db01 Exachk]# dcli -g ~/all_group -l root ‘uptime’


    To Setup SSH across the cluster, use the following command:




    [root@dm01db01 ~]# cd /opt/oracle.SupportTools/


    [root@dm01db01 oracle.SupportTools]# ./setup_ssh_eq.sh ~/all_group root welcome1
    • As root user, Execute the Exachk utility
    [root@dm01db01 ~]# cd /root/Exachk/

    [root@dm01db01 Exachk]# ls -ltr




    [root@dm01db01 Exachk]# ./exachk

    Depending on the Exadata Cluster Size and number of databases it may take several minutes to complete Exachk execution.
    • Using Winscp, copy the Exachk zip file and/or html file to your desktop/laptop to review
    • Open the html file, review it and take necessary action if necessary
    • Under the table of contents there are different component listed. Look out for the CRITICAL and FAIL components.
    Click on the ‘view’ hyperlink for more details and the recommendation to fix the problem.

    MAA Scorecard



    Conclusion


    In this article we have learned to perform complete Exadata Stack Health Check using Exachk utility. Exachk Utility is available for Oracle engineered systems such as Exadata (V2 and above), Exalogi, Exalytics, SuperCluster, MiniCluster, ZDLRA & Big Data.