Trace File Analyzer - installation best practice?
Oracle 12.1.0.2 SE-2
Oracle Linux 6
So, starting to analyze a recent spate of ora-04031 on shared pool.
Find 1521925.1 which advises to "For all databases 11G onwards, TFA is the recommended approach and will gather all relevant diagnostics for the problem using one command:" Link to 2166084.1. From there, "Determine if TFA is installed and its location,
So off to 1513912.1.
Getting past all the marketing hype, I finally find a lengthy list of FAQs, and near the very bottom find a link that describes how to tell if TFA is installed, though it looks to me as if the method described (grep-ing for an entry in init.d) is making some big assumptions. After trying that and getting negative result, I tried simply 'find / -name tfactl' and found a hit in $ORACLE_HOME/suptools/tfa/release/tfa_home/bin. Executing 'tfactl print status' from there and got 'Please install TFA before running commands'.