Oracle Trace File Analyzer Tips And Tricks

TFA

Trace File Analyzer is new utility which can be installed on the database nodes either stand alone or cluster nodes.

In order to collect the diagnostics of 8 node for example, then we have to review alert log, listener logs whatever on all the nodes that become very lengthy procedure and also not easy to merge the information based on the all nodes.

Hence Oracle introduced TFA – Trace file analyzer and this made easy job for DBA’s, TFA utility or bundle can be downloaded from MOS.

TFACTL INSTALLATION:

 

[root@test18c ~]# cd /u01/app/oracle/tfa/bin/
[root@test18c bin]# ./tfactl
tfactl> orachk
Using Orachk : /u01/app/oracle/tfa/test18c/tfa_home/ext/orachk/orachk


Running orachk
----------------------------------------------------------
PATH : /u01/app/oracle/tfa/test18c/tfa_home/ext/orachk
VERSION : 18.3.0_20180808
COLLECTIONS DATA LOCATION : /u01/app/oracle/tfa/repository/suptools/test18c/orachk/root
----------------------------------------------------------

List of running databases

1. test18c
2. None of above

Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1]. 1
. .
. .

Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

. . . . . .
. . . . . . . . .
-------------------------------------------------------------------------------------------------------
Oracle Stack Status 
-------------------------------------------------------------------------------------------------------
Host Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name
-------------------------------------------------------------------------------------------------------
test18c No No Yes No No Yes test18c
-------------------------------------------------------------------------------------------------------


Copying plug-ins

. .
. . . . . .

*** Checking Best Practice Recommendations ( PASS / WARNING / FAIL ) ***


.

Collections and audit checks log file is
/u01/app/oracle/tfa/repository/suptools/test18c/orachk/root/orachk_test18c_test18c_111318_034400/log/orachk.log

============================================================
Node name - test18c
============================================================

Collecting - Database Parameters for test18c database
Collecting - Database Undocumented Parameters for test18c database
Collecting - RDBMS Feature Usage for test18c database
Collecting - CPU Information
Collecting - Disk I/O Scheduler on Linux
Collecting - DiskMount Information
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - OS Packages
Collecting - Operating system release information and kernel version
Collecting - Patches for RDBMS Home
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Collecting - Disk Information
Collecting - Linux Operating system health check using vmpscan.sh
Collecting - Root user limits
Collecting - Verify no database server kernel out of memory errors


Data collections completed. Checking best practices on test18c.
------------------------------------------------------------

CRITICAL => Bash is vulnerable to code injection (CVE-2014-6271)
WARNING => Linux swap configuration does not meet recommendation
INFO => Important Storage Minimum Requirements for Grid & Database Homes
WARNING => Non-AWR Space consumption is greater than or equal to 50% of total SYSAUX space. for test18c
INFO => Most recent ADR incidents for /u01/app/oracle/product/18.0.0/dbhome_1
INFO => Oracle GoldenGate failure prevention best practices
INFO => user_dump_dest has trace files older than 30 days for test18c
FAIL => Database parameter DB_BLOCK_CHECKSUM is not set to recommended value on test18c instance
FAIL => Database parameter DB_LOST_WRITE_PROTECT is not set to recommended value on test18c instance
WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for test18c
INFO => Operational Best Practices
INFO => Database Consolidation Best Practices
INFO => Computer failure prevention best practices
INFO => Data corruption prevention best practices
INFO => Logical corruption prevention best practices
INFO => Database/Cluster/Site failure prevention best practices
INFO => Client failover operational best practices
WARNING => Duplicate objects were found in the SYS and SYSTEM schemas for test18c
WARNING => Oracle clusterware is not being used
WARNING => RAC Application Cluster is not being used for database high availability on test18c instance
WARNING => DISK_ASYNCH_IO is NOT set to recommended value for test18c
FAIL => Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for test18c
FAIL => Flashback on PRIMARY is not configured for test18c
INFO => Database failure prevention best practices
WARNING => fast_start_mttr_target has NOT been changed from default on test18c instance
WARNING => Database Archivelog Mode should be set to ARCHIVELOG for test18c
FAIL => Primary database is not protected with Data Guard (standby database) for real-time data protection and availability for test18c
FAIL => Active Data Guard is not configured for test18c
INFO => Parallel Execution Health-Checks and Diagnostics Reports for test18c
INFO => Oracle recovery manager(rman) best practices
WARNING => Linux Disk I/O Scheduler should be configured to Deadline
WARNING => Consider investigating changes to the schema objects such as DDLs or new object creation for test18c
WARNING => Consider investigating the frequency of SGA resize operations and take corrective action for test18c
Best Practice checking completed. Checking recommended patches on test18c
--------------------------------------------------------------------------------
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/18.0.0/dbhome_1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
1 Recommended RDBMS patches for 180000 from /u01/app/oracle/product/18.0.0/dbhome_1 on test18c
--------------------------------------------------------------------------------
Patch# RDBMS ASM type Patch-Description 
--------------------------------------------------------------------------------
28090523 yes merge DATABASE RELEASE UPDATE 18.3.0.0.0
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
RDBMS homes patches summary report
--------------------------------------------------------------------------------
Total patches Applied on RDBMS Applied on ASM ORACLE_HOME
--------------------------------------------------------------------------------
1 1 0 /u01/app/oracle/product/18.0.0/dbhome_1
--------------------------------------------------------------------------------

