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.
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.
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 your 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 protected] 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 [email protected]
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 protected] file1.zip file2.zip file3.zip