Skip to main content

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


TFA Failed to start listening for commands on one of the Rac Node :

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



Solution :

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 .

 
[root@host01]# ./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

[root@host01 bin]# pwd
/u01/app/12.1.0.2/grid/tfa/host01/tfa_home/bin
[root@host01 bin]# ./tfactl print status
 
.----------------------------------------------------------------------------------------------------.
| Host         | Status of TFA | PID   | Port | Version    | Build ID             | Inventory Status |
+--------------+---------------+-------+------+------------+----------------------+------------------+
| host01 | RUNNING       | 94580 | 5000 | 12.1.2.5.1 | 12125120150818011848 | COMPLETE         |
| host02 | RUNNING       | 13972 | 5000 | 12.1.2.5.1 | 12125120150818011848 | COMPLETE         |
'--------------+---------------+-------+------+------------+----------------------+------------------'
[root@host01 bin]# cat ../internal/portmapping.txt
host01:5000
host02:5000
[root@host01 bin]#
 
[root@host02 bin]# pwd
/u01/app/12.1.0.2/grid/tfa/host02/tfa_home/bin
[root@host02 bin]# ./tfactl print status
 
.----------------------------------------------------------------------------------------------------.
| Host         | Status of TFA | PID   | Port | Version    | Build ID             | Inventory Status |
+--------------+---------------+-------+------+------------+----------------------+------------------+
| host02 | RUNNING       | 13972 | 5000 | 12.1.2.5.1 | 12125120150818011848 | COMPLETE         |
| host01 | RUNNING       | 94580 | 5000 | 12.1.2.5.1 | 12125120150818011848 | COMPLETE         |
'--------------+---------------+-------+------+------------+----------------------+------------------'

 

Comments

Popular posts from this blog

ORA-65139: Mismatch between XML metadata file and data file

Error: CDB$ROOT@EBTUPRDC> CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse; CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse * ERROR at line 1: ORA-65139: Mismatch between XML metadata file and data file /u05/odb/ORADATA_1/EBTUSPRDC/datafile/system.1531.807800993 for value of fcpsb (2230502002 in the plug XML file, 2230505492 in the data file) Fix: Don't open Non-CDB database until we complete pdb creation other wise we will get above error. Shutdown immediate; startup mount; alter database open read only; create xml file. shutdown immediate; Connect to CDB and Create Pluggable database .

Useful OEM Queries to get Target details from OEM Repository

List Targets with TNS Listener ports configured : SELECT mgmt$target.host_name , mgmt$target.target_name , mgmt$target.target_type , mgmt$target_properties.property_name , mgmt$target_properties.property_value FROM mgmt$target , mgmt$target_properties WHERE ( mgmt$target.target_name = mgmt$target_properties.target_name ) AND ( mgmt$target.target_type = mgmt$target_properties.target_type ) and ( mgmt$target.target_type = 'oracle_listener' ) and ( mgmt$target_properties.property_name = 'Port' ); Devora02       LISTENER_ora02                       oracle_listener Port 1529 Devora01       LISTENER_ora01                       oracle_listener Port 1529 Devora04       LISTENE...