------------------------------------------------------------
Detailed report (html) - /u01/app/oracle/tfa/repository/suptools/test18c/orachk/root/orachk_test18c_test18c_111318_034400/orachk_test18c_test18c_111318_034400.html

UPLOAD [if required] - /u01/app/oracle/tfa/repository/suptools/test18c/orachk/root/orachk_test18c_test18c_111318_034400.zip


tfactl>

 

Starting from 12.2 this bundle is included with RDBMS software and again this is optional when we run the root.sh script, still we can skip this if it’s not required.

we will see how to initiate the TFA when we run the root.sh of RDBMS.

If we crack the log file then we can see very much detailed information such as scanned trace directories, number of hosts and with the help preview.

 

 

tfactl> summary
LOGFILE LOCATION : /u01/app/oracle/tfa/repository/suptools/test18c/summary/root/20181113030332/log/summary_command_20181113030332_test18c_4674.log

Component Specific Summary collection :
- Collecting ACFS details ... Done.
- Collecting DATABASE details ... Done.
- Collecting PATCH details ... Done.
- Collecting LISTENER details ... Done.
- Collecting NETWORK details ... Done.
- Collecting OS details ... Done.
- Collecting TFA details ... Done.
- Collecting SUMMARY details ... Done.

Prepare Clusterwide Summary Overview ... 
tfactl>
tfactl>

Example of Collecting Diagnostic Data

We can access the list of commands using the “tfactl <command> -help“, in this example we will collect sample diagnostic data using TFA.

 

How to check whether TFA is running or not?

This is simple by grepping the word “tfa” from host level as

 

MENU:



 

Basic TFACTL commands include:

tfactl start: Starts the Oracle Trace File Analyzer daemon on the local node.

tfactl stop: Stops the Oracle Trace File Analyzer daemon on the local node.

tfactl enable: Enables automatic restart of the Oracle Trace File Analyzer daemon after a failure or system reboot.

tfactl disable: Stops any running Oracle Trace File Analyzer daemon and disables automatic restart.

tfactl uninstall: Removes Oracle Trace File Analyzer from the local node.

tfactl syncnodes: Generates and copies Oracle Trace File Analyzer certificates from one Oracle Trace File Analyzer node to other nodes.

tfactl restrictprotocol: Restricts the use of certain protocols.

tfactl status: Checks the status of an Oracle Trace File Analyzer process. The output is same as tfactl print status.

tfactl diagnosetfa: Use the tfactl diagnosa tfa command to collect Oracle Trace File Analyzer diagnostic data from the local node to help diagnose issues with Oracle Trace File Analyzer.

tfactl host: Use the tfactl host command to add hosts to, or remove hosts from the Oracle Trace File Analyzer configuration.

tfactl set: Use the tfactl set command to enable or disable, or modify various Oracle Trace File Analyzer functions.

tfactl access: Use the tfactl access command to allow non-root users to have controlled access to Oracle Trace File Analyzer and to run diagnostic collections.

OSWatcher: http://www.oracledbwr.com/tuning/analyze-oracle-server-diagnostic-information-using-oswatcher-tool/

OraChk : http://www.oracledbwr.com/tuning/health-checks-for-the-oracle-stack-using-orachk/

 

Catch Me On:- Hariprasath Rajaram

LinkedIn:       https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:       https://www.facebook.com/HariPrasathdba
Facebook Group: https://www.facebook.com/groups/894402327369506/
Facebook Page:  https://www.facebook.com/dbahariprasath/?
Twitter:        https://twitter.com/hariprasathdba

Analyze Oracle Server Diagnostic Information Using OSWatcher Tool

OSWatcher:

Oracle OSWatcher Black Box (OSWbb) collects and archives operating system and network metrics that you can use to diagnose performance issues.

OSWbb operates as a set of background processes on the server and gathers data on a regular basis, invoking such Unix utilities as vmstat, netstat, iostat, and top.

OSWatcher includes a File Manager process that will run once per hour to clean up any data files older than the retention period.

The collection interval and retention period can be changed with the first two parameters, respectively, to the shell script that starts OSWatcher.

OSWbb is particularly useful for Oracle RAC (Real Application Clusters) and Oracle Grid Infrastructure configurations.

