首页 » ORACLE 9i-23c, 系统相关 » OS Watcher (OSW)系统性能监控软件

OS Watcher (OSW)系统性能监控软件

OS Watcher简称OSW(oswbb),用于收集并归档操作系统cpu,memery,disk io,network等相关信息的工具,是oracle提供的脚本工具集,全是shell编写,OSW内部是使用操作系统提供的基本命令来收集数据,给系统带来的额外负载可以安全忽略,收集策略是放在后台定期间隔一段时间自动收集,并可以设定数据保留时间,定期清理。

下载介质

这个工具包可以从Metalink下载。Metalink Note:301137.1, 当前最新为oswbb840版本, 在当前较新的ORACLE 19C RAC安装时,如果选择安装了 TFA 工具集,osw目前已是属于TFA一部分也可以独立安装, 查看当前系统是否启用OSW, 使用 ps -ef|grep osw 查看 oswbb进程是否存在就可以。

提供一个百度云盘地址
链接:https://pan.baidu.com/s/1nxHV07WQLTw7Y2Kl5FgxUg?pwd=ridc
提取码:ridc

OSW is certified to run on the following platforms:
1.AIX
2.Tru64
3.Solaris
4.HP-UX
5.Linux

安装osw

安装很方便,下载后就是一个压缩包,前期版就不到300K,当前也就5M左右,解压就可以使用

[root@oel7db1 ~]# md5sum oswbb840.tar
ccfe01232d1e28e28e5d3999ade773c2 oswbb840.tar
[root@oel7db1 ~]# ls -l oswbb840.tar
-rw-r--r-- 1 root root 5253120 Oct 1 18:21 oswbb840.tar


下面我开始在rhel linux上试验

[root@oel7db1 ~]# tar -xvf oswbb840.tar
oswbb/
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
...

[root@oel7db1 oswbb]# ll
total 476
drwxr-xr-x 2 oracle dba       6 Nov 20  2019 analysis
drwxr-xr-x 2 oracle dba       6 Nov 20  2019 archive
-rwxrwxrwx 1 oracle dba     546 Jul 15  2019 arpsub.sh
-rwxrwxrwx 1 oracle dba      67 Jul 15  2019 call_du.sh
-rwxrwxrwx 1 oracle dba      68 Jul 15  2019 call_sar.sh
-rwxrwxrwx 1 oracle dba      71 Jul 15  2019 call_uptime.sh
drwxrwxrwx 2 oracle dba       6 Nov 20  2019 data
drwxrwxrwx 4 oracle dba      76 Nov 20  2019 docs
-rwxrwxrwx 1 oracle dba     665 Jul 15  2019 Example_extras.txt
-rwxrwxrwx 1 oracle dba    1864 Jul 15  2019 Exampleprivate.net
-rwxrwxrwx 1 oracle dba    3990 Jul 15  2019 genprvnet.sh
drwxrwxrwx 2 oracle dba       6 Nov 20  2019 gif
-rwxrwxrwx 1 oracle dba     795 Jul 15  2019 ifconfigsub.sh
-rwxrwxrwx 1 oracle dba     743 Jul 15  2019 iosub.sh
drwxrwxrwx 2 oracle dba       6 Nov 20  2019 locks
-rwxrwxrwx 1 oracle dba    1507 Jul 15  2019 ltop.sh
-rwxrwxrwx 1 oracle dba     542 Jul 15  2019 mpsub.sh
-rwxrwxrwx 1 oracle dba     745 Jul 15  2019 nfssub.sh
-rwxrwxrwx 1 oracle dba    8035 Jul 15  2019 OSWatcherFM.sh
-rwxrwxrwx 1 oracle dba   55817 Nov 20  2019 OSWatcher.sh
-rw-r--r-- 1 oracle dba  289876 Nov 20  2019 oswbba.jar
-rwxrwxrwx 1 oracle dba     414 Jul 15  2019 oswib.sh
-rwxrwxrwx 1 oracle dba     579 Jul 15  2019 oswnet.sh
-rwxrwxrwx 1 oracle dba     825 Jul 15  2019 oswrds.sh
-rwxrwxrwx 1 oracle dba     524 Jul 15  2019 oswsub.sh
-rwxrwxrwx 1 oracle dba     561 Jul 15  2019 piddsub.sh
-rwxrwxrwx 1 oracle dba     565 Jul 15  2019 pidsub.sh
-rwxr-xr-x 1 root   root     40 Oct  1 18:24 private.net
-rwxrwxrwx 1 oracle dba    1481 Jul 15  2019 psmemsub.sh
-rwxrwxrwx 1 oracle dba     557 Jul 15  2019 sarsub.sh
drwxrwxrwx 7 oracle dba     126 Nov 20  2019 src
-rwxrwxrwx 1 oracle dba    2574 Jul 15  2019 startOSWbb.sh
-rwxrwxrwx 1 oracle dba     752 Jul 15  2019 stopOSWbb.sh
-rwxrwxrwx 1 oracle dba     819 Jul 15  2019 tar_up_full_archive.sh
-rwxrwxrwx 1 oracle dba    8234 Jul 15  2019 tar_up_partial_archive.sh
drwxr-xr-x 2 oracle dba       6 Nov 20  2019 tmp
-rwxrwxrwx 1 oracle dba     527 Jul 15  2019 topaix.sh
-rwxrwxrwx 1 oracle dba     414 Nov 14  2019 uncpr.bat
-rwxrwxrwx 1 oracle dba     545 Jul 15  2019 vmsub.sh
-rwxrwxrwx 1 oracle dba     571 Jul 15  2019 xensub.sh
-rwxrwxrwx 1 oracle dba    1486 Jul 15  2019 xtop.sh

