The new Oracle Trace File Analyzer (TFA) with Database Support Tools Bundle release 220.127.116.11.4 is now available to download.
New Features in TFA 18.104.22.168.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.
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:
For example the following will capture and zip everything needed to diagnose and resolve an ORA-00600:
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:
SRDC for database performance problems:
SRDC for all other types of internal database errors:
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:
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