Oracle 工具篇+Autonomous Health Framework (AHF)

说明：本文为面向Autonomous Health Framework (AHF)初学者的指导手册
标签：AHF、RDA、ORAchk、EXAChk、TFA、数据库诊断、数据库健康检查
注意：文中删去了不需要的多余部分，让初学者一目了然一学就会
相关工具：Oracle常用的诊断工具有：AHF、RDA、ORAchk、EXAChk、TFA
温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化

---

★ 相关文章
※ Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAChk (Doc ID 2550798.1)
※ Oracle 工具篇+Oracle Remote Diagnostic Agent（RDA）
※ 使用Oracle官方巡检工具ORAchk巡检数据库

---

★ 名词解释

Autonomous Health Framework (AHF)工具包包含了Oracle常用的多种诊断工具，用于Oracle健康检查等用途

---

★  AHF包含的工具及简介（20.4版本）（英文）

✔ TFA

Primary diagnostic collection tool, with Database Support Tools Bundle

✔ ORAchk / EXAchk

Oracle Stack Compliance Checks

✔ procwatcher

Automate & capture database performance diagnostics & session level hangs

See 459694.1 for more details.

✔ events

Reports warnings and errors seen in the logs

✔ managelogs

Shows disk space usage and purges ADR log and trace files

✔ alertsummary

Provides summary of events for one or more database or ASM alert files from all nodes

✔ ls / dir

Lists all files TFA knows about for a given file name pattern across all nodes

✔ summary

High level summary of the configuration

✔ vi / notepad

Open alert or trace files for viewing a given database and file name pattern in the vi editor

✔ tail

Run a tail on an alert or trace files for a given database and file name pattern

✔ param

Show all database and OS parameters that match a specified pattern

✔ oswatcher

Collect and archive OS metrics, useful for instance / node evictions & performance Issues.

See 301137.1 for more details.

✔ oratop

Near real-time database monitoring

See 1500864.1 for more details.

✔ pstack

Generate process stack for specified processes across all nodes

✔ grep / findstr

Search alert or trace files with a given database and file name pattern, for a search string

✔ dbglevel

Set and unset multiple CRS trace levels with one command

✔ history

Show the shell history for the tfactl shell

✔ changes

Report any noted changes in the system setup over a given time period. This includes database a parameters, OS parameters, patches applied etc

✔ calog

Reports major events from the Cluster Event log

✔ ps / tasklist

Finds processes

✔ triage

Summarize oswatcher/exawatcher data

---

★ MOS详情(Doc ID 2550798.1)

---

★ 安装AHF

[root@rac1 ahf]# ./ahf_setup 

AHF Installer for Platform Linux Architecture x86_64

AHF Installation Log : /tmp/ahf_install_204000_5324_2020_12_19-22_04_40.log

Starting Autonomous Health Framework (AHF) Installation

AHF Version: 20.4.0 Build Date: 202012141017

Default AHF Location : /opt/oracle.ahf

Do you want to install AHF at [/opt/oracle.ahf] ? [Y]|N : n

Please Enter new AHF Location : /ahf

AHF Location : /ahf/oracle.ahf

AHF Data Directory stores diagnostic collections and metadata.
AHF Data Directory requires at least 5GB (Recommended 10GB) of free space.

Choose Data Directory from below options : 

1. /u01/app/grid [Free Space : 48763 MB]
2. /ahf/oracle.ahf [Free Space : 48763 MB]
3. Enter a different Location

Choose Option [1 - 3] : 2

AHF Data Directory : /ahf/oracle.ahf/data

Do you want to add AHF Notification Email IDs ? [Y]|N : n

AHF will also be installed/upgraded on these Cluster Nodes :

1. rac2

The AHF Location and AHF Data Directory must exist on the above nodes
AHF Location : /ahf/oracle.ahf
AHF Data Directory : /ahf/oracle.ahf/data

Do you want to install/upgrade AHF on Cluster Nodes ? [Y]|N : y

