In this post I will explain how We can install and use TFA. Oracle Trace File Analyzer (TFA) provides a number of diagnostic tools in a single bundle, making it easy to gather diagnostic information about the Oracle database and clusterware, which in turn helps with problem resolution when dealing with Oracle Support.
In many case Oracle will some output using this tool for your Service Requests.
First We need to download latest TFA version from Metalink. Please follow TFA Collector – TFA with Database Support Tools Bundle (Doc ID 1513912.1)
[root@exadb01 ahf]# ./ahf_setup AHF Installer for Platform Linux Architecture x86_64 AHF Installation Log : /tmp/ahf_install_202000_255172_2020_07_20-12_49_45.log Starting Autonomous Health Framework (AHF) Installation AHF Version: 20.2.0 Build Date: 202006260723 TFA is already installed at : /u01/app/12.2.0.1/grid/suptools/tfa/exadb01/tfa_home Installed TFA Version : 192000 Build ID : 20190405072025 Default AHF Location : /opt/oracle.ahf Do you want to install AHF at [/opt/oracle.ahf] ? [Y]|N : N Please Enter new AHF Location : /u01/ahf AHF Location : /u01/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 : 31501 MB] 2. /u01/ahf/oracle.ahf [Free Space : 31501 MB] 3. Enter a different Location Choose Option [1 - 3] : 2 AHF Data Directory : /u01/ahf/oracle.ahf/data Shutting down TFA : /u01/app/12.2.0.1/grid/suptools/tfa/exadb01/tfa_home Copying TFA Data Files from /u01/app/12.2.0.1/grid/suptools/tfa/exadb01/tfa_home Uninstalling TFA : /u01/app/12.2.0.1/grid/suptools/tfa/exadb01/tfa_home Do you want to add AHF Notification Email IDs ? [Y]|N : N AHF will also be installed/upgraded on these Cluster Nodes : 1. exadb02 The AHF Location and AHF Data Directory must exist on the above nodes AHF Location : /u01/ahf/oracle.ahf AHF Data Directory : /u01/ahf/oracle.ahf/data Do you want to install/upgrade AHF on Cluster Nodes ? [Y]|N : Y Extracting AHF to /u01/ahf/oracle.ahf Configuring TFA Services Copying TFA Data Files to AHF Discovering Nodes and Oracle Resources TFA will configure Storage Cells using SSH Setup: .-----------------------------------. | | EXADATA CELL | CURRENT STATUS | +---+--------------+----------------+ | 1 | exa1cel04 | ONLINE | | 2 | exa1cel05 | ONLINE | | 3 | exa1cel06 | ONLINE | | 4 | exa1cel07 | ONLINE | '---+--------------+----------------' Starting TFA Services .----------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | +--------+---------------+--------+------+------------+----------------------+ | exadb01 | RUNNING | 386561 | 5000 | 20.2.0.0.0 | 20200020200626072308 | '--------+---------------+--------+------+------------+----------------------' Running TFA Inventory... Adding default users to TFA Access list... .--------------------------------------------------------. | Summary of AHF Configuration | +-----------------+--------------------------------------+ | Parameter | Value | +-----------------+--------------------------------------+ | AHF Location | /u01/ahf/oracle.ahf | | TFA Location | /u01/ahf/oracle.ahf/tfa | | Exachk Location | /u01/ahf/oracle.ahf/exachk | | Data Directory | /u01/ahf/oracle.ahf/data | | Repository | /u01/ahf/oracle.ahf/data/repository | | Diag Directory | /u01/ahf/oracle.ahf/data/exadb01/diag | '-----------------+--------------------------------------' Starting exachk scheduler from AHF ... AHF install completed on exadb01 Installing AHF on Remote Nodes : AHF will be installed on exadb02, Please wait. Installing AHF on exadb02 : [exadb02] Copying AHF Installer [exadb02] Running AHF Installer AHF binaries are available in /u01/ahf/oracle.ahf/bin AHF is successfully installed Moving /tmp/ahf_install_202000_255172_2020_07_20-12_49_45.log to /u01/ahf/oracle.ahf/data/exadb01/diag/ahf/# Collect data for all components for a specific time period.
./tfactl diagcollect -from "2020-07-18 13:00:00" -to "2020-07-19 13:00:00"# Collect data for all components for the last 12 hours.
./tfactl diagcollect
