Skip to content

Using 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.

    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

    Also See:

    TAF Architecture

    ORAchk