Wednesday 1 August 2018

How to Installation TFA(TRACE FILE ANALYZER) COLLECTOR in Oracle database step by step

TFA(Trace File Analyzer) Collector 

TFA Collector - TFA with Database Support Tools Bundle (Doc ID 1513912.1)

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:

oracle linux 6.5

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

1.) Download:

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

TFA 18.2.1.0.0, file: TFA-LINUX_v18.2.1.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 TFA-LINUX_v18.2.1.zip

[root@qb Trace_File_Analyser]# ls -ltr
total 87440
-rw-r--r-- 1 root root   583593 Jul  27 15:32 TFACollectorDocV121270.pdf
-r-xr-xr-x 1 root root 44414287 Jul  27 15:34 installTFA-LINUX
-rw-r--r-- 1 root root 44534701 Jul  27 04:07 TFA-LINUX_v18.2.1.zip
-rw-r--r-- 1 root root 44534701 Jul  27 04:07 README

Oracle recommends install under $ORACLE_BASE

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

export ORACLE_BASE=/oracle

3.) Install

variables:

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

./installTFA-LINUX $ORACLE_BASE -javahome $JAVA_HOME

On my case the option:
[root@qb Trace_File_Analyser]$ ./installTFA-LINUX
TFA Installation Log will be written to File : /tmp/tfa_install_12114_2018_07_27-16_58_53.log


Starting TFA installation

TFA Version: 182100 Build Date: 201805291110

Enter a location for installing TFA (/tfa will be appended if not supplied) [/tmp/Trace_File_Analyser/tfa]:
/u02/ora11g/app/ora11g/product/11.2.0/dbhome_1

Running Auto Setup for TFA as user ora11g...

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

Starting Discovery...


No Grid Infrastructure Discovered on this system . . . . .

qb
Searching for running databases...
1. DEV
1. qborcl11g


Searching out ORACLE_HOME for selected databases...


Getting Oracle Inventory...

ORACLE INVENTORY: /u02/ora11g/oraInventory


Discovery Complete...



TFA Will be Installed on qb...

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

.------------------------------------------------------------------------.
|                                   qb                                   |
+-------------------------------------------------------------+----------+
| Trace Directory                                             | Resource |
+-------------------------------------------------------------+----------+
| /u02/ora11g/app/ora11g/cfgtoollogs                          | CFGTOOLS |
| /u02/ora11g/app/ora11g/diag/rdbms/qborcl11g/qborcl11/cdump  | RDBMS    |
| /u02/ora11g/app/ora11g/diag/rdbms/qborcl11g/qborcl11/trace  | RDBMS    |
| /u02/ora11g/app/ora11g/diag/rdbms/qborcl11g/qborcl11g/cdump | RDBMS    |
| /u02/ora11g/app/ora11g/diag/rdbms/qborcl11g/qborcl11g/trace | RDBMS    |
| /u02/ora11g/app/ora11g/diag/tnslsnr                         | TNS      |
| /u02/ora11g/app/ora11g/diag/tnslsnr/qb/listener/cdump       | TNS      |
| /u02/ora11g/app/ora11g/diag/tnslsnr/qb/listener/trace       | TNS      |
| /u02/ora11g/app/ora11g/product/11.2.0/dbhome_1/cfgtoollogs  | CFGTOOLS |
| /u02/ora11g/app/ora11g/product/11.2.0/dbhome_1/install      | INSTALL  |
| /u02/ora11g/oraInventory/ContentsXML                        | INSTALL  |
| /u02/ora11g/oraInventory/logs                               | INSTALL  |
'-------------------------------------------------------------+----------'


Installing TFA on qb:
HOST: qb TFA_HOME: /u02/ora11g/app/ora11g/product/11.2.0/dbhome_1/tfa/qb/tfa_home

.--------------------------------------------------------------------------.
| Host | Status of TFA | PID   | Port  | Version    | Build ID             |
+------+---------------+-------+-------+------------+----------------------+
| qb   | RUNNING       | 12713 | 25897 | 18.2.1.0.0 | 18210020180529111033 |
'------+---------------+-------+-------+------------+----------------------'

Running Inventory in All Nodes...

Summary of TFA Installation:
.--------------------------------------------------------------------------------------.
|                                          qb                                          |
+---------------------+----------------------------------------------------------------+
| Parameter           | Value                                                          |
+---------------------+----------------------------------------------------------------+
| Install location    | /u02/ora11g/app/ora11g/product/11.2.0/dbhome_1/tfa/qb/tfa_home |
| Repository location | /u02/ora11g/app/ora11g/product/11.2.0/dbhome_1/tfa/repository  |
| Repository usage    | 0 MB out of 10240 MB                                           |
'---------------------+----------------------------------------------------------------'

TFA is successfully installed...

Usage : /u02/ora11g/app/ora11g/product/11.2.0/dbhome_1/tfa/bin/tfactl <command> [options]
    commands:diagcollect|collection|analyze|ips|run|start|stop|enable|disable|status|print|access|purge|directory|host|receiver|set|toolstatus|uninstall|diagnosetfa|syncnodes|setupmos|upload|availability|rest
For detailed help on each command use:
  /u02/ora11g/app/ora11g/product/11.2.0/dbhome_1/tfa/bin/tfactl <command> -help


[rootg@qb Trace_File_Analyser]$

1 comment:

Anonymous said...

Merkur 25C (2021) - Chrome/Silver Merkur 25C
Merkur 25C is the classic and reliable all-in-one safety razor for all 메리트카지노 needs. Made in Solingen, Germany. Merkur's 25C razor 카지노 was designed 더킹카지노 for those who love to