The RAC-DDT (Diagnostic Data Tool) script file includes OSWbb, but does not install it by default.

Installing OSWbb

To install OSWbb:

[root@ram db_1]# tar -xvf oswbb812.tar 
oswbb/
oswbb/sarsub.sh
oswbb/psmemsub.sh
oswbb/stopOSWbb.sh
oswbb/analysis/
oswbb/docs/
oswbb/docs/OSWatcher/
oswbb/docs/OSWatcher/oswbb_README.txt
oswbb/docs/OSWatcher/RAC_Traceroute_Automation_Readme.txt
oswbb/docs/OSWatcher/OSWatcherUserGuide.html
oswbb/docs/The_Analyzer/
oswbb/docs/The_Analyzer/AnalyzerUserGuide.html
oswbb/docs/The_Analyzer/AnalyzerWalkThrough.pdf
oswbb/docs/The_Analyzer/oswbba_README.txt
oswbb/docs/OSWatcherOverview090517.pdf
oswbb/Exampleprivate.net
oswbb/OSWatcher.sh~
oswbb/tmp/
oswbb/oswbba.jar
oswbb/oswib.sh
oswbb/ltop.sh
oswbb/oswnet.sh
oswbb/call_uptime.sh
oswbb/OSWatcher.sh
oswbb/vmsub.sh
oswbb/src/
oswbb/src/js/
oswbb/src/js/bootstrap.js
oswbb/src/js/modernizr.js
oswbb/src/js/jquery-2.1.4.min.js
oswbb/src/js/THIRDPARTYLICENSE.txt
oswbb/src/js/jquery.lightbox.js
oswbb/src/js/tabs.js
oswbb/src/js/scripts.js
oswbb/src/js/templatemo_custom.js
oswbb/src/Thumbs.db
oswbb/src/fonts/
oswbb/src/fonts/FontAwesome.otf
oswbb/src/fonts/fontawesome-webfont.woff
oswbb/src/fonts/fontawesome-webfont.woff2
oswbb/src/fonts/fontawesome-webfont.eot
oswbb/src/fonts/fontawesome-webfont.ttf
oswbb/src/fonts/fontawesome-webfont.svg
oswbb/src/META-INF/
oswbb/src/META-INF/application-client.xml
oswbb/src/images/
oswbb/src/images/Thumbnail_Placeholder.png
oswbb/src/images/next.png
oswbb/src/images/bx_loader.gif
oswbb/src/images/close.png
oswbb/src/images/loading.gif
oswbb/src/images/previous.png
oswbb/src/css/
oswbb/src/css/templatemo_misc.css
oswbb/src/css/bootstrap.min.css
oswbb/src/css/style.css
oswbb/src/css/font-awesome.min.css
oswbb/src/css/templatemo_style.css
oswbb/src/css/animate.css
oswbb/src/oswbba_input.txt
oswbb/topaix.sh
oswbb/iosub.sh
oswbb/oswsub.sh
oswbb/nfssub.sh
oswbb/xtop.sh
oswbb/genprvnet.sh
oswbb/oswrds.sh
oswbb/call_sar.sh
oswbb/call_du.sh
oswbb/ifconfigsub.sh
oswbb/mpsub.sh
oswbb/Example_extras.txt
oswbb/locks/
oswbb/OSWatcherFM.sh
oswbb/tar_up_partial_archive.sh
oswbb/data/
oswbb/tar_up_full_archive.sh
oswbb/gif/
oswbb/startOSWbb.sh
[root@ram db_1]#
  •  If the ksh package is not already installed on your system, use yum to install it.
[root@ram db_1]# yum install ksh
Loaded plugins: refresh-packagekit, security
Setting up Install Process
Trying other mirror.
Package ksh-20120801-37.el6_9.x86_64 already installed and latest version
Nothing to do

