DBA Hub

📋Steps in this guide1/4

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.

oracle miscconfigurationintermediate
by OracleDba
21 views
1

Download Oracle Trace File Analyzer (TFA)

Trace File Analyzer (TFA) has been shipped with the Oracle database since 11.2.0.4, 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. - Oracle Trace File Analyzer (TFA) This article assumes you've downloaded the latest version of TFA and it is placed in the "/u01/software" directory.
2

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.

Code/Command (click line numbers to comment):

1
2
3
4
5
cd /u01/software
unzip TFA-LINUX_v18.2.1.zip

mkdir -p $ORACLE_HOME/tfa
./installTFA-LINUX -local -tfabase $ORACLE_HOME/tfa
3

Run a Oracle Trace File Analyzer (TFA) Collection

With the installation complete we can use the 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. Each TFA collection produces a single zip file that can be uploaded to My Oracle Support (MOS), as described below.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
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
4

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. 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. You can upload one or more files (both TFA generated and other files) as a separate action using the following commands. For more information see: - Oracle Trace File Analyzer (TFA) - Collecting Diagnostic Data and Using One Command Service Request Data Collections - Autonomous Health Framework (AFH) Hope this helps. Regards Tim...

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
# ./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
#

# 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]

# 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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!