My Oracle Support Banner

ODA + TFA: The Unique Implementation of TFA on the Oracle Database Appliance (Doc ID 1908282.1)

Last updated on JULY 25, 2018

Applies to:

Oracle Database Appliance Software - Version 12.1.2 to [Release 12.1]
Information in this document applies to any platform.
TFA, ODA, Oracle_Database_Appliance, Configuration,


The ODA (Oracle Database Appliance)  provides the (Trace File Analyzer Data Collector) and ORAchk by default.

However, there were some limitations using the TFA on the earlier versions of the ODA as the TFA was included in each bundle is customized specifically for the ODA Version used!
In fact, downloading and applying the downloadable TFA could break the TFA usage on the older ODA versions.
However, the new TFA detects product versions and HW being used.

This means that you can now download the latest TFA (recommended) but you should always be up to one of the most recent ODA versions to derive the best compatibility and benefit of the TFA,
The TFA is an automatic data collection and upload tool used to assist Oracle Support in Service request troubleshooting by collecting substantial diagnostic information across several key directories. 
These key files are collected for a targeted time period matching the SR needs by issuing a few simple commands and then compresses these files trimming unnecessary information for upload to Oracle Support.
 Note: "...Development groups are currently working toward consolidating the downloadable TFA with ODA specific information which will be announced once available..."

If you are on one of the most current ODA versions (e.g. or newer) you can use the most current TFA.
However, advisory information may not be aligned with the ODA functionality so if you detect recommendations that seem questionable you may want to research the suggestions.


This note will focus on TFA usage and diagnostic collection methods most typically requested for the Oracle Database Appliance (ODA)
This note will provide simple usage examples for quick reference and usage including:

Where is the TFA located on the ODA?

What TFA commands are there to collect diagnostics?

Which TFA commands are the most commonly used on the ODA?

What diagnostic collection methods are available?

How to specify a Time range for TFA a collection


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.