Exadata健康检查工具EXAchk
2021-02-02 17:00 AlfredZhao 阅读(1187) 评论(0) 编辑 收藏 举报本文根据MOS文章:Oracle Exadata Database Machine EXAchk (Doc ID 1070954.1)整理关键步骤。
注:通常都会要求使用当前最新可用的EXAchk版本进行健康检查。
1.查看当前版本
因为Exachk 现在是自治运行状况框架 (AHF) 和跟踪文件分析器 (TFA) 的组成部分。安装 AHF 的当前版本,即可获取最新的 Exachk 和 TFA 版本。 所以既可以通过tfactl查看版本信息,也可以单独查看:tfactl version -all
exachk -v
若查询结果不匹配最新,则下载最新可用的 Exachk 版本,进行版本更新。反之就可以直接进行第三步巡检信息采集。
要查找 AHF/Exachk 文件结构的根目录,请执行以下命令:
# cat /etc/oracle.ahf.loc
/opt/oracle.ahf
此外,如果完整的 AHF 安装成功,则 Exachk 应安排每天 02:00 执行 exatier1 配置文件。您可以使用以下命令验证自动运行配置:
# exachk -get all -id autostart_client_exatier1
2.执行版本更新
下载最新可用版本,在上面提到的MOS文章中有下载链接。当前最新可用版本是:v20.4。然后解压:# unzip AHF-LINUX_v20.4.0.zip
Archive: AHF-LINUX_v20.4.0.zip
inflating: README.txt
inflating: ahf_setup
更新版本:
# ./ahf_setup -ahf_loc /opt -data_dir <ORACLE_BASE of Grid owner>
# ./ahf_setup -ahf_loc /opt -data_dir /u01/app/grid
实际执行如下:
[root@dbm08dbadm01 ~]# ./ahf_setup -ahf_loc /opt -data_dir /u01/app/grid
AHF Installer for Platform Linux Architecture x86_64
AHF Installation Log : /tmp/ahf_install_204000_252391_2021_02_02-15_08_40.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 20.4.0 Build Date: 202012141017
AHF is already installed at /opt/oracle.ahf
Installed AHF Version: 20.2.3 Build Date: 202010121848
Do you want to upgrade AHF [Y]|N : y
AHF will also be installed/upgraded on these Cluster Nodes :
1. dbm08dbadm02
The AHF Location and AHF Data Directory must exist on the above nodes
AHF Location : /opt/oracle.ahf
AHF Data Directory : /u01/app/grid/oracle.ahf/data
Do you want to install/upgrade AHF on Cluster Nodes ? [Y]|N : y
Upgrading /opt/oracle.ahf
Shutting down AHF Services
Shutting down TFA
Removed symlink /etc/systemd/system/graphical.target.wants/oracle-tfa.service.
Removed symlink /etc/systemd/system/multi-user.target.wants/oracle-tfa.service.
. . . . .
. . .
Successfully shutdown TFA..
Starting AHF Services
Starting TFA..
Created symlink from /etc/systemd/system/multi-user.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service.
Created symlink from /etc/systemd/system/graphical.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service.
Waiting up to 100 seconds for TFA to be started..
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands
No new directories were added to TFA
INFO: Starting exachk scheduler in background. Details for the process can be found at /u01/app/grid/oracle.ahf/data/dbm08dbadm01/diag/exachk/compliance_start_020221_151142.log
AHF upgrade completed on dbm08dbadm01
Upgrading AHF on Remote Nodes :
AHF will be installed on dbm08dbadm02, Please wait.
Please Enter the password for dbm08dbadm02 :
Is password same for all the nodes? [Y]|N : y
Upgrading AHF on dbm08dbadm02 :
[dbm08dbadm02] Copying AHF Installer
[dbm08dbadm02] Running AHF Installer
AHF is sucessfully upgraded to latest version
.--------------------------------------------------------------------.
| Host | TFA Version | TFA Build ID | Upgrade Status |
+--------------+-------------+----------------------+----------------+
| dbm08dbadm01 | 20.4.0.0.0 | 20400020201214101756 | UPGRADED |
| dbm08dbadm02 | 20.4.0.0.0 | 20400020201214101756 | UPGRADED |
'--------------+-------------+----------------------+----------------'
Moving /tmp/ahf_install_204000_252391_2021_02_02-15_08_40.log to /u01/app/grid/oracle.ahf/data/dbm08dbadm01/diag/ahf/
[root@dbm08dbadm01 ~]#
再次查询版本确认更新成功:
[root@dbm08dbadm01 ~]# exachk -v
EXACHK VERSION: 20.4.0_20201214
[root@dbm08dbadm01 ~]# tfactl version -all
TFA Version : 204000
TFA Build ID : 20201214101756
TFA Build Label : TFA_MAIN_GENERIC_201213.1900
EXACHK VERSION: 20.4.0_20201214
AHF VERSION: 20.4.0
3.执行exachk巡检
使用最新版本的exachk进行巡检:[root@dbm08dbadm01 ~]# which exachk
/usr/bin/exachk
[root@dbm08dbadm01 ~]# exachk
..
UPLOAD [if required] - /u01/app/grid/oracle.ahf/data/dbm08dbadm01/exachk/user_root/output/exachk_dbm08dbadm01_cdb1db1_020221_15276.zip
根据交互提示输入对应的数据库信息、如果没有配置互信,还需要输入CELL节点、交换机的密码等信息,完成采集后下载压缩包到本机查看结果,重点关注critical类问题。
AlfredZhao©版权所有「从Oracle起航,领略精彩的IT技术。」