[root@ram db_1]#[root@bash oswbb]# ls -lrth
total 544K
-rwxr-xr-x. 1 2052 8500  524 Oct  7  2013 oswsub.sh
-rwxr-xr-x. 1 2052 8500  825 Oct  7  2013 oswrds.sh
-rwxr-xr-x. 1 2052 8500  414 Oct  7  2013 oswib.sh
-rwxr-xr-x. 1 2052 8500  740 Oct  7  2013 nfssub.sh
-rwxr-xr-x. 1 2052 8500  542 Oct  7  2013 mpsub.sh
-rwxr-xr-x. 1 2052 8500  743 Oct  7  2013 iosub.sh
-rwxr-xr-x. 1 2052 8500 1.9K Oct  7  2013 Exampleprivate.net
-rwxr-xr-x. 1 2052 8500   68 Oct  7  2013 call_sar.sh
-rwxr-xr-x. 1 2052 8500   71 Jan  7  2014 call_uptime.sh
-rwxr-xr-x. 1 2052 8500  435 Jan  8  2014 oswnet.sh
-rwxr-xr-x. 1 2052 8500 1.5K Jan  8  2014 ltop.sh
-rwxr-xr-x. 1 2052 8500   67 Jan 15  2014 call_du.sh
-rwxr-xr-x. 1 2052 8500  772 May  8  2014 ifconfigsub.sh
-rwxr-xr-x. 1 2052 8500  545 Feb 23  2015 vmsub.sh
-rwxr-xr-x. 1 2052 8500 2.6K Feb 26  2015 startOSWbb.sh
-rwxr-xr-x. 1 2052 8500 1.5K Feb 26  2015 xtop.sh
-rwxr-xr-x. 1 2052 8500 5.3K Feb  7  2017 tar_up_partial_archive.sh
-rwxr-xr-x. 1 2052 8500  834 Feb  7  2017 tar_up_full_archive.sh
-rwxr-xr-x. 1 2052 8500  665 Feb  7  2017 Example_extras.txt
-rwxr-xr-x. 1 2052 8500  527 Feb  8  2017 topaix.sh
-rwxr-xr-x. 1 2052 8500 3.9K Apr 18  2017 genprvnet.sh
drwx------. 2 2052 8500 4.0K May  3  2017 data
-rwxr-xr-x. 1 2052 8500  557 Jul 12  2017 sarsub.sh
-rwxr-xr-x. 1 2052 8500 6.7K Jul 12  2017 OSWatcherFM.sh
-rwxr-xr-x. 1 2052 8500  751 Aug 15  2017 stopOSWbb.sh
-rw-r--r--. 1 2052 8500  47K Aug 15  2017 OSWatcher.sh~
-rwxr-xr-x. 1 2052 8500 1.5K Aug 25  2017 psmemsub.sh
drwx------. 4 2052 8500 4.0K Sep  5  2017 docs
drwx------. 2 2052 8500 4.0K Sep  6  2017 gif
drwx------. 7 2052 8500 4.0K Sep  6  2017 src
-rwxr-xr-x. 1 2052 8500  47K Dec 13  2017 OSWatcher.sh
-rw-r--r--. 1 2052 8500 310K Dec 13  2017 oswbba.jar
drwxr-xr-x. 2 2052 8500 4.0K Dec 13  2017 tmp
drwxr-xr-x. 2 2052 8500 4.0K Dec 13  2017 locks
drwxr-xr-x. 2 2052 8500 4.0K Dec 13  2017 analysis

To start OSWbb, run the startOSWbb.sh script from the oswbb directory.

[root@bash oswbb]# ./startOSWbb.sh 
[root@bash oswbb]# 
Info...You did not enter a value for snapshotInterval.
Info...Using default value = 30
Info...You did not enter a value for archiveInterval.
Info...Using default value = 48
Setting the archive log directory to/u01/app/irfan/product/12.2.0/dbhome_1/oswbb/archive

Testing for discovery of OS Utilities...
VMSTAT found on your system.
IOSTAT found on your system.
MPSTAT found on your system.
IFCONFIG found on your system.
NETSTAT found on your system.
TOP found on your system.
TRACEROUTE found on your system.

Discovery of CPU CORE COUNT
CPU CORE COUNT will be used by oswbba to automatically look for cpu problems

CPU CORE COUNT = 2
VCPUS/THREADS = 2

Discovery completed.

Starting OSWatcher v8.1.2  on Sat Oct 27 01:41:22 IST 2018
With SnapshotInterval = 30
With ArchiveInterval = 48

OSWatcher - Written by Carl Davis, Center of Expertise,
Oracle Corporation
For questions on install/usage please go to MOS (Note:301137.1)
If you need further assistance or have comments or enhancement
requests you can email me Carl.Davis@Oracle.com

Data is stored in directory: /u01/app/irfan/product/12.2.0/dbhome_1/oswbb/archive

Starting Data Collection...

oswbb heartbeat:Sat Oct 27 01:41:27 IST 2018
oswbb heartbeat:Sat Oct 27 01:41:57 IST 2018
oswbb heartbeat:Sat Oct 27 01:42:27 IST 2018
oswbb heartbeat:Sat Oct 27 01:42:57 IST 2018
^C
[root@bash oswbb]# ./stopOSWbb.sh 
[root@bash oswbb]#

To stop OSWbb permanently, run the stopOSWbb.sh script from the oswbb directory.

To View The Collected Data

Collected data will be stored under archive directory, it is created when OSWbb is started for the first time. OSWbb stores data in hourly archive files named system_name_utility_name_timestamp.dat, and each entry in a file is preceded by the characters *** and a timestamp.

To check any data, just navigate to corresponding directory and view the corresponding file. For testing purpose, we printed vmstat file output.

