Tfactl has many advantages, and also support oracle uses this tool to troubleshoot and identify performance issues and to collect all database system wide errors.
This tool is preinstalled for RAC
To check if tfactl is installed and check the tfa home
grep TFA_HOME= /etc/init.d/init.tfaIf it would give a output such as
[root@xxxxxx ~]# grep TFA_HOME= /etc/init.d/init.tfa
TFA_HOME=/opt/oracle.ahf/tfa
Download and unzip the tfa installation file according to the document: Doc ID 2550798.1
[root@xxxx haf]# unzip AHF-LINUX_v24.11.0.zip
Archive: AHF-LINUX_v24.11.0.zip
inflating: ahf_setup
extracting: ahf_setup.dat
inflating: README.txt
inflating: oracle-tfa.pub
[root@lxxxx haf]# ls -ltr
total 623676
-rwx------. 1 root root 325905790 Dec 5 10:13 ahf_setup
-rw-------. 1 root root 384 Dec 5 10:13 ahf_setup.dat
-r-xr-x---. 1 root root 1537 Dec 5 10:14 README.txt
-r--------. 1 root root 625 Dec 5 10:14 oracle-tfa.pub
-rw-r--r--. 1 root root 312724035 Jan 9 10:37 AHF-LINUX_v24.11.0.zip
With root user, run the setup
[root@xxxxx haf]# ./ahf_setup -data_dir /u01/app/tfa/output -ahf_loc /u01/app/tfa
AHF Installer for Platform Linux Architecture x86_64
AHF Installation Log : /tmp/ahf_install_2411000_1770132_2025_01_09-11_10_15.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 24.11.0 Build Date: 202412050058
PERL : /u01/app/19.0.0.0/grid/perl/bin/perl
[ERROR] : AHF-00026: Perl is not owned by root. AHF Requires Perl to be root owned for AHF Installations as the root user.
We should copy the path of perl in the above error to the /opt/perl and change the permission of this directory in the /opt/perl path, as suggested by Doc ID 2884071.1
[root@xxx perl]# cp -pR /u01/app/19.0.0.0/grid/perl /opt/perl
[root@xxx perl]# chown -R root:oinstall /opt/perlRun the command again with the perl home option: perlhome /opt/perl
[root@lxdbaseora01q haf]# ./ahf_setup -data_dir /u01/tfa/output -ahf_loc /u01/tfa/ -perlhome /opt/perl
AHF Installer for Platform Linux Architecture x86_64
AHF Installation Log : /tmp/ahf_install_2411000_1782840_2025_01_09-11_38_14.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 24.11.0 Build Date: 202412050058
AHF Location : /u01/tfa/oracle.ahf
[ERROR] : AHF-00014: AHF Location /u01/tfa/oracle.ahf is not owned by root in directory hierarchyIt is necessary to use a location owned by root in hierarchy, be aware that AHF Data Directory requires at least 5GB (Recommended 10GB) of free space.
Otherwise, if you have no free space on other paths, use it for your own risk, set the environment variable: AHF_OVERRIDE_INSTALL_CHECKS (source: How to Install AHF when you encounter AHF-00014 ? – oratrails-aish)
[root@xxx haf]# export AHF_OVERRIDE_INSTALL_CHECKS=1
[root@xxx haf]# ./ahf_setup -data_dir /u01/tfa/output -ahf_loc /u01/tfa/ -perlhome /opt/perl
AHF Installer for Platform Linux Architecture x86_64
AHF Installation Log : /tmp/ahf_install_2411000_1790730_2025_01_09-11_55_53.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 24.11.0 Build Date: 202412050058
AHF Location : /u01/tfa/oracle.ahf
Suppressing 'AHF-00014: AHF Location /u01/tfa/oracle.ahf is not owned by root in directory hierarchy' as -force is enabled
AHF Data Directory : /u01/tfa/output/oracle.ahf/data
Suppressing AHF-00014: AHF Data Location /u01/tfa/output/oracle.ahf/data is not owned by root in directory hierarchy as -force is enabled
Do you want to add AHF Notification Email IDs ? [Y]|N : N
Extracting AHF to /u01/tfa/oracle.ahf
Setting up AHF CLI and SDK
/u01/tfa/oracle.ahf/shm/_installshm.sh: /u01/tfa/oracle.ahf/shm/install/crfinst.pl: /usr/bin/perl: bad interpreter: No such file or directory
Configuring TFA Services
Discovering Nodes and Oracle Resources
Not generating certificates as GI discovered
Starting TFA Services
Created symlink /etc/systemd/system/multi-user.target.wants/oracle-tfa.service -> /etc/systemd/system/oracle-tfa.service.
Created symlink /etc/systemd/system/graphical.target.wants/oracle-tfa.service -> /etc/systemd/system/oracle-tfa.service.
.--------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID |
+---------------+---------------+---------+------+-------------+-----------------------+
| lxdbaseora01q | RUNNING | 1793271 | 5000 | 24.11.0.0.0 | 241100020241205005852 |
'---------------+---------------+---------+------+-------------+-----------------------'
Running TFA Inventory...
Adding default users to TFA Access list...
.----------------------------------------------------------------------.
| Summary of AHF Configuration |
+-----------------+----------------------------------------------------+
| Parameter | Value |
+-----------------+----------------------------------------------------+
| AHF Location | /u01/tfa/oracle.ahf |
| TFA Location | /u01/tfa/oracle.ahf/tfa |
| Orachk Location | /u01/tfa/oracle.ahf/orachk |
| Data Directory | /u01/tfa/output/oracle.ahf/data |
| Repository | /u01/tfa/output/oracle.ahf/data/repository |
| Diag Directory | /u01/tfa/output/oracle.ahf/data/xxx/diag |
'-----------------+----------------------------------------------------'
Starting ORAchk Scheduler from AHF
AHF binaries are available in /u01/tfa/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_2411000_1790730_2025_01_09-11_55_53.log to /u01/tfa/output/oracle.ahf/data/xxx/diag/ahf/
Support documents: ORACLE-BASE – Oracle Trace File Analyzer (TFA)
Download tfa tool: Autonomous Health Framework (AHF) – Including Trace File Analyzer and Orachk/Exachk (Doc ID 2550798.1)
joviano silva - DBA Oracle 
Leave a comment