TFA(Trace File Analyzer) Collector –
Tool for Enhanced Diagnostic Gathering (Doc ID 1513912.2)
As described on MOS, Trace File Analyzer Collector (TFA) is a diagnostic collection utility to simplify
diagnostic data collection on Oracle Clusterware/Grid Infrastructure, RAC and Single Instance Database systems.
TFA is similar to the diagcollection utility packaged with Oracle Clusterware in that it collects and packages
diagnostic data – however – TFA is MUCH more powerful than diagcollection with its ability to centralize and
automate the collection of diagnostic information.
Note: The installation for TFA is on my previous Post:
Install TFA
1.) Stop/Start
Note: Remember that all path are on PATH variable, below my .bash_profile for ROOT:
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export JAVA_HOME=/oracle/grid/jdk
export ORACLE_BASE=/oracle
export CRS_HOME=/oracle/grid
export TFA_HOME=/oracle/tfa/lnx01/tfa_home
PATH=$PATH:$CRS_HOME/bin:/oracle/grid/perl/bin:/oracle/tfa/bin
export PATH
— As Root:
[root@lnx01 ~]# tfactl stop
Stopping TFA from the Command Line
Stopped OSWatcher
TFA is running – Will wait 5 seconds (up to 3 times)
TFA is running – Will wait 5 seconds (up to 3 times)
TFA-00002 : Oracle Trace File Analyzer (TFA) is not running
TFA Stopped Successfully
. . .
Successfully stopped TFA..
[root@lnx01 ~]# ps -ef | grep -i tfa
root 7059 1 0 04:51 ? 00:00:00 /bin/sh /etc/init.d/init.tfa run
root 7155 1 1 04:51 ? 00:00:26 /oracle/grid/jdk/jre/bin/java -Xms128m -Xmx512m -classpath /oracle/tfa/lnx01/tfa_home/jlib/RATFA.jar:/oracle/tfa/lnx01/tfa_home/jlib/je-5.0.84.jar:/oracle/tfa/lnx01/tfa_home/jlib/ojdbc5.jar:/oracle/tfa/lnx01/tfa_home/jlib/commons-io-2.1.jar oracle.rat.tfa.TFAMain /oracle/tfa/lnx01/tfa_home
[root@lnx01 ~]# tfactl start
Note: If you face the problem below to start:
TFA-00002 : Oracle Trace File Analyzer (TFA) is not running
TFA Failed to start listening for commands
Check this file (./database/BERKELEY_JE_DB/je.lck) with FUSER,
if you found some PID:
kill -9 <PID>
rm ./database/BERKELEY_JE_DB/je.lck
tfactl start
Note: If you face some problem with PERL:
ln -s /oracle/grid/perl/bin/perl /usr/bin/perl
Logs:
-rw-r–r– 1 root root 4627 Apr 29 05:29 syserrorout.04.29.2016-04.51.14
-rw-r–r– 1 root root 207726 Apr 29 05:29 tfa.04.29.2016-04.51.15.log
-rw-r–r– 1 root root 1069 Apr 29 05:31 syserrorout.04.29.2016-05.31.19
-rw-r–r– 1 root root 1069 Apr 29 05:31 syserrorout.04.29.2016-05.31.58
-rw-r–r– 1 root root 1069 Apr 29 05:32 syserrorout.04.29.2016-05.32.36
-rw-r–r– 1 root root 1069 Apr 29 05:37 syserrorout.04.29.2016-05.37.24
-rw-r–r– 1 root root 3172 Apr 29 05:50 syserrorout.04.29.2016-05.47.33
-rw-r–r– 1 root root 14327 Apr 29 05:50 tfa.04.29.2016-05.47.34.log
-rw-r–r– 1 root root 1069 Apr 29 05:52 syserrorout.04.29.2016-05.52.22
-rw-r–r– 1 root root 1588 Apr 29 05:55 syserrorout.04.29.2016-05.55.10
-rw-r–r– 1 root root 1166 Apr 29 05:56 tfa.04.29.2016-05.55.11.log
[root@lnx01 log]# pwd
/oracle/tfa/lnx01/tfa_home/log
2.) TFACTL PRINT options
[root@lnx01 ~]# tfactl print status
.——————————————————————————————–.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+——-+—————+——+——+————+———————-+——————+
| lnx01 | RUNNING | 5402 | 5000 | 12.1.2.7.0 | 12127020160303214632 | COMPLETE |
‘——-+—————+——+——+————+———————-+——————‘
[root@lnx01 ~]# tfactl print config
.—————————————————————.
| lnx01 |
+————————————————–+————+
| Configuration Parameter | Value |
+————————————————–+————+
| TFA version | 12.1.2.7.0 |
| Automatic diagnostic collection | OFF |
| Alert Log Scan | ON |
| Trimming of files during diagcollection | ON |
| Repository current size (MB) | 4 |
| Repository maximum size (MB) | 1439 |
| Inventory Trace level | 1 |
| Collection Trace level | 1 |
| Scan Trace level | 1 |
| Other Trace level | 1 |
| Max Size of TFA Log (MB) | 50 |
| Max Number of TFA Logs | 10 |
| Max Size of Core File (MB) | 20 |
| Max Collection Size of Core Files (MB) | 200 |
| Automatic Purging | ON |
| Minimum Age of Collections to Purge (Hours) | 12 |
| Minimum Space Free to enable Alert Log Scan (MB) | 500 |
‘————————————————–+————‘
[root@lnx01 ~]# tfactl print directories
.——————————————————————————————————————————.
| lnx01 |
+————————————+—————————————————————–+————+———-+
| Trace Directory | Component | Permission | Added By |
+————————————+—————————————————————–+————+———-+
| /etc/oracle | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oraInventory/ContentsXML | [INSTALL] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oraInventory/logs | [INSTALL] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/cfgtoollogs | [CFGTOOLS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/@global/cvu | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/acfs | [ACFS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/core | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/crsconfig | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/crsdiag | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/cvu | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/evm | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/output | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/ovmmwallet | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/ovmmwallets | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/rhp | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/scripts | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/crsdata/lnx01/trace | [CRS] | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/asm/+asm/+ASM/cdump | [ASM]{ASM|instance=+ASM} | public | root |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/asm/+asm/+ASM/trace | [ASM]{ASM|instance=+ASM} | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/clients/user_oracle/h | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root |
| ost_2315295561_76/cdump | | | |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/clients/user_oracle/h | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root |
| ost_2315295561_76/trace | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/clients/user_oracle/h | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root |
| ost_2315295561_82/cdump | | | |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/clients/user_oracle/h | [DBCLIENT]{DBCLIENT|instance=user_oracle} | public | root |
| ost_2315295561_82/trace | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/crs/lnx01/crs/cdump | [CRS] | public | root |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/cdb/CDB/cdump | [RDBMS]{RDBMS|instance=CDB, RDBMS|database=cdb} | public | root |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/cdb/CDB/trace | [RDBMS]{RDBMS|instance=CDB, RDBMS|database=cdb} | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/cdb1/CDB1/cdump | [RDBMS]{RDBMS|instance=CDB1, RDBMS|database=cdb1} | public | root |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/cdb1/CDB1/trace | [RDBMS]{RDBMS|instance=CDB1, RDBMS|database=cdb1} | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/db01/db01/cdump | [RDBMS]{RDBMS|instance=db01, RDBMS|database=db01} | public | root |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/db01/db01/trace | [RDBMS]{RDBMS|instance=db01, RDBMS|database=db01} | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/db11/db11/cdump | [RDBMS]{RDBMS|instance=db11, RDBMS|database=db11} | public | root |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/db11/db11/trace | [RDBMS]{RDBMS|instance=db11, RDBMS|database=db11} | public | root |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/db12c/db12c/cdu | [RDBMS]{RDBMS|instance=db12c, RDBMS|database=db12c} | public | root |
| mp | | | |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/db12c/db12c/tra | [RDBMS]{RDBMS|instance=db12c, RDBMS|database=db12c} | public | root |
| ce | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/ecby_pitr_pdb1_ | [RDBMS]{RDBMS|instance=ecby, RDBMS|database=ecby_pitr_pdb1_cdb} | public | root |
| cdb/ecby/cdump | | | |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/rdbms/ecby_pitr_pdb1_ | [RDBMS]{RDBMS|instance=ecby, RDBMS|database=ecby_pitr_pdb1_cdb} | public | root |
| cdb/ecby/trace | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/tnslsnr/lnx01/listene | [TNS] | public | root |
| r/cdump | | | |
| Collection policy : No Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/diag/tnslsnr/lnx01/listene | [TNS] | public | root |
| r/trace | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/product/11.2/db_1/log/diag | [RDBMS]{RDBMS|instance=DBUA0, RDBMS|database=dbua0} | public | root |
| /rdbms/dbua0/DBUA0/trace | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/product/12.1.0.2/db_1/cfgt | [CFGTOOLS] | public | root |
| oollogs | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/product/12.1.0.2/db_1/inst | [INSTALL] | public | root |
| all | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/tfa/repository/suptools/ln | [OS] | public | root |
| x01/oswbb/oracle/archive | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /oracle/tfa/repository/suptools/pr | [RDBMS] | public | root |
| w | | | |
| Collection policy : Exclusions | | | |
+————————————+—————————————————————–+————+———-+
| /var/log | [OS, RACDBCLOUD] | public | root |
| Collection policy : Exclusions | | | |
‘————————————+—————————————————————–+————+———-‘
[root@lnx01 ~]# tfactl print hosts
Host Name : lnx01
[root@lnx01 ~]# tfactl print actions
.———————————————————–.
| HOST | START TIME | END TIME | ACTION | STATUS | COMMENTS |
+——+————+———-+——–+——–+———-+
‘——+————+———-+——–+——–+———-‘
[root@lnx01 ~]# tfactl print collections
No diagnostic collections to print in TFA
[root@lnx01 ~]# tfactl print repository
.———————————————–.
| lnx01 |
+———————-+————————+
| Repository Parameter | Value |
+———————-+————————+
| Location | /oracle/tfa/repository |
| Maximum Size (MB) | 1439 |
| Current Size (MB) | 5 |
| Free Size (MB) | 1434 |
| Status | OPEN |
‘———————-+————————‘
Continuing on … Part 2
[…] Installing TFA(Trace File Analyzer) Collector […]
LikeLike
[…] Installing TFA(Trace File Analyzer) Collector […]
LikeLike
Hi @CARLOS MAGNO
I am not able to install…
Here is the problem
ROOT have different perl version 5.8.8
oracle home – 5.8.3
Application home – 5.6.1
It is creating a lot of confusion also it read the oraInst.loc
Any sugestion ? ( i tried the Link and path trick but everytime new error of perl occurs)
If the installtion get complete it doesn’t detect the running Database !
NON-RAC, UAT WITH 2 TEST INSTANCE, R12
DB – 11.1.0.7
LikeLike
Hello, sorry about the delay, today here is Holiday.
Lets try find out what is happening:
Please provide the info below:
as ROOT:
1.) locate perl
2.) echo $PATH
3.) perl -v
4.) echo $ORACLE_BASE
5.) echo $JAVA_HOME
The best option to use PERL is from ORACLE installations (GRID or DB).
https://ezdba.wordpress.com/2016/04/29/installing-tfatrace-file-analyzer-collector/
Best Regards
LikeLike
Hi Carlos ,
I tried to install tfa and had to abandoned the installation when its in phase : checking ssh permissions to 2nd node, due to root permission issue.
I can see bin directory created but its empty and have below created.
/u01/app/tfa
oracle@….$ ls -ltrh
total 121828
-rw-r–r– 1 root root 59M Nov 21 11:23 tfa_install.27991.zip
drwxr-xr-x 2 root root 512 Nov 21 11:23 bin
drwxr-xr-x 3 root root 512 Nov 21 11:24 db1
Is it safe to restart the installation normally after correcting ssh issue?
And also Can you pls let me know whether installing tfa on 11g RAC will have any performance issue and can cause any db operational issues?
Thanks in advance!
LikeLike