OSWbb collects data in the following directories under the oswbb/archive directory:

Directory Description
oswiostat Contains output from the iostat utility.
oswmeminfo Contains a listing of the contents of /proc/meminfo.
oswmpstat Contains output from the mpstat utility.
oswnetstat Contains output from the netstat utility.
oswprvtnet If you have enable private network tracing for RAC, contains information about the status of the private networks.
oswps Contains output from the ps utility.
oswslabinfo Contains a listing of the contents of /proc/slabinfo.
oswtop Contains output from the top utility.
oswvmstat Contains output from the vmstat utility.

 

 

[root@bash tfa]# ls -lrth
total 266M
-rwxrwxr-x. 1 irfan irfan 266M Oct 27 00:43 TFA-LINUX_v18.3.3.zip
[root@bash tfa]# unzip TFA-LINUX_v18.3.3.zip 
Archive: TFA-LINUX_v18.3.3.zip
inflating: README.txt 
inflating: installTFA-LINUX 
[root@bash tfa]# ls -lrth
total 532M
-rwxr-xr-x. 1 root root 267M Oct 5 23:39 installTFA-LINUX
-rw-r--r--. 1 root root 1.5K Oct 5 23:41 README.txt
-rwxrwxr-x. 1 irfan irfan 266M Oct 27 00:43 TFA-LINUX_v18.3.3.zip
[root@bash tfa]# ./installTFA-LINUX 
TFA Installation Log will be written to File : /tmp/tfa_install_6496_2018_10_27-00_49_26.log

Starting TFA installation

TFA Version: 183300 Build Date: 201810050542

Enter a location for installing TFA (/tfa will be appended if not supplied) [/u01/app/irfan/product/12.2.0/dbhome_1/tfa]:
/u01/app/irfan/product/12.2.0/dbhome_1/tfa/

Running Auto Setup for TFA as user root...

Would you like to do a [L]ocal only or [C]lusterwide installation ? [L|l|C|c] [C] : L
Installing TFA now...

Discovering Nodes and Oracle resources

Starting Discovery...


No Grid Infrastructure Discovered on this system . . . . .

bash
Searching for running databases...
1. IRFAN


Searching out ORACLE_HOME for selected databases...


Getting Oracle Inventory...

ORACLE INVENTORY: /u01/app/oraInventory


Discovery Complete...

TFA Will be Installed on bash...

TFA will scan the following Directories
++++++++++++++++++++++++++++++++++++++++++++

.-----------------------------------------------------------------.
| bash |
+------------------------------------------------------+----------+
| Trace Directory | Resource |
+------------------------------------------------------+----------+
| /u01/app/irfan/cfgtoollogs | CFGTOOLS |
| /u01/app/irfan/diag/rdbms/clone/CLONE/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/clone/CLONE/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/clone/clone/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/clone/clone/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/crcc_pitr_irfan/Crcc/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/crcc_pitr_irfan/Crcc/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/iobh_pitr_irfan/ioBh/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/iobh_pitr_irfan/ioBh/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/irfan/IRFAN/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/irfan/IRFAN/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/ivee_pitr_irfan/ivEE/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/ivee_pitr_irfan/ivEE/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/macaw/IRFAN/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/macaw/IRFAN/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/nrsd_pitr_irfan/nrsd/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/nrsd_pitr_irfan/nrsd/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/orcl/orcl/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/orcl/orcl/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/osiz_pitr_irfan/osiz/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/osiz_pitr_irfan/osiz/trace | RDBMS |
| /u01/app/irfan/diag/rdbms/wfha_pitr_irfan/wfhA/cdump | RDBMS |
| /u01/app/irfan/diag/rdbms/wfha_pitr_irfan/wfhA/trace | RDBMS |
| /u01/app/irfan/diag/tnslsnr | TNS |
| /u01/app/irfan/product/12.2.0/dbhome_1/cfgtoollogs | CFGTOOLS |
| /u01/app/irfan/product/12.2.0/dbhome_1/install | INSTALL |
| /u01/app/irfan/product/12.2.0/dbhome_1/rdbms/log | RDBMS |
| /u01/app/irfan/product/12.2.0/dbhome_2/cfgtoollogs | CFGTOOLS |
| /u01/app/irfan/product/12.2.0/dbhome_2/install | INSTALL |
| /u01/app/oraInventory/ContentsXML | INSTALL |
| /u01/app/oraInventory/logs | INSTALL |
'------------------------------------------------------+----------'


Installing TFA on bash:
HOST: bash TFA_HOME: /u01/app/irfan/product/12.2.0/dbhome_1/tfa/bash/tfa_home

.-------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID |
+------+---------------+------+-------+------------+----------------------+
| bash | RUNNING | 7102 | 55356 | 18.3.3.0.0 | 18330020181005054218 |
'------+---------------+------+-------+------------+----------------------'

