oracledba.help works great on your mobile device too!

oracledba.help

Trace File Analyzer (TFA)

<- SpecialTopics

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

As the root user:

 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"

You may also want to run the above with the -all option.

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/orlldnatv01.
   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/orlldnatv02.
   tfa_Mon_Nov_20_07_49_56_EST_2017.zip