Installing TFA(Trace File Analyzer) Collector

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.

My Environment:

Linux lnx01 3.8.13-118.2.1.el6uek.x86_64 #2 SMP Thu Nov 26 20:37:55 PST 2015 x86_64 x86_64 x86_64 GNU/Linux

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

[oracle@lnx01 ~]$ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda2        11G  7.2G  2.5G  75% /
tmpfs           2.9G  1.2G  1.7G  42% /dev/shm
/dev/sda1       479M   54M  396M  12% /boot
/dev/sdb1        30G   25G  3.3G  89% /oracle
/dev/sdd1       4.8G  3.3G  1.3G  73% /data01
/dev/sde1       9.8G  5.4G  3.9G  59% /data02
/dev/sdf1        20G  9.1G  9.6G  49% /data03

[oracle@lnx01 ~]$ ps -ef | grep smon
oracle    1809     1  0 03:44 ?        00:00:00 ora_smon_db11
oracle    1862     1  0 03:44 ?        00:00:00 ora_smon_db12c
oracle    1993     1  0 03:44 ?        00:00:00 asm_smon_+ASM
oracle    2324     1  0 03:46 ?        00:00:00 ora_smon_CDB


1.) Download:

On MOS: 1513912.2
you can download the version below, is the lastest version (04-2016):

TFA 12.1.2.4.0, file: TFALite_v12.1.2.7.0.zip

On this version as reported on MOS:

    New TFA tools - summary, events, changes, ps, pstack and param all with cluster support
    New dbglevel tool to help when setting CRS trace levels for multiple modules across nodes
    Cluster support for existing TFA tools alertsummary, grep and tail
    Version updates to Support Tools - DARDA, SQLT and ORAchk
    Support for diagnostics collection from ODA Dom0
    Support for Dom0 diagnostic collections on Exadata
    Critical Bug Fixes

2.) Preparing the Installation:

As root copy the ZIP file to a directory on Server:
after copy zip file to server:

unzip TFALite_v12.1.2.7.0.zip

[root@lnx01 tfa]# ls -ltr
total 87440
-rw-r--r-- 1 root root   583593 Mar  4 15:32 TFACollectorDocV121270.pdf
-r-xr-xr-x 1 root root 44414287 Mar  4 15:34 installTFALite
-rw-r--r-- 1 root root 44534701 Apr 29 04:07 TFALite_v12.1.2.7.0.zip

Oracle recommends install under $ORACLE_BASE

Note: i will update the bash_profile (root) with the variable below:

export ORACLE_BASE=/oracle

3.) JAVA

Prior to installing TFA you MUST install JRE 1.5 or higher.

On my case i will use the JAVA installed on GRID_HOME:

[oracle@lnx01 bin]$ ./java -version
java version "1.6.0_75"
Java(TM) SE Runtime Environment (build 1.6.0_75-b13)
Java HotSpot(TM) 64-Bit Server VM (build 20.75-b01, mixed mode)
[oracle@lnx01 bin]$ pwd
/oracle/grid/jdk/bin

My JAVA_HOME will be, i will update the bash_profile (ROOT and ORACLE):

export JAVA_HOME=/oracle/grid/jdk

4.) PERL

You need put PERL on the PATH variable:

export PATH=$PATH:$CRS_HOME/bin:/oracle/grid/perl/bin

[root@lnx01 ~]# perl -v

This is perl 5, version 14, subversion 1 (v5.14.1) built for x86_64-linux-thread-multi

5.) Install

variables:

JAVA_HOME=/oracle/grid/jdk
ORACLE_BASE=/oracle

./installTFALite -tfabase $ORACLE_BASE -javahome $JAVA_HOME

On my case the option:

[L]ocal

TFA Installation Log will be written to File : /tmp/tfa_install_5586_2016_04_29-04_51_01.log

Starting TFA installation

Using JAVA_HOME : /oracle/grid/jdk

Running Auto Setup for TFA as user root...

Would you like to do a [L]ocal only or [C]lusterwide installation ? [L|l|C|c] [C] : l
Installing TFA now...

Discovering Nodes and Oracle resources

Checking whether CRS is up and running

List of nodes in cluster
1. lnx01

Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

. . . . . . . . .


TFA Will be Installed on lnx01...

TFA will scan the following Directories
++++++++++++++++++++++++++++++++++++++++++++

