Google it ....

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

No comments:

Post a Comment