Oracle Trace File Analyzer (TFA)
Oracle Trace File Analyzer (TFA) provides a number of diagnostic tools in a single bundle, making it easy to gather diagnostic information about the Oracle database and clusterware, which in turn helps with problem resolution when dealing with Oracle Support.
- Download Oracle Trace File Analyzer (TFA)
- Install Oracle Trace File Analyzer (TFA)
- Run a Oracle Trace File Analyzer (TFA) Collection
- Upload to My Oracle Support (MOS)
Download Oracle Trace File Analyzer (TFA)
Trace File Analyzer (TFA) has been shipped with the Oracle database since 188.8.131.52, so you may already have it, but Oracle recommend downloading the latest version on a regular basis to get the best results. The following location gives an overview of the TFA product, as well as download links and basic instructions.
This article assumes you've downloaded the latest version of TFA and it is placed in the "/u01/software" directory.
Install Oracle Trace File Analyzer (TFA)
Trace File Analyzer (TFA) can be installed as the "root" user on the server, which provides the most functionality and allows it to run in a proactive manner as a daemon, or locally as the Oracle software owner. In this example we will perform a local installation, making it a reactive tool.
Unzip the software, create a destination location and install the software using the "-local" flag.
cd /u01/software unzip TFA-LINUX_v18.2.1.zip mkdir -p $ORACLE_HOME/tfa ./installTFA-LINUX -local -tfabase $ORACLE_HOME/tfa
Run a Oracle Trace File Analyzer (TFA) Collection
With the installation complete we can use the
tfactl command to perform a number of collections, including TFA Service Request Data Collections (SRDC).
There are a large number of SRDC collection types, with each gathering different information, as described here.
Here are a few examples.
cd $ORACLE_HOME/tfa/bin/ # Gather diagnostic information about TFA itself. ./tfactl diagnosetfa -local # Gather information about errors. You are prompted to select a specific incident. ./tfactl diagcollect -srdc ORA-00600 ./tfactl diagcollect -srdc ORA-07445 # Collect data for all components for a specific time period. ./tfactl diagcollect -from "2018-06-16 13:00:00" -to "2018-06-16 13:00:00" # Collect data for all components for the last 12 hours. ./tfactl diagcollect
Each TFA collection produces a single zip file that can be uploaded to My Oracle Support (MOS), as described below.
Upload to My Oracle Support (MOS)
You can manually upload a zip file produced by TFA by attaching it to you SR through the MOS website in the normal way. An alternative is to get TFA to upload it and attach it to your Service Request (SR). To do this you must provide your MOS credentials. This can be done as part of the command line, or they can be stored in a secure wallet by running the following command as the "root" user.
# ./tfactl setupmos Enter User Id: email@example.com Enter Password: Wallet does not exist ... creating Wallet created successfully USER details added/updated in the wallet PASSWORD details added/updated in the wallet SUCCESS - CERTIMPORT - Successfully imported certificate #
The result of a TFA collection can be uploaded directly to MOS by including the "-sr" option in the command to specify the target SR number.
# MOS credentials supplied by wallet. ./tfactl diagcollect -srdc ORA-00600 -sr 1-12345678901 # MOS credentials supplied on command line. You are prompted for the password. ./tfactl diagcollect -srdc ORA-00600 -sr 1-12345678901 -user firstname.lastname@example.org
You can upload one or more files (both TFA generated and other files) as a separate action using the following commands.
# MOS credentials supplied by wallet. ./tfactl upload -sr 1-12345678901 -wallet file1.zip file2.zip file3.zip # MOS credentials supplied on command line. You are prompted for the password. ./tfactl upload -sr 1-12345678901 -user email@example.com file1.zip file2.zip file3.zip
For more information see:
- Oracle Trace File Analyzer (TFA)
- Collecting Diagnostic Data and Using One Command Service Request Data Collections
Hope this helps. Regards Tim...