Google it ....

Showing posts with label trace file analyzer. Show all posts
Showing posts with label trace file analyzer. Show all posts

Friday, January 28, 2022

TFA-00002 : Oracle Trace File Analyzer (TFA) is not running

When I tried to view oratop on database server appears below error:
tfactl oratop -database testdb
TFA-00002 Oracle Trace File Analyzer (TFA) is not running
Solution : As a root user
/etc/init.d/init.tfa  start  
Starting TFA..
start: Job is already running: oracle-tfa
Waiting up to 100 seconds for TFA to be started..
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
Successfully started TFA Process..
. . . . .
TFA-00002 : Oracle Trace File Analyzer (TFA) is not running
TFA Failed to start listening for commands

If it is not started successfully than check below : 
run synctfanodes.sh if you have root password . 
if no root password copy below files to TFA Failed node and try to restart TFA .. Please check whether these 4 files exist on all nodes are similar.
TFA_HOME/server.jks 
TFA_HOME/client.jks 
TFA_HOME/internal/ssl.properties 
TFA_HOME/internal/ 
portmapping.txt If not similar just copy these files to TFA Failing node and try TFA Restart ..It Worked for me .
 
./tfactl  -v "debug" start
Starting TFA..
start: Job is already running: oracle-tfa
Waiting up to 100 seconds for TFA to be started..
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands

tfactl print status

.------------------------------------------------------------------------------------------------.
| Host    | Status of TFA | PID    | Port | Version    | Build ID             | Inventory Status |
+---------+---------------+--------+------+------------+----------------------+------------------+
| x82db01 | RUNNING       | 272939 | 5000 | 21.2.1.0.0 | 21210020210813042249 | COMPLETE         |
'---------+---------------+--------+------+------------+----------------------+------------------'
After that we can use oratop and monitor database with : tfactl oratop -database testdb

Monday, July 20, 2020

How to install TFA - Oracle Trace File Analyzer

In this post I will explain how We can install and use TFA. Oracle Trace File Analyzer (TFA) provides a number of diagnostic tools in a single bundle, making it easy to gather diagnostic information about the Oracle database and clusterware, which in turn helps with problem resolution when dealing with Oracle Support.

In many case Oracle will some output using this tool for your Service Requests.

First We need to download latest TFA version from Metalink. Please follow TFA Collector – TFA with Database Support Tools Bundle (Doc ID 1513912.1)


[root@exadb01 ahf]# ./ahf_setup 

AHF Installer for Platform Linux Architecture x86_64

AHF Installation Log : /tmp/ahf_install_202000_255172_2020_07_20-12_49_45.log

Starting Autonomous Health Framework (AHF) Installation

AHF Version: 20.2.0 Build Date: 202006260723

TFA is already installed at : /u01/app/12.2.0.1/grid/suptools/tfa/exadb01/tfa_home

Installed TFA Version : 192000 Build ID : 20190405072025

Default AHF Location : /opt/oracle.ahf

Do you want to install AHF at [/opt/oracle.ahf] ? [Y]|N : N  

Please Enter new AHF Location : /u01/ahf

AHF Location : /u01/ahf/oracle.ahf

AHF Data Directory stores diagnostic collections and metadata.
AHF Data Directory requires at least 5GB (Recommended 10GB) of free space.

Choose Data Directory from below options : 

1. /u01/app/grid [Free Space : 31501 MB]
2. /u01/ahf/oracle.ahf [Free Space : 31501 MB]
3. Enter a different Location

Choose Option [1 - 3] : 2

AHF Data Directory : /u01/ahf/oracle.ahf/data

Shutting down TFA : /u01/app/12.2.0.1/grid/suptools/tfa/exadb01/tfa_home

Copying TFA Data Files from /u01/app/12.2.0.1/grid/suptools/tfa/exadb01/tfa_home

Uninstalling TFA : /u01/app/12.2.0.1/grid/suptools/tfa/exadb01/tfa_home

Do you want to add AHF Notification Email IDs ? [Y]|N : N

AHF will also be installed/upgraded on these Cluster Nodes :

1. exadb02

The AHF Location and AHF Data Directory must exist on the above nodes
AHF Location : /u01/ahf/oracle.ahf
AHF Data Directory : /u01/ahf/oracle.ahf/data

Do you want to install/upgrade AHF on Cluster Nodes ? [Y]|N : Y

Extracting AHF to /u01/ahf/oracle.ahf

Configuring TFA Services

Copying TFA Data Files to AHF

Discovering Nodes and Oracle Resources


TFA will configure Storage Cells using SSH Setup:

.-----------------------------------.
|   | EXADATA CELL | CURRENT STATUS |
+---+--------------+----------------+
| 1 | exa1cel04    | ONLINE         |
| 2 | exa1cel05    | ONLINE         |
| 3 | exa1cel06    | ONLINE         |
| 4 | exa1cel07    | ONLINE         |
'---+--------------+----------------'


Starting TFA Services

.----------------------------------------------------------------------------.
| Host   | Status of TFA | PID    | Port | Version    | Build ID             |
+--------+---------------+--------+------+------------+----------------------+
| exadb01 | RUNNING       | 386561 | 5000 | 20.2.0.0.0 | 20200020200626072308 |
'--------+---------------+--------+------+------------+----------------------'

Running TFA Inventory...

Adding default users to TFA Access list...

.--------------------------------------------------------.
|              Summary of AHF Configuration              |
+-----------------+--------------------------------------+
| Parameter       | Value                                |
+-----------------+--------------------------------------+
| AHF Location    | /u01/ahf/oracle.ahf                  |
| TFA Location    | /u01/ahf/oracle.ahf/tfa              |
| Exachk Location | /u01/ahf/oracle.ahf/exachk           |
| Data Directory  | /u01/ahf/oracle.ahf/data             |
| Repository      | /u01/ahf/oracle.ahf/data/repository  |
| Diag Directory  | /u01/ahf/oracle.ahf/data/exadb01/diag |
'-----------------+--------------------------------------'


Starting exachk scheduler from AHF ...

AHF install completed on exadb01

Installing AHF on Remote Nodes :

AHF will be installed on exadb02, Please wait.

Installing AHF on exadb02 :

[exadb02] Copying AHF Installer

[exadb02] Running AHF Installer

AHF binaries are available in /u01/ahf/oracle.ahf/bin

AHF is successfully installed

Moving /tmp/ahf_install_202000_255172_2020_07_20-12_49_45.log to /u01/ahf/oracle.ahf/data/exadb01/diag/ahf/
# Collect data for all components for a specific time period.
./tfactl diagcollect -from "2020-07-18 13:00:00" -to "2020-07-19 13:00:00"
# Collect data for all components for the last 12 hours.
./tfactl diagcollect