Oracle provides “Exachk” utility to conduct a comprehensive Health Check on Oracle SuperCluster 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.

When Exachk is run from the primary LDOM as user ‘root’ it will discover and run exachk utility for each component:

Configuration checks for Compute nodes, Storage cells and InfiniBand Switches
Grid Infrastructure, Database and ASM and Operating System software checks

When Exachk is run in a Database zone or Virtualized environment it will collect data for:

All RAC Node
All Database Instance
Grid Infrastructure

You can also run Exachk on a specific component such as:

Database Servers
Storage Cells
Infiniband Switches
Grid Infrastructure, Database & ASM and so on

It is recommended to run Exachk as root user and have SSH equivalence setup in the SuperCluster. But you can run Exachk as ordinary user and without having root ssh setup.

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

Exachk Binary and output file location:

Default Exachk Location: /opt/oracle.SupportTools/exachk
Defautl Exachk Output Location: /opt/oracle.SupportTools/exachk

Courtesy Oracle

Steps to Deploy and Execute Exachk utility on SuperCluster

Download Latest Exachk Utility

You can download the latest Exachk from MOS note 1070954.1

Download deploy_exachk.sh script to deploy and install Exachk in all Primary LDOM and in each Zone

Copy the downloaded Exachk utility and deploy_exachk.sh into /opt/oracle.SupportTools

# cd /opt/oracle.SupportTools
# mv exachk Exachk-bkp

Deploy Exachk as follows

# cd /opt/oracle.SupportTools/
# ./deploy_exachk.sh exachk.zip
# ls -ltr
# cd exachk
# ls -l exachk

As of writing the latest Exachk available is 18.2.0_20180518

Verify Exachk Version on LDOM

# cd /opt/oracle.SupportTools/exachk
# ./exachk -v

To verify Exachk version on all zones in a LDOM

# zoneadm list | grep -v global > zone_list
# hostname >> zone_list
# /opt/oracle.supercluster/bin/dcli -g zone_list -l root /opt/oracle.SupportTools/exachk/exachk -v

Note: root RSA keys should be set up for SSH

Execute Exachk on Primary LDOM or Global Zone

# cd /opt/oracle.SupportTools/exachk
# ./exachk

Execute Exachk in non-global zone local zone

Login to non-global zone local zone using zlogin and execute the following commands

# zlogin <hostname>
# cd /opt/oracle.SupportTools/exachk
# ./exachk

Important Note: In zones there is currently an issue with discovery, and so one must set the RAT_ORACLE_HOME and RAT_GRID_HOME environment variables in some cases.

Conclusion
In this article we have learned to perform Oracle SuperCluster 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.

Exadata Database Machine Health Check Using Exachk Utility

By Netsoftmate on

April 20, 2018

- Uncategorized

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.

Different Oracle Health Check Tools

By Netsoftmate on

September 10, 2017

- Uncategorized

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.

Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!

Home

About

Services

Blog

Contact

Oracle SuperCluster Health Check Using Exachk Utility

Exadata Database Machine Health Check Using Exachk Utility

Different Oracle Health Check Tools

ABOUT US

Services

CONTACT US

Follow Us!