Exadata HealthCheck

 HealthCheck是Oracle开发的用于对Exadata配置进行验证的一套脚本。可参考文档ID 1070954.1

oracle推荐定期运行HealthCheck脚本并与oracle公司公布的参数进行对比，以保证一体机的

最佳性能和可管理性。健康检查是不会影响业务的除了脚本CheckHWnFWProfile外都可以在业务

运行时进行。脚本CheckHWnFWProfile平时也不需要运行，只在Exadata软件全新安装时才需要。

HealthCheck主要包括2个脚本：ASM检查（run_os_commands_as_oracle.sh）和O/S检查

（run_os_commands_as_root.sh）.

Oracle Exadata Database Machine exachk or HealthCheck (文档 ID 1070954.1)

APPLIES TO:

    Oracle SuperCluster

    Oracle Exadata Hardware

    Oracle Exadata Storage Server Software - Version 11.2.2.2.0 and later

    Linux x86-64

    Oracle Solaris on SPARC (64-bit)

    See "Scope" for additional supported products data

PURPOSE：

exachk holistically evaluates all Oracle Engineered Systems.   
It includes:

     1.Configuration checks for Database Servers, Storage Servers and InfiniBand Switches  

     2.Grid Infrastructure,Database and ASM and operating system software check 

     3.MAA Scorecard which conducts an automatic MAA Review

     4.Exadata Software Planner, Software prechecks, Exadata and Database Critical Issue alerts

     All checks have explanations, recommendations, and manual verification commands so that customers can self-correct 

all FAIL and WARNING conditions reported. 

具体实施：

    Download the attached  "exachk_121025_bundle.zip" file to your desktop computer and unzip the file. Follow the documentation, training materials, and readme files to understand how to deploy and execute the exachk utility to 

an Oracle Exadata Database Machine.

下载的文件解压后包括如下内容：

HealthCheck Command Table 1.2.2.xls

HealthCheck_1_2_2_tar_gz

HealthCheck_user_guide.txt
SAMPLE_asm_output_051711_150737.lst
SAMPLE_os_output_051711_150154.lst

以下是指导手册简述：

对目标数据库的影响：数据库健康检查的内容都是只读命令，对目标数据的影响很小；

操作系统，硬件，防火墙的检查只需要4分钟

asm的检查少于10秒

注意：每次只在一个机器上执行，不要试图在win上解压，最好放到linux上解压

$ tar -zpxvf HealthCheck_1_2_2_tar_gz

解压后的文件包括以下内容：

操作系统检查：

 ./run_os_commands_as_root.sh -a /home/oracle/HealthCheck -b /u01/app/11.2.0/grid -c /u01/app/11.2.0/grid -d /u01/app/oracle/product/11.2.0/dbhome_1 

-a <the location of the HealthCheck source files. eg: /home/oracle/HealthCheck>
-b <the location of the CRS home. eg: /u01/app/11.1.0/crs>
-c <the location of the ASM home. eg: /u01/app/oracle/product/11.1.0/asm_1>
-d <the location of the DB home. eg: /u01/app/oracle/product/11.1.0/db_1>

[root@erpdb01 HealthCheck]# ./run_os_commands_as_root.sh -a /home/oracle/HealthCheck -b /u01/PSPROD/oracle/product/11.2.0.4/crs -c /u01/PSPROD/11.2.0.4/grid/log/diag/asm/+asm/+ASM1 -d /u01/PROD/db/tech_st/11.2.0 
===================================================================
Validate only one HealthCheck executing:
===================================================================

Error: I/O error(2) on /root/cell_group: No such file or directory
===================================================================
Establish lock file:
===================================================================

Error: I/O error(2) on /root/cell_group: No such file or directory
===================================================================
FAIL:  The Oracle Exadata Database Machine HealthCheck is not
       supported on SUN hardware.  Please use the exachk utility as
       documented in My Oracle Support Note 1070954.1.

       Exiting.
===================================================================
===================================================================
Remove lock file:
===================================================================
Error: I/O error(2) on /root/cell_group: No such file or directory
[root@erpdb01 HealthCheck]# 

看到一个报错：