Running Inventory in All Nodes...

Enabling Access for Non-root Users on bash...
ERROR: /u01/app/irfan/product/12.2.0/dbhome_1/tfa/bash/tfa_home/internal/cached_kv.out does not exists

Adding default users to TFA Access list...

Summary of TFA Installation:
.--------------------------------------------------------------------------------.
| bash |
+---------------------+----------------------------------------------------------+
| Parameter | Value |
+---------------------+----------------------------------------------------------+
| Install location | /u01/app/irfan/product/12.2.0/dbhome_1/tfa/bash/tfa_home |
| Repository location | /u01/app/irfan/product/12.2.0/dbhome_1/tfa/repository |
| Repository usage | 0 MB out of 4876 MB |
'---------------------+----------------------------------------------------------'

TFA is successfully installed...

Usage : /u01/app/irfan/product/12.2.0/dbhome_1/tfa/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|availability|rest|events|search|changes|isa
For detailed help on each command use:
/u01/app/irfan/product/12.2.0/dbhome_1/tfa/bin/tfactl <command> -help





 

 

 

[irfan@bash bin]$ tfactl print version
TFA Version : 18.3.3.0.0



[irfan@bash bin]$ tfactl toolstatus

.------------------------------------------------------------------.
| TOOLS STATUS - HOST : bash |
+----------------------+--------------+--------------+-------------+
| Tool Type | Tool | Version | Status |
+----------------------+--------------+--------------+-------------+
| Development Tools | orachk | 12.2.0.1.3 | DEPLOYED |
| | oratop | 14.1.2 | DEPLOYED |
+----------------------+--------------+--------------+-------------+
| Support Tools Bundle | darda | 2.10.0.R6036 | DEPLOYED |
| | oswbb | 8.1.2 | RUNNING |
| | prw | 12.1.13.11.4 | NOT RUNNING |
+----------------------+--------------+--------------+-------------+
| TFA Utilities | alertsummary | 12.2.1.1.0 | DEPLOYED |
| | calog | 12.2.0.1.0 | DEPLOYED |
| | dbcheck | 18.3.0.0.0 | DEPLOYED |
| | dbglevel | 12.2.1.1.0 | DEPLOYED |
| | grep | 12.2.1.1.0 | DEPLOYED |
| | history | 12.2.1.1.0 | DEPLOYED |
| | ls | 12.2.1.1.0 | DEPLOYED |
| | managelogs | 12.2.1.1.0 | DEPLOYED |
| | menu | 12.2.1.1.0 | DEPLOYED |
| | param | 12.2.1.1.0 | DEPLOYED |
| | ps | 12.2.1.1.0 | DEPLOYED |
| | pstack | 12.2.1.1.0 | DEPLOYED |
| | summary | 12.2.1.1.0 | DEPLOYED |
| | tail | 12.2.1.1.0 | DEPLOYED |
| | triage | 12.2.1.1.0 | DEPLOYED |
| | vi | 12.2.1.1.0 | DEPLOYED |
'----------------------+--------------+--------------+-------------'

Note :-
DEPLOYED : Installed and Available - To be configured or run interactively.
NOT RUNNING : Configured and Available - Currently turned off interactively.
RUNNING : Configured and Available.

 

Invoking OSWBB

[irfan@bash bin]$ tfactl oswbb

Starting OSW Analyzer V8.1.2
OSWatcher Analyzer Written by Oracle Center of Expertise
Copyright (c) 2017 by Oracle Corporation

Parsing Data. Please Wait...

Scanning file headers for version and platform info...

Parsing file bash.localhost.com_iostat_18.10.27.0000.dat ...
Parsing file bash.localhost.com_iostat_18.10.27.0100.dat ...
This directory already exists. Rewriting...

Parsing file bash.localhost.com_vmstat_18.10.27.0000.dat ...
Parsing file bash.localhost.com_vmstat_18.10.27.0100.dat ...


Parsing file bash.localhost.com_netstat_18.10.27.0000.dat ...
Parsing file bash.localhost.com_netstat_18.10.27.0100.dat ...

Parsing file bash.localhost.com_top_18.10.27.0000.dat ...
Parsing file bash.localhost.com_top_18.10.27.0100.dat ...

Parsing file bash.localhost.com_ps_18.10.27.0000.dat ...
Parsing file bash.localhost.com_ps_18.10.27.0100.dat ...


Parsing Completed.


Enter 1 to Display CPU Process Queue Graphs
Enter 2 to Display CPU Utilization Graphs
Enter 3 to Display CPU Other Graphs
Enter 4 to Display Memory Graphs
Enter 5 to Display Disk IO Graphs

