Why?
Trace
File Analyzer (TFA) is a tools provided by Oracle as a part of diagnostic free
tools , now a day it is part of Automatic Health Framework (AHF), in RAC environment
grid user will be added by default however if you need to run this to collect
any issue in DB home and you are installing this using different user (oracle
for DB and grid for Grid ), then you have to add oracle user to the access of
TFA or it will failed to run and show you a message about this , below in
simple steps I am shown how to add this user .
How?
Below
are steps to check and grant Oracle access to TFA:
1- Check the tfactl status using root or grid
user, a waring for old TFA you may got if it is old, then upgrade is
recommended:
tfactl status
WARNING - TFA Software is
older than 180 days. Please consider upgrading TFA to the latest version.
.---------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+--------+---------------+------+------+------------+----------------------+------------------+
| <hostname> |
RUNNING | 5648 | 5000 | 18.1.2.0.0
| 18120020180510233906 | COMPLETE
|
| <hostname2> |
RUNNING | 6230 | 5000 | 18.1.2.0.0
| 18120020180510233906 | COMPLETE
|
'--------+---------------+------+------+------------+----------------------+------------------'
2-
Check the path of this tfactl:
[root@<hosname> ~]#
which tfactl
/u01/app/12.1.0/grid/bin/tfactl
3- Use help to see all commands for tfactl and
check the add user command.
Usage :
/u01/app/12.1.0/grid/bin/tfactl <command> [options]
commands:diagcollect|collection|analyze|ips|run|start|stop|enable|disable|status|print|access|purge|directory|host|receiver|set|toolstatus|uninstall|diagnosetfa|syncnodes|setupmos|upload
For detailed help on each
command use:
/u01/app/12.1.0/grid/bin/tfactl
<command> -help
access -help
Add or Remove or List TFA
Users and Groups
Usage :
/u01/app/12.1.0/grid/bin/tfactl access <command> [options]
commands:lsusers|add|remove|block|unblock|enable|disable|reset|removeall
For detailed help on each
command use:
/u01/app/12.1.0/grid/bin/tfactl access
<command> -help
4- List
the current user:
tfactl>
access lsusers
.---------------------------------.
| TFA Users in <hosname1> |
+-----------+-----------+---------+
| User Name | User Type |
Status |
+-----------+-----------+---------+
| grid | USER | Allowed |
'-----------+-----------+---------'
.---------------------------------.
| TFA Users in <hostname2> |
+-----------+-----------+---------+
| User Name | User Type |
Status |
+-----------+-----------+---------+
| grid | USER | Allowed |
'-----------+-----------+---------'
5- Add
oracle user to the list:
tfactl> access add -user
oracle
Successfully added 'oracle'
to TFA Access list.
.---------------------------------.
| TFA Users in <hostname1> |
+-----------+-----------+---------+
| User Name | User Type |
Status |
+-----------+-----------+---------+
| grid | USER | Allowed |
| oracle | USER
| Allowed |
'-----------+-----------+---------'
.---------------------------------.
| TFA Users in <hostname2> |
+-----------+-----------+---------+
| User Name | User Type |
Status |
+-----------+-----------+---------+
| grid | USER | Allowed |
| oracle | USER
| Allowed |
'-----------+-----------+---------'