.-----------------------------------------------------------------------.
|                                 lnx01                                 |
+------------------------------------------------------------+----------+
| Trace Directory                                            | Resource |
+------------------------------------------------------------+----------+
| /oraInventory/ContentsXML                                  | INSTALL  |
| /oraInventory/logs                                         | INSTALL  |
| /oracle/cfgtoollogs                                        | CFGTOOLS |
| /oracle/diag/asm/+asm/+ASM/cdump                           | ASM      |
| /oracle/diag/asm/+asm/+ASM/trace                           | ASM      |
| /oracle/diag/clients/user_oracle/host_2315295561_76/cdump  | DBCLIENT |
| /oracle/diag/clients/user_oracle/host_2315295561_76/trace  | DBCLIENT |
| /oracle/diag/clients/user_oracle/host_2315295561_82/cdump  | DBCLIENT |
| /oracle/diag/clients/user_oracle/host_2315295561_82/trace  | DBCLIENT |
| /oracle/diag/crs/lnx01/crs/cdump                           | CRS      |
| /oracle/diag/rdbms/cdb/CDB/cdump                           | RDBMS    |
| /oracle/diag/rdbms/cdb/CDB/trace                           | RDBMS    |
| /oracle/diag/rdbms/cdb1/CDB1/cdump                         | RDBMS    |
| /oracle/diag/rdbms/cdb1/CDB1/trace                         | RDBMS    |
| /oracle/diag/rdbms/db01/db01/cdump                         | RDBMS    |
| /oracle/diag/rdbms/db01/db01/trace                         | RDBMS    |
| /oracle/diag/rdbms/db11/db11/cdump                         | RDBMS    |
| /oracle/diag/rdbms/db11/db11/trace                         | RDBMS    |
| /oracle/diag/rdbms/db12c/db12c/cdump                       | RDBMS    |
| /oracle/diag/rdbms/db12c/db12c/trace                       | RDBMS    |
| /oracle/diag/rdbms/ecby_pitr_pdb1_cdb/ecby/cdump           | RDBMS    |
| /oracle/diag/rdbms/ecby_pitr_pdb1_cdb/ecby/trace           | RDBMS    |
| /oracle/diag/tnslsnr/lnx01/listener/cdump                  | TNS      |
| /oracle/diag/tnslsnr/lnx01/listener/trace                  | TNS      |
| /oracle/product/11.2/db_1/log/diag/rdbms/dbua0/DBUA0/trace | RDBMS    |
| /oracle/product/12.1.0.2/db_1/cfgtoollogs                  | CFGTOOLS |
| /oracle/product/12.1.0.2/db_1/install                      | INSTALL  |
| /usr/tmp                                                   | ZDLRA    |
'------------------------------------------------------------+----------'


Installing TFA on lnx01:
HOST: lnx01     TFA_HOME: /oracle/tfa/lnx01/tfa_home



.-------------------------------------------------------------------------.
| Host  | Status of TFA | PID  | Port | Version    | Build ID             |
+-------+---------------+------+------+------------+----------------------+
| lnx01 | RUNNING       | null | 5000 | 12.1.2.7.0 | 12127020160303214632 |
'-------+---------------+------+------+------------+----------------------'

Running Inventory in All Nodes...

Enabling Access for Non-root Users on lnx01...

Adding Local Oracle Home Owners to TFA

Sucessfully added 'oracle' to TFA Access list.

.---------------------------------.
|        TFA Users in lnx01       |
+-----------+-----------+---------+
| User Name | User Type | Status  |
+-----------+-----------+---------+
| oracle    | USER      | Allowed |
'-----------+-----------+---------'


Summary of TFA Installation:
.--------------------------------------------------.
|                       lnx01                      |
+---------------------+----------------------------+
| Parameter           | Value                      |
+---------------------+----------------------------+
| Install location    | /oracle/tfa/lnx01/tfa_home |
| Repository location | /oracle/tfa/repository     |
| Repository usage    | 0 MB out of 1439 MB        |
'---------------------+----------------------------'


TFA is successfully installed...


Usage : /oracle/tfa/bin/tfactl <command> [options]
<command> =
          start        Starts TFA
          stop         Stops TFA
          enable       Enable TFA Auto restart
          disable      Disable TFA Auto restart
          print        Print requested details
          access       Add or Remove or List TFA Users
          purge        Delete collections from TFA repository
          directory    Add or Remove or Modify directory in TFA
          host         Add or Remove host in TFA
          diagcollect  Collect logs from across nodes in cluster
          collection   Manage TFA Collections
          analyze      List events summary and search strings in alert logs.
          set          Turn ON/OFF or Modify various TFA features
          toolstatus     Prints the status of TFA Support Tools
          run <tool>     Run the desired support tool
          start <tool>   Starts the desired support tool
          stop <tool>    Stops the desired support tool
          syncnodes      Generate/Copy TFA Certificates
          diagnosetfa    Collect TFA Diagnostics
          uninstall      Uninstall TFA from this node

For help with a command: /oracle/tfa/bin/tfactl <command> -help

6.) Pos-Installation

Put the variable below on the bash_profile (ROOT and ORACLE)
check your TFA_HOME on the installation output 

export TFA_HOME=/oracle/tfa/lnx01/tfa_home

Include the path below on the PATH variable, for tfactl:

/oracle/tfa/bin

7.) Checking TFA

[root@lnx01 ~]# tfactl print status

.--------------------------------------------------------------------------------------------.
| Host  | Status of TFA | PID  | Port | Version    | Build ID             | Inventory Status |
+-------+---------------+------+------+------------+----------------------+------------------+
| lnx01 | RUNNING       | null | 5000 | 12.1.2.7.0 | 12127020160303214632 | COMPLETE         |
'-------+---------------+------+------+------------+----------------------+------------------'

Next.... Using TFA


 

Advertisements

4 thoughts on “Installing TFA(Trace File Analyzer) Collector

  1. 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

    Like

  2. 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!

    Like

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