Oracle Trace File Analyzer Version 19.2.1

Share via:

 We care for your speed. Below is an easy way to perform an upgrade/re-installation of Oracle Trace File Analyzer in Oracle Real Application Clusters.

What is Oracle Trace File Analyzer ?

  • Trace File Analyzer Collector (TFA) is a diagnostic collection utility to simplify diagnostic data collection on Oracle Cluster ware/Grid Infrastructure, RAC and Single Instance Database systems.
  • Oracle Trace File Analyzer collects and analyzes diagnostic data.
  • You can use Oracle Trace File Analyzer with all supported versions of Oracle Database and Oracle Grid Infrastructure.
  • To obtain the fullest capabilities of Oracle Trace File Analyzer, the software needs to be installed as root user.
  • Trace file analyzer is very useful tool for collecting diagnostic data on-demand For errors like ORA-600/ORA-7445 useful for Oracle Support need to diagnose a specific type of problem.

  • If you are unable to install as root, then install TFA can be installed as the oracle user but below functionality will not be usable.

-Automatic collections

-Collections from remote hosts

-Collecting of files which are not readable by the ORACLE_HOME owner, e.g. /var/log/messages or certain clusterware daemon logs.

 TFA OSWATCHER :

  • Oswatcher is integrated with TFA and is a very important tool used for Linux/UNIX paced operating systems where monitoring OS is very important aspect when it comes to identifying CPU, RAM or network related issues.
  • One of the benefits of OSWatcher is that it will also examine the Cluster Interconnect for the Oracle RAC Cluster which helps in determining node eviction issues.

Oswatcher invokes below utilities  depending on the OS platforms and collect diagnostics logs for determining performance issues.

oswvmstat
oswmpstat
oswnetstat
oswiostat
oswifconfig
oswtop
oswps
oswprvtnet
oswmeminfo
oswslabinfo

Installation of Oracle Trace File Analyzer:

TFA Collector – TFA with Database Support Tools Bundle (Doc ID 1513912.1)  can be downloaded at below link.

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1513912.1

Please note :  Oracle TFA is preinstalled with Grid software’s as a part of Oracle 12c Real application clusters installation. We need to uninstall/Install or upgrade it to the latest version of TFA 19.2.1.

Install as root user:

  • It is always good to install Oracle TFA as root user as it will give you full capabilities to collect and analyze Diagnostics data.
  • If TFA is already installed, reinstalling will upgrade the software in existing location.

Download the appropriate Oracle Trace File Analyzer zip, copy to required machine and unzip.

Run the installTFA command: $ ./ installTFA-LINUX

Now check the status of TFA.

 Custom Collections

 Collecting from Specific Nodes

By default TFA will collect from all nodes in the cluster, to collect from only specific nodes,

use diagcollect –node <list of nodes>:

By default TFA will collect from all database and Grid Infrastructure components. The components collected from can be restricted by specifying only those required.

For example to trim and collect all files from database hrdb & fdb in the last 1 day:

To trim and collect all CRS files, operating system logs and CHMOS/OSW data from node1 & node2 updated in the last 6 hours:

To trim and collect all ASM logs from node1 updated between from and to time:

To collect Service request diagnostic collection for ora-600 and ora-7445 errors.

To collect TFA for specific time duration.

 Steps for Uninstallaton of TFA software:

execute ./uninstalltfa.sh for uninstalling TFA from 1st Node ( or any Node)

It will uninstall TFA from all host nodes in RAC.

Fresh Installation of Oracle Trace File Analyzer:

Examples for diagnostics collection:

Diagnostics collection for last 1 hour:

Diagnostics collection for Specific time:

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 4.60 out of 5)
Loading...

One thought on “Oracle Trace File Analyzer Version 19.2.1

Add Comment