Extracting AHF to /ahf/oracle.ahf

Configuring TFA Services

Discovering Nodes and Oracle Resources

Not generating certificates as GI discovered

Starting TFA Services

.------------------------------------------------------------------------.
| Host | Status of TFA | PID  | Port | Version    | Build ID             |
+------+---------------+------+------+------------+----------------------+
| rac1 | RUNNING       | 6292 | 5000 | 20.4.0.0.0 | 20400020201214101756 |
'------+---------------+------+------+------------+----------------------'

Running TFA Inventory...

Adding default users to TFA Access list...

.---------------------------------------------------.
|            Summary of AHF Configuration           |
+-----------------+---------------------------------+
| Parameter       | Value                           |
+-----------------+---------------------------------+
| AHF Location    | /ahf/oracle.ahf                 |
| TFA Location    | /ahf/oracle.ahf/tfa             |
| Orachk Location | /ahf/oracle.ahf/orachk          |
| Data Directory  | /ahf/oracle.ahf/data            |
| Repository      | /ahf/oracle.ahf/data/repository |
| Diag Directory  | /ahf/oracle.ahf/data/rac1/diag  |
'-----------------+---------------------------------'

Starting orachk scheduler from AHF ...

AHF install completed on rac1

Installing AHF on Remote Nodes :

AHF will be installed on rac2, Please wait.

AHF will prompt twice to install/upgrade per Remote Node. So total 2 prompts

Do you want to continue Y|[N] : Y

AHF will continue with Installing on remote nodes

Installing AHF on rac2 :

[rac2] Copying AHF Installer
root@rac2's password: 

[rac2] Running AHF Installer
root@rac2's password: 

AHF binaries are available in /ahf/oracle.ahf/bin

AHF is successfully installed

Moving /tmp/ahf_install_204000_5324_2020_12_19-22_04_40.log to /ahf/oracle.ahf/data/rac1/diag/ahf/

[root@rac1 ahf]# 

 

---

★ 执行AHF的orachk后生成的数据库健康报告案例——Oracle RAC Assessment Report

---

★ 以下列出了支持Oracle Autonomous Health Framework的产品

1. 1. Oracle Engineered Systems
      1. Oracle Big Data Appliance
      2. Oracle Exadata Database Machine Version 2 and later
      3. Zero Data Loss Recovery Appliance
      4. Oracle Private Cloud Appliance
   2. Oracle Database Appliance
   3. Oracle ASR
   4. Oracle Database
      1. Single-instance Oracle Database
      2. Oracle Grid Infrastructure and Oracle RAC
      3. Maximum Availability Architecture (MAA) validation
      4. Upgrade Readiness validation
      5. Oracle GoldenGate
      6. Application Continuity
   5. Enterprise Manager Cloud Control (12c only)
      1. Management Repository
      2. Management Agents
      3. Oracle Management Service (OMS), version 12.1.0.1 and later on Linux only
   6. Oracle Identity and Access Management
      1. Oracle Identity Manager (11.1.2.2.x and 11.1.2.3.x)
      2. Oracle Access Manager (11.1.2.2.x and 11.1.2.3.x)
      3. Oracle Unified Directory (11.1.2.2.x and 11.1.2.3.x)
   7. Oracle Hardware Systems
      1. Oracle Solaris
      2. Oracle Solaris Cluster
      3. Oracle Systems configuration for Oracle Middleware and Oracle Applications
      4. Oracle ZFS Storage Appliance
      5. Oracle Virtual Networking
   8. Oracle Siebel CRM
      1. Oracle Siebel verification of the database configuration for stability, best practices, and performance optimization (Siebel 8.1.1.11 connecting to Oracle Database 11.2.0.4.)
   9. Oracle PeopleSoft
      1. Oracle PeopleSoft verification of database best practices

 

---

※ 如果您觉得文章写的还不错， 别忘了在文末给作者点个赞哦 ~

over