Oracle Trace File Analyzer helps you perform real-time health monitoring, fault detection & diagnosis via a single interface. It will securely consolidate all distributed diagnostic data. TFA can be installed on the database nodes either stand alone or cluster nodes. It’s continuously available and watching your logs for significant problems that may affect your service. If desired it can also automatically collect the relevant diagnostics, when it sees these problems.
From 12.2, TFA is included with RDBMS software and again this is optional when we run the root.sh script. You can skip this if you don’t want.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
[root@oratstbox01 12.2.0.1]# ./root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/product/db/12.2.0.1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Do you want to set up Oracle Trace File Analyzer (TFA) now ? yes|[no] : yes Installing Oracle Trace File Analyzer (TFA). Log File: /oracle/product/db/12.2.0.1/install/root_oratstbox01_2018-01-25_11-06-36-693715326.log Finished installing Oracle Trace File Analyzer (TFA) # Look at the log file for detailed information about TAF log directories etc.. .---------------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | +-------------+---------------+-------+-------+------------+----------------------+ | oratstbox01 | RUNNING | 78321 | 32028 | 12.2.1.0.0 | 12210020161122170355 | '-------------+---------------+-------+-------+------------+----------------------' Summary of TFA Installation: .--------------------------------------------------------. | oratstbox01 | +---------------------+----------------------------------+ | Parameter | Value | +---------------------+----------------------------------+ | Install location | /oracle/tfa/oratstbox01/tfa_home | | Repository location | /oracle/tfa/repository | | Repository usage | 0 MB out of 10240 MB | '---------------------+----------------------------------' TFA is successfully installed... # Or you can install it later. Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] : Oracle Trace File Analyzer (TFA - User Mode) is available at : /oracle/product/12.2.0.1/suptools/tfa/release/tfa_home/bin/tfactl OR Oracle Trace File Analyzer (TFA - Daemon Mode) can be installed by running this script : /oracle/product/12.2.0.1/suptools/tfa/release/tfa_home/install/roottfa.sh |
Command Interface
The tfactl tool functions as:
- Command line : $ tfactl <command>
- Shell interface: $ tfactl
- Menu interface: $ tfactl menu
Here are some examples:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
# Command [root@oratstbox01 bin]# cd /oracle/tfa/bin [root@oratstbox01 bin]# ./tfactl status .----------------------------------------------------------------------------------------------------. | Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status | +-------------+---------------+-------+-------+------------+----------------------+------------------+ | oratstbox01 | RUNNING | 78321 | 32028 | 12.2.1.0.0 | 12210020161122170355 | COMPLETE | '-------------+---------------+-------+-------+------------+----------------------+------------------' [root@oratstbox01 bin]# ./tfactl stop Stopping TFA from the Command Line TFA-00518 Oracle Trace File Analyzer (TFA) is not running (stopped) TFA Stopped Successfully . . . Successfully stopped TFA.. [root@oratstbox01 bin]# ./tfactl 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. # Shell [root@oratstbox01 bin]# ./tfactl tfactl> summary -help Output from host : oratstbox01 ------------------------------ Usage : /oracle/tfa/oratstbox01/tfa_home/bin/tfactl summary # Menu [root@oratstbox01 bin]# ./tfactl menu Trace File Analyzer Collector Menu System ========================================= TFA Main Menu The Oracle Trace File Analyzer Menu provides a simple interface to the TFA tools. Select one of the following categories: 1 Standard TFA all component Collections 2 Advanced TFA Collections 3 Oracle Exadata Database Machine: Collectors 4 Oracle ZDLRA: Collectors (B)ack (M)ain (E)xit Please enter your selection : E |
Oracle Trace File Analyzer uses a flood control mechanism. Repeated errors do not flood the system with automatic collections. Automatic collections are ON by default. To change automatic collections use:
1 2 |
[root@oratstbox01 bin]# ./tfactl set autodiagcollect=OFF Successfully set autodiagcollect=OFF |
Configure Email Notification
You can provide Oracle Trace File Analyzer with one or more comma separated email addresses to send notification of problems.
1 |
$ tfactl set notificationAddress=email@acompany.com |
Oracle Trace File Analyzer helps you keep mission-critical apps up and running.If something does go wrong, Oracle Trace File Analyzer helps you analyze and collect what you need, to fix it. Please read more about TFA from here.
Leave a Reply