ORACLE OS WATCHER
What is oracle OS watcher?
Oracle OS watcher is collects and stores as 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 a data on a regular basis, invoking such UNIX utilities such as vmstat, netstat, iostat, top, etc.
By using of OSWbba analyzer to provide information on system slowdowns, system hangs and other performance problems, and also to graph data collected from iostat, netstat, and vmstat.
In General, OSWbb requires the java version of 1.4.2 or higher version in our environment.
OSwbb is particularly useful for RAC environment and also oracle grid infrastructure.
Where to download the OS watcher and execute it?
Step1:
We can download the Oracle OS watcher software from my oracle support website itself.
https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=301137.1:OSW_file.
Step 2:
Then, move or copy this file to directory where we need to run the oswbb software and un-tar the file.
[root@training dbhome_1]# tar -xvf oswbb840.taroswbb/
oswbb/uncpr.bat
oswbb/sarsub.sh
oswbb/psmemsub.sh
oswbb/stopOSWbb.sh
oswbb/analysis/
oswbb/piddsub.sh
oswbb/arpsub.sh
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/oswbba_README.txt
oswbb/docs/OSWatcherOverview_840.pdf
oswbb/Exampleprivate.net
oswbb/tmp/
oswbb/oswbba.jar
oswbb/oswib.sh
oswbb/ltop.sh
oswbb/archive/
oswbb/oswnet.sh
oswbb/call_uptime.sh
oswbb/OSWatcher.sh
oswbb/vmsub.sh
oswbb/pidsub.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/pro.htm
oswbb/src/oswbba_input.txt
oswbb/topaix.sh
oswbb/xensub.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@training dbhome_1]#Step 3:
After above step, we have to install ksh (koron shell) using yum install.
[root@training dbhome_1]# yum install kshLoaded plugins: langpacks, ulninfo
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
ol7_UEKR4 | 2.5 kB 00:00:00
ol7_latest | 2.7 kB 00:00:00
(1/4): ol7_latest/x86_64/updateinfo | 3.2 MB 00:00:06
(2/4): ol7_UEKR4/x86_64/updateinfo | 95 kB 00:00:08
(3/4): ol7_UEKR4/x86_64/primary_db | 11 MB 00:00:10
(4/4): ol7_latest/x86_64/primary_db | 35 MB 00:00:23
Package ksh-20120801-142.0.1.el7.x86_64 already installed and latest version
Nothing to do
Step 4:
Then, when we complete an un-tar(tar –xvf owsbb.tar) function, it will create the directory name of “oswbb”. In that directory has a shell script to execute the oswbb and .jar files are located there.
[root@training dbhome_1]# cd oswbb/ [root@training oswbb]# ls -lrttotal 476
-rwxrwxrwx. 1 oracle dba 1486 Jul 15 2019 xtop.sh
-rwxrwxrwx. 1 oracle dba 571 Jul 15 2019 xensub.sh
-rwxrwxrwx. 1 oracle dba 545 Jul 15 2019 vmsub.sh
-rwxrwxrwx. 1 oracle dba 527 Jul 15 2019 topaix.sh
-rwxrwxrwx. 1 oracle dba 819 Jul 15 2019 tar_up_full_archive.sh
-rwxrwxrwx. 1 oracle dba 752 Jul 15 2019 stopOSWbb.sh
-rwxrwxrwx. 1 oracle dba 2574 Jul 15 2019 startOSWbb.sh
-rwxrwxrwx. 1 oracle dba 557 Jul 15 2019 sarsub.sh
-rwxrwxrwx. 1 oracle dba 1481 Jul 15 2019 psmemsub.sh
-rwxrwxrwx. 1 oracle dba 565 Jul 15 2019 pidsub.sh
-rwxrwxrwx. 1 oracle dba 561 Jul 15 2019 piddsub.sh
-rwxrwxrwx. 1 oracle dba 524 Jul 15 2019 oswsub.sh
-rwxrwxrwx. 1 oracle dba 825 Jul 15 2019 oswrds.sh
-rwxrwxrwx. 1 oracle dba 579 Jul 15 2019 oswnet.sh
-rwxrwxrwx. 1 oracle dba 414 Jul 15 2019 oswib.sh
-rwxrwxrwx. 1 oracle dba 745 Jul 15 2019 nfssub.sh
-rwxrwxrwx. 1 oracle dba 542 Jul 15 2019 mpsub.sh
-rwxrwxrwx. 1 oracle dba 1507 Jul 15 2019 ltop.sh
-rwxrwxrwx. 1 oracle dba 743 Jul 15 2019 iosub.sh
-rwxrwxrwx. 1 oracle dba 795 Jul 15 2019 ifconfigsub.sh
-rwxrwxrwx. 1 oracle dba 3990 Jul 15 2019 genprvnet.sh
-rwxrwxrwx. 1 oracle dba 1864 Jul 15 2019 Exampleprivate.net
-rwxrwxrwx. 1 oracle dba 665 Jul 15 2019 Example_extras.txt
-rwxrwxrwx. 1 oracle dba 71 Jul 15 2019 call_uptime.sh
-rwxrwxrwx. 1 oracle dba 68 Jul 15 2019 call_sar.sh
-rwxrwxrwx. 1 oracle dba 67 Jul 15 2019 call_du.sh
-rwxrwxrwx. 1 oracle dba 546 Jul 15 2019 arpsub.sh
-rwxrwxrwx. 1 oracle dba 8035 Jul 15 2019 OSWatcherFM.sh
-rwxrwxrwx. 1 oracle dba 8234 Jul 15 2019 tar_up_partial_archive.sh
-rwxrwxrwx. 1 oracle dba 414 Nov 14 2019 uncpr.bat
drwxrwxrwx. 2 oracle dba 6 Nov 20 2019 data
drwxrwxrwx. 4 oracle dba 73 Nov 20 2019 docs
drwxrwxrwx. 2 oracle dba 6 Nov 20 2019 gif
drwxrwxrwx. 7 oracle dba 4096 Nov 20 2019 src
drwxr-xr-x. 2 oracle dba 6 Nov 20 2019 tmp
drwxrwxrwx. 2 oracle dba 6 Nov 20 2019 locks
-rw-r–r–. 1 oracle dba 289876 Nov 20 2019 oswbba.jar
drwxr-xr-x. 2 oracle dba 6 Nov 20 2019 archive
drwxr-xr-x. 2 oracle dba 6 Nov 20 2019 analysis
-rwxrwxrwx. 1 oracle dba 55817 Nov 20 2019 OSWatcher.sh
[root@training oswbb]#To execute or to start the oswbb software, we should run the startOSWbb.sh
[root@training oswbb]# sh startOSWbb.sh [root@training 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/oracle/product/19.0.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.
IP found on your system.
TOP found on your system.
PIDSTAT found on your system.
NFSIOSTAT 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 = 1
VCPUS/THREADS = 1
Discovery completed.
Starting OSWatcher v8.4.0 on Tue Jun 8 14:51:50 IST 2021
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)
Data is stored in directory: /u01/app/oracle/product/19.0.0/dbhome_1/oswbb/archive
Starting Data Collection…
oswbb heartbeat:Tue Jun 8 14:51:55 IST 2021
oswbb heartbeat:Tue Jun 8 14:52:26 IST 2021
oswbb heartbeat:Tue Jun 8 14:52:56 IST 2021
oswbb heartbeat:Tue Jun 8 14:53:26 IST 2021
oswbb heartbeat:Tue Jun 8 14:53:56 IST 2021
oswbb heartbeat:Tue Jun 8 14:54:27 IST 2021
oswbb heartbeat:Tue Jun 8 14:54:57 IST 2021
oswbb heartbeat:Tue Jun 8 14:55:27 IST 2021
oswbb heartbeat:Tue Jun 8 14:55:57 IST 2021
oswbb heartbeat:Tue Jun 8 14:56:28 IST 2021
oswbb heartbeat:Tue Jun 8 14:56:58 IST 2021
oswbb heartbeat:Tue Jun 8 14:57:28 IST 2021
^C
Step 5:
To stop the oswbb we should execute it stopOSWbb.sh.
[root@training oswbb]# sh stopOSWbb.sh [root@training oswbb]#
WHERE WE CAN GET THE ALL OUTPUT and HOW TO VIEW THAT
Step 6:
When the execution of os watcher it will create the directory called archive, we can get the all outputs in that archive directory, which we want to check the data, just navigate to that directory and view the file by using more command, because it is bigfile, so using of more command is best.
For eg: navigation to output:
$ cd $ORACLE_HOME/oswbb/archive
TO VIEW and ANALYZE THE OSWATCER REPORT.
For eg:
$ more file_name.dat
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. |