ANBOB™

OSW工具不用多说oracle数据库环境建议采集OS系统数据的脚本集， 采集的数据可以拿到其它机器，如WINDOWS上分析输出图形， 在ORACLE 12c后 AHF自动健康框架中已自带， 同时还有oracheck等，当troubleshooting时使用tfactl 可以一并收集相对全面的日志数据，目录比较深,如收集node: anbob2节点:

…\collection_Tue_Jan_11_17_34_19_CST_2022_node_anbob2\anbob2.tfa_Tue_Jan_11_17_34_19_CST_2022.zip\anbob2\oracle\app\grid\oracle.ahf\data\repository\suptools\anbob2\oswbb\grid\archive

几年前记录过2篇OSW，不做过多介绍，这里简单记录一下在Windows上使用oswbba.jar分析时的一些小问题。

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

Fixed OSWatcher v7.3.3 some problems on HPUX ia 11-31 platform

1, archive 路径不能含空格

C:\Users\zhang>java -jar “E:\google drive\Oracle\Oracle tool\oswbb840\oswbb\oswbba.jar” -i “C:\Users\zhang\Desktop\0111 orcl crash\oswbb\grid\archive”

ERROR. oswbba can not find any vmstat files in you archive location.
Either you are pointing to an invalid directory location or your archive does not contain vmstat files.
Check that C:\Users\zhang\Desktop\0111 orcl crash\oswbb\grid\archive is a valid archive directory and there are vmstat files under oswvmstat.
This tool requires vmstat data in order to run.
Program aborting…

2， 环境变量日期格式不对

C:\Users\zhang>java -jar “E:\google drive\Oracle\Oracle tool\oswbb840\oswbb\oswbba.jar” -i D:\archive

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

Parsing Data. Please Wait…

Scanning file headers for version and platform info…

Parsing file ldzwd2_prvtnet_22.01.11.0200.dat …
Parsing file ldzwd2_prvtnet_22.01.11.0200.dat …
An exception occured in insertVmstatLists on line 0
An exception occured in insertVmstatLists on line 5
An exception occured in insertVmstatLists on line 10
An exception occured in insertVmstatLists on line 15
An exception occured in insertVmstatLists on line 20

3， 内存溢出

C:\Users\zhang>java -Duser.language=en -Duser.country=us -jar “E:\google drive\Oracle\Oracle tool\oswbb840\oswbb\oswbba.jar” -i D:\archive

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

Parsing Data. Please Wait…

Scanning file headers for version and platform info…

Parsing file ldzwd2_prvtnet_22.01.11.0200.dat …
Parsing file ldzwd2_prvtnet_22.01.11.0200.dat …
Parsing file ldzwd2_prvtnet_22.01.11.0300.dat …
Parsing file ldzwd2_prvtnet_22.01.11.0400.dat …
Parsing file ldzwd2_prvtnet_22.01.11.0500.dat …
Parsing file ldzwd2_prvtnet_22.01.11.0600.dat …

Exception in thread “main” java.lang.OutOfMemoryError: GC overhead limit exceeded
at u.c(Unknown Source)
at u.a(Unknown Source)
at OSWGraph.OSWGraph.main(Unknown Source)

— 有时可以清理掉一些不需要的文件 如ps
C:\Users\zhang>java -Duser.language=en -Duser.country=us -Xmx1024M -jar “E:\google drive\Oracle\Oracle tool\oswbb840\oswbb\oswbba.jar” -i D:\archive

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 61 to Display Individual OS Process I/O RPS Graphs
Enter 62 to Display Individual OS Process I/O WPS Graphs
Enter 63 to Display Individual OS Process Percent User CPU Graphs
Enter 64 to Display Individual OS Process Percent System CPU Graphs
Enter 65 to Display Individual OS Process Percent Total CPU (User + System) Graphs
Enter 66 to Display Individual OS Process Percent Memory Graphs

Enter GP to Generate Individual Process Profile
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

打赏

微信扫一扫，打赏作者吧～