— 确认所有.sh文件有x执行权限,如果没有 需要授权

[oracle@orazhang osw]$ chmod +x *.sh

对于RAC环境需要配置一下对interconnect使用的private的监控private.net文件, 确认操作系统有traceroute和ifconfig命令, 如果是19c自带TFA方式安装启用的osw不需要配置private.net ,已自动配置完,利用的是osw自带目录中的genprvnet.sh可以生成private.net,当然也可以自己vi 创建这个文件, 如果是RAC 环境,需要上传oswbb 到每个节点,手动执行

[oracle@orazhang osw]$sh  genprvnet.sh

生成当前目录上private.net文件,注意要用x执行权限,如果是vi 手动创建,记的

[oracle@orazhang osw]$ chmod +x private.net

vi 创建private.net的方式是从自带的Exampleprivate.net文件内容中,复制一段适合自己的操作系统平台的内容。如LINUX平台private.net最终内容如下

[oracle@orazhang osw]$ cat private.net
######################################################################
#Linux Example
######################################################################
echo "zzz ***"`date`
traceroute -r -F  192.68.1.xxx
traceroute -r -F  192.68.1.xxx
######################################################################
# DO NOT DELETE THE FOLLOWING LINE!!!!!!!!!!!!!!!!!!!!!
######################################################################
rm locks/lock.file

注意: 上面的traceroute 部分换成自己RAC 环境的实际的private 网络IP, 如可以从cat /etc/hosts中查找private的IP地址。每个实例1条,如4个实例为4条,所有实例的private.net内容一样,可以复制,也可以增加自己指定的探测ip, 如Dataguard。

启动与停止

启动运行./startOSW.sh,后可选3个参数

./startOSW.sh <ARG1> <ARG2> <ARG3>

ARG1:表示收集间隔时间,默认为30秒
ARG1:表示数据保留时间,默认为48小时
ARG3:gzip或不跟,加gzip表示用gzip去压缩收集到的数据
注意:首次运行时会在osw目录下自动 创建archive子目录,用于存放收集到的数据,都是以文件格式存放,间隔30秒采集一次并保留10小时,一般需要120M左右的空间。

调用前先要先确保安装sysstat

[oracle@orazhang osw]$ rpm -qa sysstat
sysstat-7.0.4-2.fc7

建议启动方式

[oracle@orazhang osw]$ sh startOSWbb.sh 3 72 gzip &

以3秒为间隔,保留最后72小时的数据,对于超过保留期限的数据,File Manager 会自动清理(File Manager 每隔一个小时调度一次),如果进程数较多如,如超过1万里 ps内容可能占空间较大,注意磁盘使用率,可以缩短保留时间如把72改为24.

[oracle@orazhang osw]$
Testing for discovery of OS Utilities...

VMSTAT found on your system.
IOSTAT found on your system.
MPSTAT found on your system.
NETSTAT found on your system.
TOP found on your system.

Discovery completed.

