Friday, August 26, 2016

TFA Collector # 11.2.0.4 RAC new Feature

using TFA Collector - Tool for Enhanced Diagnostic Gathering (Doc ID 1513912.2)
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 diag collection utility packaged with Oracle Clusterware in that it collects and packages diagnostic data

TFA Collector Simplifies diagnostic data collection and with a single command performs clusterwide diagnostic collection is performed with a single command executed from a single node Diagnostic data uploads to Support are reduced by a factor of 10x or more in most cases and Diagnostic files “trimmed” around the incident time. Collected diagnostics are consolidated on a single node and increased efficiency of admin staff

To check TFA Status #
[oracle@tnc1 bin]$ $GRID_HOME/bin/tfactl print status

[oracle@tnc1 bin]$ cd ..
[oracle@tnc1 grid]$ cd crs/
[oracle@tnc1 crs]$ cd install/
[oracle@tnc1 install]$ ls -ltr

To Install TFA tool 
[oracle@tnc1 install]$ ls -ltr tfa_setup.sh
-rwxr-xr-x 1 root oinstall 15343311 Mar 11 04:35 tfa_setup.sh

To print configuration # 
[oracle@tnc1 install]$ $GRID_HOME/bin/tfactl print config


To check Errors in RAC Cluster # 
[oracle@tnc1 install]$ $GRID_HOME/bin/tfactl print errors
Total Errors found in database: 0
DONE

--References # 
https://juliandontcheff.wordpress.com/2013/08/28/oracle-database-11-2-0-4-new-features/
http://www.hhutzler.de/blog/trace-file-analyzer-collector-tfa-collector/
Linux: Oracle RAC Node Reboot Hangs on TFA Process (Doc ID 1983567.1)

--Nikhil Tatineni--
-- RAC 11.2.0.4 # 

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...