TFA

Oracle Trace File Analyzer

TFA is part of AHF

tfactl provides a command-line interface and shell to do the following:

Authorized non-root users can run a subset of the tfactl commands. All other tfactl commands require root access. Users who are not authorized cannot run any tfactl command.

By default, the following users are authorized to access a subset of tfactl commands:


https://docs.oracle.com/en/engineered-systems/health-diagnostics/trace-file-analyzer/tfaug/quick-start-guide.html#GUID-5EB34BD2-E1A1-418C-95D1-30323523331B

Install

As 'root'...

./installTFA-platform

If Oracle Trace File Analyzer is already installed, then reinstalling performs an upgrade to the existing location.If Oracle Trace File Analyzer is not already installed, then the recommended location is /opt/oracle.tfa.

Usage

tfactl

tfactl start

tfactl stop

tfactl disable

tfactl enable

tfactl menu

Enter interactive tfactl shell

Start the TFA daemon

Stop the TFA daemon

Disables automatic restarting of the TFA daemon

Enables automatic restarting of the TFA daemon

Launch menu style interface

Configuration

tfactl print config

Show configuration parameters

Telemetry

tfactl set telemetry=off

Note that this appears to have no effect (certainly in TFA version 221210)  i.e. print config and the output of this "set" command show that telemetry remains "ON". Workaround may be to use OCI dbcli.

tfactl get telemetry

tfactl get telemetry_adapter

tfactl get telemetry -match

Status

tfactl print status

Status and version information

Access

tfactl access lsusers

tfactl access add -user myuser

tfactl access add -user myuser -local

tfactl access remove -user myuser

tfactl access removeall

tfactl access reset

tfactl access enable

tfactl access disable

List TFA users (e.g. oracle) and their status

Add a user (cluster-wide)

Add a user (restricted to local node)

Remove a user (use -local for local node only)

Remove all users (use -local for local node only)

Reset user access to default

Enable user access

Disable user access

Deinstall

tfactl uninstall

To deinstall TFA

Summary

tfactl summary

Analyze

tfactl analyze -last 1d

tfactl analyze -last 18h

tfactl analyze -search "ora-00600" -last 8h

Tools

If you install TFA from 1513912.1 it includes an Oracle Database support tools bundle...

tfactl toolstatus

tfactl run oratop -database orcl

Lists intsalled tools

Run oratop (connect / as sysdba)

.------------------------------------------------------------------.|               TOOLS STATUS - HOST : gsams-axl-ora04              |+----------------------+--------------+--------------+-------------+| Tool Type            | Tool         | Version      | Status      |+----------------------+--------------+--------------+-------------+| AHF Utilities        | alertsummary |       22.2.1 | DEPLOYED    ||                      | calog        |       22.2.1 | DEPLOYED    ||                      | dbglevel     |       22.2.1 | DEPLOYED    ||                      | grep         |       22.2.1 | DEPLOYED    ||                      | history      |       22.2.1 | DEPLOYED    ||                      | ls           |       22.2.1 | DEPLOYED    ||                      | managelogs   |       22.2.1 | DEPLOYED    ||                      | menu         |       22.2.1 | DEPLOYED    ||                      | orachk       |       22.2.1 | DEPLOYED    ||                      | param        |       22.2.1 | DEPLOYED    ||                      | ps           |       22.2.1 | DEPLOYED    ||                      | pstack       |       22.2.1 | DEPLOYED    ||                      | summary      |       22.2.1 | DEPLOYED    ||                      | tail         |       22.2.1 | DEPLOYED    ||                      | triage       |       22.2.1 | DEPLOYED    ||                      | vi           |       22.2.1 | DEPLOYED    |+----------------------+--------------+--------------+-------------+| Development Tools    | oratop       |       14.1.2 | DEPLOYED    |+----------------------+--------------+--------------+-------------+| Support Tools Bundle | darda        | 2.10.0.R6036 | DEPLOYED    ||                      | oswbb        | 22.1.0AHF    | NOT RUNNING ||                      | prw          | 12.1.13.11.4 | NOT RUNNING |'----------------------+--------------+--------------+-------------'
Note :-  DEPLOYED    : Installed and Available - To be configured or run interactively.  NOT RUNNING : Configured and Available - Currently turned off interactively.  RUNNING     : Configured and Available.

Troubleshooting

Issue...

tfactl diagcollect -srdc dbrmanTraceback (most recent call last):  File "/opt/oracle.ahf/python/lib/python3.10/runpy.py", line 196, in _run_module_as_main    return _run_code(code, main_globals, None,  File "/opt/oracle.ahf/python/lib/python3.10/runpy.py", line 86, in _run_code    exec(code, run_globals)  File "/ade/aime_tfa_222619/oracle/tfa/src/tfactl_py/src/__main__.py", line 76, in <module>  File "/ade/aime_tfa_222619/oracle/tfa/src/tfactl_py/src/tfactl/common/tfaconstants.py", line 309, in check_ahf_install_properties_contentException: ['COMMON_DATA_DIR', 'TFA_DATA_DIR', 'WORK_DIR', 'DIAG_DIR', 'TFA_DIAG_DIR', 'ORACHK_DIAG_DIR'] point to missing directories

Check install.properties file...

cat /opt/oracle.ahf/install.properties

Check that the referenced directories exist and the user you are using to run tfactl has appropriate permssions on those directories.

In a test with AHF 22.2.1 on AIX we needed to do this...

chmod -R o+r oracle.ahf.data

chmod o+x oracle.ahf.data

Bibliography