Enter GC to Generate All CPU Gif Files
Enter GM to Generate All Memory Gif Files
Enter GD to Generate All Disk Gif Files
Enter GN to Generate All Network Gif Files

Enter L to Specify Alternate Location of Gif Directory
Enter Z to Zoom Graph Time Scale (Does not change analysis dataset)
Enter B to Returns to Baseline Graph Time Scale (Does not change analysis dataset)
Enter R to Remove Currently Displayed Graphs

Enter X to Export Parsed Data to Flat File
Enter S to Analyze Subset of Data(Changes analysis dataset including graph time scale)
Enter A to Analyze Data
Enter D to Generate DashBoard

Enter Q to Quit Program

Please Select an Option:D
Enter a unique analysis/dashBoard directory name or enter <CR> to accept default name:<CR>

A new analysis file analysis/<CR>/analysis.txt has been created.

Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Run_Queue.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Run_Adjusted_Queue.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Block_Queue.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_HB.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_PS_Processes.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Cpu_Idle.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Cpu_System.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Cpu_User.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Cpu_Wa.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Cpu_Interrupts.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Context_Switches.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Memory_Swap.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Memory_Free.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Memory_Page_In_Rate.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Memory_Page_Out_Rate.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Cpu_Wa.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_Block_Queue.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_IO_ST.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_IO_AW.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_IO_PB.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_IO_RPS.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_IO_WPS.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_OS_IO_TPS.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_lo_rx_ok.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_lo_rx_err.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_lo_rx_drp.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_lo_rx_ovr.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_lo_tx_ok.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_lo_tx_err.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_lo_tx_drp.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_lo_tx_ovr.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_eth0_rx_ok.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_eth0_rx_err.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_eth0_rx_drp.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_eth0_rx_ovr.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_eth0_tx_ok.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_eth0_tx_err.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_eth0_tx_drp.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_eth0_tx_ovr.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0_rx_ok.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0_rx_err.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0_rx_drp.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0_rx_ovr.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0_tx_ok.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0_tx_err.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0_tx_drp.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0_tx_ovr.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0-nic_rx_ok.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0-nic_rx_err.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0-nic_rx_drp.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0-nic_rx_ovr.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0-nic_tx_ok.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0-nic_tx_err.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0-nic_tx_drp.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_link_virbr0-nic_tx_ovr.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_ip_requests_sent_out.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_ip_total_packets_received.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_ip_bad_header_checksum.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_ip_fragments_dropped.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_ip_fragments_created.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_ip_fragments_received.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_ip_fragments_dropped_after.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_ip_fragments_warn1.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_ip_fragments_warn2.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_udp_datagrams_in.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_udp_datagrams_out.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_udp_dropped.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_udp_broadcast_dropped.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_udp_socket_overflows.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_udp_bad_header_checksums.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_tcp_in_segs.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_tcp_out_segs.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_tcp_retrans_segs.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_tcp_conn_resets_received_segs.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_tcp_resets_sent.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_tcp_failed_conn_attempts.jpg
Generating file analysis/<CR>/dashboard/generated_files/OSWg_tcp_retran_error_rate.jpg

Enter 1 to Display CPU Process Queue Graphs
Enter 2 to Display CPU Utilization Graphs
Enter 3 to Display CPU Other Graphs
Enter 4 to Display Memory Graphs
Enter 5 to Display Disk IO Graphs

Enter GC to Generate All CPU Gif Files
Enter GM to Generate All Memory Gif Files
Enter GD to Generate All Disk Gif Files
Enter GN to Generate All Network Gif Files

Enter L to Specify Alternate Location of Gif Directory
Enter Z to Zoom Graph Time Scale (Does not change analysis dataset)
Enter B to Returns to Baseline Graph Time Scale (Does not change analysis dataset)
Enter R to Remove Currently Displayed Graphs

Enter X to Export Parsed Data to Flat File
Enter S to Analyze Subset of Data(Changes analysis dataset including graph time scale)
Enter A to Analyze Data
Enter D to Generate DashBoard

Enter Q to Quit Program

Please Select an Option:

Creating the dashboard

If you choose option “D” oswbb will go ahead and create a dashboard.

the result is stored in

$ORACLE_BASE/tfa/repository/suptools/$(host)/oswbb/oracle/oswbb/analysis

