ORAchk Health Check Tool

os: centos 7.4
db: oracle 12.1.0.2
orachk: 18.4.0

ORAchk 的前身为 RACcheck,主要原因是该工具现在不仅适用于 RAC 数据库,还支持许多新特性和产品.

ORAchk replaces the RACCheck utility. ORAchk extends health check coverage to the
entire Oracle software stack, and identifies and addresses top issues reported by
Oracle users. ORAchk proactively scans for known problems with Oracle products
and deployments, including the following:
■ Standalone Oracle Database
■ Oracle Grid Infrastructure
■ Oracle Real Application Clusters
■ Maximum Availability Architecture (MAA) Validation
■ Upgrade Readiness Validations
■ Oracle Golden Gate
Oracle is continuing to expand checks, based on customer requests.
Oracle recommends that you download and run the latest version of ORAchk from
My Oracle Support. For information about downloading, configuring and running
ORAchk utility, refer to My Oracle Support note 1268927.1:
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1268927.1

下载 ORAchk

下载的是最新的 ORAchk stand-alone 18.4.0,有300MB,好大.
有空再研究下 ORAchk within TFA

# su - oracle
$ mkdir orachk
$ cd orachk
$ rz
$ ls -l
-rw-r--r--   1 oracle oinstall 331643669 Jan 23  2019 orachk.zip

$ unzip orachk.zip
$ ls -l
total 397956
-r--r--r-- 1 oracle oinstall   8319322 Nov 30 04:45 Apex5_CollectionManager_App.sql
drwxr-xr-x 2 oracle oinstall        60 Nov 30 04:44 bash
drwxr-xr-x 2 oracle oinstall       137 Nov 30 04:44 build
-r--r--r-- 1 oracle oinstall   2958609 Nov 30 04:45 CollectionManager_App.sql
-r--r--r-- 1 oracle oinstall  52821808 Nov 30 04:44 collections.dat
drwxr-xr-x 2 oracle oinstall        46 Jan 22 23:26 doc
drwxr-xr-x 2 oracle oinstall       206 Nov 30 04:59 exadiscover
drwxr-xr-x 3 oracle oinstall      4096 Nov 30 04:58 lib
-rwxr-xr-x 1 oracle oinstall     16542 Nov 30 04:45 orachk
-r--r--r-- 1 oracle oinstall      8129 Nov 30 04:45 orachk.bat
-rw-r--r-- 1 oracle oinstall   2341474 Nov 30 05:08 ORAchk_Health_Check_Catalog.html
-r--r--r-- 1 oracle oinstall    149959 Nov 30 04:44 orachk.pyc
-rw-r--r-- 1 oracle oinstall 331643669 Jan 23  2019 orachk.zip
-rw-r--r-- 1 oracle oinstall      2157 Nov 30 05:08 readme.txt
-r--r--r-- 1 oracle oinstall   9168615 Nov 30 04:44 rules.dat
-r--r--r-- 1 oracle oinstall     43473 Nov 30 04:45 sample_user_defined_checks.xml
drwxr-xr-x 2 oracle oinstall       163 Nov 30 04:59 templates
-r--r--r-- 1 oracle oinstall      3217 Nov 30 04:45 user_defined_checks.xsd
-rw-r--r-- 1 oracle oinstall       236 Nov 30 05:08 UserGuide.txt
drwxr-xr-x 2 oracle oinstall        61 Nov 30 04:44 web

查看 orachk 版本

$./orachk -v

ORACHK  VERSION: 18.4.0_20181129

惯例查看 readme.txt

$ more readme.txt

查看 UserGuide.txt

$ more UserGuide.txt

不管是在 grid 用户,还是 oracle 用户,在$ORACLE_HOME/suptools 下都有 orachk,tfa两个文件夹,只不过 orachk 版本相当老旧

grid用户

$ pwd
/u01/app/grid/product/12.1.0/grid_1/suptools
$ ls -l
total 0
drwxr-xr-x 3 grid oinstall 129 Jan 22 16:41 orachk
drwxr-x--- 3 grid oinstall  21 Jan 22 16:41 tfa

$ ./orachk/orachk -v

ORACHK  VERSION: 2.2.5_20140530

oracle用户

$ pwd
/u01/app/oracle/product/12.1.0/db_1/suptools
$ ls -l
total 0
drwxr-xr-x 3 oracle oinstall 129 Jan 22 17:01 orachk
drwxr-xr-x 3 oracle oinstall  21 Jan 22 17:00 tfa

$ ./orachk/orachk -v

ORACHK  VERSION: 2.2.5_20140530

ORAchk_Health_Check_Catalog.html 列出了检查项
ORAchk_and_EXAchk_User_Guide.pdf 需要仔细阅读这个文档

如何使用

$./orachk

不加参数时,是对本地安装的oracle产品做检测.
屏幕时不时有检测结果输出,输出的每一项都需要仔细查看.
直到生成压缩文件

UPLOAD [if required] - /home/oracle/orachk/orachk_oradb_orcl_012319_001938.zip

下载该文件到本地解压缩.仔细查看每一项输出,不仔细查看的话就失去了检查的意义.

先笔记一下,后面使用到了再补充

参考:
ORAchk - Health Checks for the Oracle Stack (Doc ID 1268927.2)
https://docs.oracle.com/en/engineered-systems/health-diagnostics/exachk/
https://community.oracle.com/docs/DOC-1028367