• Exadata健康检查工具EXAchk


    本文根据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技术。」
  • 相关阅读:
    DFS迷宫递归所有路径 新手入门
    【翻译】Ext JS最新技巧——2016-3-4
    Android进程通信之一:两种序列化方式
    Ext JS 6应用程序Build后出现“c is not a constructor return new c(a[0])”的处理
    简约才是王道? CardView 的使用
    经过一段的努力,终于成为CSDN博客专家,感谢大家支持
    ACM_Uppercase(水题)
    ACM_01背包
    2018年北京信息科技大学第十届程序设计竞赛暨ACM选拔赛-B-precise math function
    goj N皇后问题
  • 原文地址:https://www.cnblogs.com/jyzhao/p/14362976.html
Copyright © 2020-2023  润新知