Using TFA(Trace File Analyzer) Collector (Part 1)

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

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s