Starting OSWatcher V2.0.2  on Wed Sep 28 16:14:43 CST 2011
With SnapshotInterval = 3
With ArchiveInterval = 4

OSWatcher - Written by Carl Davis, Center of Expertise, Oracle Corporation

Starting Data Collection...

osw heartbeat:Wed Sep 28 16:14:43 CST 2011
osw heartbeat:Wed Sep 28 16:14:46 CST 2011
osw heartbeat:Wed Sep 28 16:14:49 CST 2011
...

启动后会一直监听,后台一直运行,关闭ssh窗口就可以。

停止OSW

[oracle@orazhang osw]$sh stopOSWbb.sh

分析工具

调用OSWg.jar,调用图形界面查看曲线图
[oracle@orazhang ~]$ export DISPLAY=192.168.3.140:0.0
[oracle@orazhang ~]$ ls
delete.sql Desktop firefox login.sql oraInventory osw rda rdesktop-1.7.0 record rmanfullbak.sh sql wxWidgets-2.9.1
[oracle@orazhang ~]$ cd osw

[oracle@orazhang osw]$ java -version
java version “1.4.2”
gij (GNU libgcj) version 4.1.2 20070626 (Red Hat 4.1.2-14)

Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

[oracle@orazhang osw]$ java -jar OSWg.jar -i /home/oracle/osw/archive

Starting OSWg V2.0.4
OSWatcher Graph Written by Oracle Center of Expertise
Copyright (c) 2007 by Oracle Corporation

Parsing Data. Please Wait…

Parsing file orazhang_iostat_09.28.11.1600.dat …
Parsing file orazhang_vmstat_09.28.11.1600.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 6 to Generate All CPU Gif Files
Enter 7 to Generate All Memory Gif Files
Enter 8 to Generate All Disk Gif Files

Enter L to Specify Alternate Location of Gif Directory
Enter T to Specify Different Time Scale
Enter D to Return to Default Time Scale
Enter R to Remove Currently Displayed Graphs
Enter Q to Quit Program

Please Select an Option:1
>>> Input Error: null

[oracle@orazhang osw]$ which java
/usr/bin/java
[oracle@orazhang osw]$ export PATH=/u01/app/oracle/product/10.2.0/db_1/jre/1.4.2/bin:$PATH
[oracle@orazhang osw]$ java -version
java version “1.4.2_08”
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_08-b03)
Java HotSpot(TM) Client VM (build 1.4.2_08-b03, mixed mode)
[oracle@orazhang osw]$ which java
/u01/app/oracle/product/10.2.0/db_1/jre/1.4.2/bin/java
[oracle@orazhang osw]$ java -jar OSWg.jar -i /home/oracle/osw/archive

Starting OSWg V2.0.4
OSWatcher Graph Written by Oracle Center of Expertise
Copyright (c) 2007 by Oracle Corporation

Parsing Data. Please Wait…

Parsing file orazhang_iostat_09.28.11.1600.dat …
Parsing file orazhang_vmstat_09.28.11.1600.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 6 to Generate All CPU Gif Files
Enter 7 to Generate All Memory Gif Files
Enter 8 to Generate All Disk Gif Files

Enter L to Specify Alternate Location of Gif Directory
Enter T to Specify Different Time Scale
Enter D to Return to Default Time Scale
Enter R to Remove Currently Displayed Graphs
Enter Q to Quit Program

Please Select an Option:1

可以看到图形了

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 6 to Generate All CPU Gif Files
Enter 7 to Generate All Memory Gif Files
Enter 8 to Generate All Disk Gif Files

Enter L to Specify Alternate Location of Gif Directory
Enter T to Specify Different Time Scale
Enter D to Return to Default Time Scale
Enter R to Remove Currently Displayed Graphs
Enter Q to Quit Program

Please Select an Option:2

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 6 to Generate All CPU Gif Files
Enter 7 to Generate All Memory Gif Files
Enter 8 to Generate All Disk Gif Files

Enter L to Specify Alternate Location of Gif Directory
Enter T to Specify Different Time Scale
Enter D to Return to Default Time Scale
Enter R to Remove Currently Displayed Graphs
Enter Q to Quit Program

Please Select an Option:q

note:

生成后在调用图形是一定要注意java的版本信息,GNU libgcj是有问题,用oracle自带的就可以10g自带1.4,11G j是java 5

打赏

,

对不起,这篇文章暂时关闭评论。