Skip navigation

The new Oracle Trace File Analyzer (TFA) with Database Support Tools Bundle release 12.1.2.8.4 is now available to download.

 

New Features in TFA 12.1.2.8.4:

Install and Run TFA without Root Privileges

Where possible you should install TFA as root. However if you are unable to install as root then TFA can now be installed as the ORACLE_HOME owner.

When installed as non root user TFA will not run a daemon (install as root to run the daemon) and as such will not perform automatic collections or collect from remote hosts. On-demand collections will work, but you will be limited to only collecting local files you have access to read.

To install without a daemon, tell TFA where to install using the -extractto option and where to find a JRE using the -javahome option. Use the JRE already available in the RDBMS home unless you have a later version available.

installTFALite -extractto <install_dir> -javahome <jre_home>

SR Data Collection is 10X Easier

When you need help from Oracle Support for certain types of Database problems they'll ask you to run a Service Request Data Collection (SRDC). Previously this would have involved reading many different support documents then collecting output from many different tasks and gathering lots of different diagnostics.

TFA can now run SRDC collections for you with a single command:

tfactl diagcollect -srdc <srdc_type>

For example the following will capture and zip everything needed to diagnose and resolve an ORA-00600:

tfactl diagcollect -srdc ora600

The files and diagnostics collected will depend on the problem the SRDC collection is about. TFA will prompt you for any other important information it needs depending on the SRDC type.

TFA currently has 10 different SRDC types with more on the way:

 

SRDCs for ORA errors:

  • ora600
  • ora7445
  • ora700
  • ora4031
  • ora4030
  • ora27300
  • ora27301
  • ora27302

 

SRDC for database performance problems:

  • dbperf

 

SRDC for all other types of internal database errors:

  • internalerror

 

For more information about SRDCs run tfactl diagcollect -srdc -help

Bash No Longer Required

TFA no longer has a requirement for bash. TFA will use a different mechanism for discovery if bash is unavailable.

If you do not use bash and your configuration does not follow ADR standards (i.e. diag directory is not in ORACLE_BASE) it will not be automatically discovered.

However any directories that are missed by the discovery can be easily added using the directory add command:

tfactl directory add <dir_path>

If bash is available, TFA will use it for discovery no matter where the diag directory is located.

For more details on TFA and to download see Document 1513912.1

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see https://community.oracle.com/docs/DOC-1022508 for instructions.