Oracle Autonomous Health包括Oracle ORAchk或
Oracle EXAchk 和 Oracle Trace File Analyzer (TFA)
安装
参考文档 (Doc ID 2550798.1)： https://support.oracle.com/epmos/faces/DocContentDisplay?id=2550798.1
在文档上可以找到下面的两个版本下载：
AHF 20.1 (Beta) for Linux TFA & ORAchk/EXAchk 19.3.2 for Linux
Oracle在raccheck的基础之上又推出了orachk，现在这个AHF又包括了Trace File Analyzer (TFA) 和 ORAchk/EXAchk。
./ahf_setup -ahf_loc /home/oracle/ahf/ahf19 AHF Installer for Platform Linux Architecture x86_64 AHF Installation Log : /tmp/ahf_install_15735_2020_03_14-20_13_53.log Starting Autonomous Health Framework (AHF) Installation AHF Version: 193200 Build Date: 201911251327 ./ahf_setup: line 1307: perl: command not found AHF Location : /home/oracle/ahf/ahf19/oracle.ahf AHF Data Directory : /home/oracle/ahf/ahf19/oracle.ahf/data Extracting AHF to /home/oracle/ahf/ahf19/oracle.ahf /home/oracle/ahf/ahf19/oracle.ahf/tfa/bin/tfactl: line 106: perl: command not found Configuring TFA in Standalone Mode... Build Version : 193200 Build Date : 201911251327 Discovering Nodes and Oracle Resources .--------------------------------------------------------------------. | Summary of TFA Configuration | +----------------+---------------------------------------------------+ | Parameter | Value | +----------------+---------------------------------------------------+ | TFA Location | /home/oracle/ahf/ahf19/oracle.ahf/tfa | | Data Directory | /home/oracle/ahf/ahf19/oracle.ahf/data//tfa | | Repository | /home/oracle/ahf/ahf19/oracle.ahf/data/repository | | Diag Directory | /home/oracle/ahf/ahf19/oracle.ahf/data//diag/tfa | | Java Home | /home/oracle/ahf/ahf19/oracle.ahf/jre | '----------------+---------------------------------------------------' Exception in thread "OfflineMessageHandler" java.lang.NullPointerException at oracle.rat.tfa.TFADirectoryManager.isValidTFADirectory(TFADirectoryManager.java:1101) at oracle.rat.tfa.TFADirectoryManager.addFromFileLine(TFADirectoryManager.java:1144) at oracle.rat.tfa.util.Properties.readDirectoriesFile(Properties.java:1213) at oracle.rat.tfa.util.Properties.<init>(Properties.java:973) at oracle.rat.tfa.util.Properties.getInstance(Properties.java:1032) at oracle.rat.tfa.OfflineMessageHandler.main(OfflineMessageHandler.java:1007) .---------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status | +------+---------------+-----+------+---------+----------+------------------+ '------+---------------+-----+------+---------+----------+------------------' AHF is deployed at /home/oracle/ahf/ahf19/oracle.ahf ORAchk is available at /home/oracle/ahf/ahf19/oracle.ahf/bin/orachk AHF binaries are available in /home/oracle/ahf/ahf19/oracle.ahf/bin AHF is successfully installed Moving /tmp/ahf_install_15735_2020_03_14-20_13_53.log to /home/oracle/ahf/ahf19/oracle.ahf/data//diag/ahf/
安装过程中有报错是因为没有安装perl，使用yum安装perl后症状消失。
使用root用户安装会设置auto-start。Linux 使用 init,
The most severe problems at 2am, once a day
All known problems once a week at 3am on a Sunday
Send an email to the notification addresses, provided during install of any check failures and a diff since last run
可以使用./orachk -autostop终止自动运行。
运行
./orachk –d start 以daemon方式运行
./orachk run compliance checks on-demand
./orachk –u –o pre 升级前检查
./orachk –u –o post 升级后检查
./orachk -dball 检查所有数据库
./orachk –dbnames db1,db2,db3 检查指定数据库
./orachk -nordbms 只检查grid，包括数据库
./orachk –profile dba,clusterware 指定的profile
./orachk –profile -h 查询profile
-failedchecks previous_result 只运行上次出错的检查
