Description:
Trace File Analyzer Collector also known as TFA is a diagnostic collection utility which greatly simplifies the diagnostic data collection for both Oracle Database as well as Oracle Clusterware/Grid Infrastructure RAC environments.Trace File Analyzer provides a central and single interface for all diagnostic data collection and analysis.
Step 1: If possible you should install as root. This will give you the richest capabilities.
To install as root:
- Download the appropriate installer from above, copy to a target machine and unzip
- Run the TFA & ORAchk/EXAchk install command ./ahf_setup [-ahf_loc install_dir] [-data_dir data_dir]
Step 2: Run the below command to install
./ahf_setup -data_dir /u01/ahf/output -ahf_loc /u01/ahf
[root@atlora01 u01]# ./ahf_setup -data_dir /u01/ahf/output -ahf_loc /u01/ahf AHF Installer for Platform Linux Architecture x86_64 AHF Installation Log : /tmp/ahf_install_212100_8431_2021_08_30-18_09_41.log Starting Autonomous Health Framework (AHF) Installation AHF Version: 21.2.1 Build Date: 202108130422 TFA is already installed at : /u01/app/12.2.0.1/grid/tfa/atlora01/tfa_home Installed TFA Version : 181100 Build ID : 20180328025002 AHF Location : /u01/ahf/oracle.ahf AHF Data Directory : /u01/ahf/output/oracle.ahf/data Shutting down TFA : /u01/app/12.2.0.1/grid/tfa/atlora01/tfa_home Copying TFA Data Files from /u01/app/12.2.0.1/grid/tfa/atlora01/tfa_homeUninstalling TFA : /u01/app/12.2.0.1/grid/tfa/atlora01/tfa_home
Do you want to add AHF Notification Email IDs ? [Y]|N : N
Extracting AHF to /u01/ahf/oracle.ahf
Configuring TFA Services
Copying TFA Data Files to AHF
Discovering Nodes and Oracle Resources
Starting TFA Services
.-----------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | +----------+---------------+-------+------+------------+----------------------+ | atlora01 | RUNNING | 12593 | 5000 | 21.2.1.0.0 | 21210020210813042249 | '----------+---------------+-------+------+------------+----------------------'
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 | | Orachk Location | /u01/ahf/oracle.ahf/orachk | | Data Directory | /u01/ahf/output/oracle.ahf/data | | Repository | /u01/ahf/output/oracle.ahf/data/repository | | Diag Directory | /u01/ahf/output/oracle.ahf/data/atlora01/diag | '-----------------+-----------------------------------------------' Starting orachk scheduler from AHF ...
Adding rpm Metadata to rpm database on ODA system RPM File /u01/ahf/oracle.ahf/rpms/oracle-ahf-212100-20210813042249.x86_64.rpm Preparing... ########################################### [100%] Using Dummy RPM Installer for oracle-ahf Tool Install Base /opt/oracle.ahf
1:oracle-ahf ########################################### [100%] Installing oracle-ahf
AHF binaries are available in /u01/ahf/oracle.ahf/bin
AHF is successfully installed
Do you want AHF to store your My Oracle Support Credentials for Automatic Upload ? Y|[N] : N Moving /tmp/ahf_install_212100_8431_2021_08_30-18_09_41.log to /u01/ahf/output/oracle.ahf/data/atlora01/diag/ahf/
Step 3: Trace File Analyzer Command Examples
Viewing System and Cluster Summary
tfactl summary
To find all errors in the last one day
tfactl analyze -last 1d
To find all occurrences of a specific error (in this case ORA-00600 errors)
tfactl analyze -search “ora-00600” -last 8h
To set the notification email to use
tfactl set notificationAddress=joeblogs@oracle.com
Enable or disable Automatic collections (ON by default)
tfactl set autodiagcollect=OFF
Adjusting the Diagnostic Data Collection Period
tfactl diagcollect -last 1 h
tfactl diagcollect -from “2018-03-21″
tfactl diagcollect from “2018-03-21” -to “2018-03-22”
Analyze, trim and zip all files updated in the last 12 hours, including Cluster Health Monitor and OSWatcher data, from across all nodes the cluster
tfactl diagcollect -all -last 12h
Recent Posts