[root@bash oswbb]# ls -lrth
total 560K
-rwxr-xr-x. 1 irfan irfan 47K Oct 27 00:52 OSWatcher.sh
-rwxr-xr-x. 1 irfan irfan 545 Oct 27 00:52 vmsub.sh
drwxr-xr-x. 7 irfan irfan 4.0K Oct 27 00:52 src
-rwxr-xr-x. 1 irfan irfan 740 Oct 27 00:52 nfssub.sh
-rwxr-xr-x. 1 irfan irfan 1.5K Oct 27 00:52 ltop.sh
-rwxr-xr-x. 1 irfan irfan 71 Oct 27 00:52 call_uptime.sh
-rwxr-xr-x. 1 irfan irfan 1.5K Oct 27 00:52 xtop.sh
-rwxr-xr-x. 1 irfan irfan 529 Oct 27 00:52 topother.sh
-rwxr-xr-x. 1 irfan irfan 2.6K Oct 27 00:52 startOSWbb.sh
-rwxr-xr-x. 1 irfan irfan 557 Oct 27 00:52 sarsub.sh
-rwxr-xr-x. 1 irfan irfan 524 Oct 27 00:52 oswsub.sh
-rwxr-xr-x. 1 irfan irfan 825 Oct 27 00:52 oswrds.sh
-rwxr-xr-x. 1 irfan irfan 435 Oct 27 00:52 oswnet.sh
-rwxr-xr-x. 1 irfan irfan 414 Oct 27 00:52 oswib.sh
-rwxr-xr-x. 1 irfan irfan 20K Oct 27 00:52 oswbb.pm
-rwxr-xr-x. 1 irfan irfan 542 Oct 27 00:52 mpsub.sh
-rwxr-xr-x. 1 irfan irfan 772 Oct 27 00:52 ifconfigsub.sh
-rwxr-xr-x. 1 irfan irfan 3.9K Oct 27 00:52 genprvnet.sh
-rwxr-xr-x. 1 irfan irfan 1.9K Oct 27 00:52 Exampleprivate.net
-rwxr-xr-x. 1 irfan irfan 665 Oct 27 00:52 Example_extras.txt
-rwxr-xr-x. 1 irfan irfan 67 Oct 27 00:52 call_du.sh
-rwxr-xr-x. 1 irfan irfan 5.3K Oct 27 00:52 tar_up_partial_archive.sh
-rwxr-xr-x. 1 irfan irfan 751 Oct 27 00:52 stopOSWbb.sh
-rwxr-xr-x. 1 irfan irfan 1.5K Oct 27 00:52 psmemsub.sh
-rwxr-xr-x. 1 irfan irfan 310K Oct 27 00:52 oswbba.jar
-rwxr-xr-x. 1 irfan irfan 47K Oct 27 00:52 OSWatcher.sh~
-rwxr-xr-x. 1 irfan irfan 743 Oct 27 00:52 iosub.sh
drwxr-xr-x. 2 irfan irfan 4.0K Oct 27 00:52 data
-rwxr-xr-x. 1 irfan irfan 834 Oct 27 00:52 tar_up_full_archive.sh
-rwxr-xr-x. 1 irfan irfan 6.7K Oct 27 00:52 OSWatcherFM.sh
drwxr-xr-x. 2 irfan irfan 4.0K Oct 27 00:52 gif
-rwxr-xr-x. 1 irfan irfan 68 Oct 27 00:52 call_sar.sh
drwxr-xr-x. 3 irfan irfan 4.0K Oct 27 01:53 analysis
drwxr-xr-x. 2 irfan irfan 4.0K Oct 27 02:02 tmp
drwxr-xr-x. 2 irfan irfan 4.0K Oct 27 02:02 locks
[root@bash oswbb]# pwd
/u01/app/irfan/product/12.2.0/dbhome_1/tfa/repository/suptools/bash/oswbb/irfan/oswbb
[root@bash oswbb]# cd analysis/
[root@bash analysis]# ls -lrth
total 4.0K
drwxrwxr-x. 3 irfan irfan 4.0K Oct 27 01:53 <CR>

[root@bash analysis]# cd \<CR\>

[root@bash <CR>]# ls -lrth
total 316K
-rw-rw-r--. 1 irfan irfan 312K Oct 27 01:53 analysis.txt
drwxrwxr-x. 7 irfan irfan 4.0K Oct 27 01:53 dashboard
[root@bash <CR>]# cd dashboard/
[root@bash dashboard]# ls -lrth
total 76K
drwxr-xr-x. 2 irfan irfan 4.0K Oct 27 01:53 js
drwxr-xr-x. 2 irfan irfan 4.0K Oct 27 01:53 css
drwxr-xr-x. 2 irfan irfan 4.0K Oct 27 01:53 images
drwxr-xr-x. 2 irfan irfan 4.0K Oct 27 01:53 fonts
drwxrwxr-x. 2 irfan irfan 4.0K Oct 27 01:53 generated_files
-rw-rw-r--. 1 irfan irfan 54K Oct 27 01:53 index.html


[root@bash dashboard]# cp index.html /home/irfan/Desktop/

The HTML output

 

 

 

 

 

 

Catch Me On:- Hariprasath Rajaram 

Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/ Facebook:https://www.facebook.com/HariPrasathdba FBGroup:https://www.facebook.com/groups/894402327369506/ FBPage: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba