oracledba.help
SpecialTopics

Trace File Analyzer (TFA)

Overview

The Oracle Trace File Analyzer (TFA) analyzes trace files and packages them up in a zip file for upload to My Oracle Support (MOS).

If the TFA is already installed, reinstalling will perform an upgrade to the existing location. If it is not already installed, the recommended location is /opt/oracle.tfa

The Cluster Ready Services (CRS) do not manage Oracle Trace File Analyzer. This is because it needs to be available should CRS go down. The installation configures Oracle Trace File Analyzer for auto start (via init).

Installation

Download latest TFA via: Doc ID 1513912.1

 su -
 mkdir /u01/orasw/tfa
 cp file to /u01/orasw/tfa
 cd /u01/orasw/tfa
 unzip TFA-LINUX_v12.2.1.3.0.zip
 ./installTFA-LINUX

 Do you want to continue with patching TFA? [Y|N] [Y]: Y

 If RAC you will get this prompt:
  Do you want to configure SSH on these nodes ? [Y|N] [Y]: Y

 Process runs...

Success looks similar to this:

 .-------------------------------------------------------------.
 | Host  | TFA Version | TFA Build ID         | Upgrade Status |
 +-------+-------------+----------------------+----------------+
 | lnx01 |  12.2.1.3.0 | 12213020171106082156 | UPGRADED       |
 .-------+-------------+----------------------+----------------.

Usage

Perform as the root user.

Format: tfactl diagcollect -from "yyyy-mm-dd hh:mm:ss" -to "yyyy-mm-dd hh:mm:ss"
Example: ./tfactl diagcollect -from "2017-11-17 14:00:00" -to "2017-11-20 16:00:00"

Non-RAC

  • cd /u01/app/oracle/tfa/bin

RAC

  • cd /u01/app/12.2.0.1/grid/tfa/bin

Run Command

 ./tfactl diagcollect -from "2017-11-17 13:00:00" -to "2017-11-17 16:00:00"

The -all option is now deprecated as this is the default.

Output looks similar to this:

 .----------------------------------.
 |        Collection Summary        |
 +-------+-----------+-------+------+
 | Host  | Status    | Size  | Time |
 +-------+-----------+-------+------+
 | lnx01 | Completed | 224kB |  31s |
 .-------+-----------+-------+------.

Logs

Non-RAC
Logs are collected to: /u01/app/oracle/tfa/repository/collection_<date>

 /u01/app/oracle/tfa/repository/collection_Mon_Nov_20_07_21_58_EST_2017_node_all
    /lnx01.tfa_Mon_Nov_20_07_21_58_EST_2017.zip

RAC
Logs are collected to: /u01/app/grid/tfa/repository/collection_<date>

 /u01/app/grid/tfa/repository/collection_Mon_Nov_20_07_49_56_EST_2017_node_all/rac01.
   tfa_Mon_Nov_20_07_49_56_EST_2017.zip
 /u01/app/grid/tfa/repository/collection_Mon_Nov_20_07_49_56_EST_2017_node_all/rac02.
   tfa_Mon_Nov_20_07_49_56_EST_2017.zip