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
Advertisements

One thought on “Using TFA(Trace File Analyzer) Collector (Part 1)

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s