These days I configured Oracle OSWatcher tool and yast package for EM Grid Control used to manage and monitor Oracle servers. I want to share how quickly to configure and start using them on Linux.
OSWatcher invokes system utilities like ps, top, iostat, vmstat, netstat and collects data according to the specified parameters. You can download it from Metalink.
unzip it to OSWatcher directory you would use($OSWATCHER_HOME)
tar -xvf oswbb4.0.tar
OSWatcher has been renamed to OSWatcher Black Box to avoid the confusion with the too many tools with this name. OSWatcher Black Box Analyzer(OSWbba ) is a graphing and analysis utility which comes bundled with OSWbb v4.0.0 and higher. For OSWbba you need java version 1.4.2 or higher.
Put next lines in the profile needed by OSWatcher:
alias oswatch=’java -jar $OSWATCHER_HOME/oswbba.jar -i $OSWATCHER_HOME/archive’
Let’s start it with nohup in background and configure to take snapshots with the system utilities at every 5 minutes for the last 24 hours.
nohup ./startOSWbb.sh 300 24 &
What it does is subdirs in $OSWATCHER_HOME/archives like oswiostat, oswmeminfo, oswmpstat, oswnetstat, oswprvtnet, oswps, oswslabinfo, oswtop, oswvmstat where result .dat files with collected data for each hour reside. OSWbba parses all the archive files and you invoke it from the alias created in the profile:
Starting OSW Black Box Analyzer V4.0
OSWatcher Black Box Analyzer Written by Oracle Center of Expertise
Copyright (c) 2012 by Oracle Corporation
Parsing Data. Please Wait…
Parsing file …iostat_12.02.16.0100.dat …
Parsing file …vmstat_12.02.16.0100.dat …
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 P to Generate A Profile
Enter A to Analyze Data
Enter Q to Quit Program
Please Select an Option:
Yast(Yet Another Setup Tool) is needed if you need to administer a linux host through Enterprise Manager Grid Control. Download yast from here.
tar -xvf yast_el5_x86_64.tar
Start it in the commandline:
Here is how it looks like in EM Grid Control:
dd has been around for so many years( since 1970). It comes to help for quite a lot of things. I am impressed every time I have to use it, it is the right tool in the right time. It is very powerful and can rely on it if you know how to use it.
Here are some examples of dd use:
1. Convert EBCDIC to ASCII or vice versa
dd if=file.in of=file.out conv=ebcdic
2. Make bootable iso from DVD in case you need to backup the CD/DVD into image
dd if=/dev/hda of=dvd.iso
3. Drop ASM diskgroup
dd if=/dev/zero of=/dev/sdb bs=1048576 count=50
dd will put zeroes in the header of /dev/sdb disk, erasing the information. In this way the asm disk is seen as CANDIDATE and you are ready to re-use it. Check out Metalink [ID 563048.1].
After successfully installing 32-bit 11gR2 (220.127.116.11.0) software onto a 32-bit Linux OS (x86) system, neither netca or dbca can be run “An unexpected error has been detected by HotSpot Virtual Machine”
On my way of installing Oracle Enterprise Manager 11g Grid Control Release 1 (18.104.22.168.0) I hit bug 8930861, “X86 DBCA, NETCA GIVE JAVA HOTSPOT ERROR IF ON X86_64 HARDWARE”
Here is the scenario:
Platform: Linux x86
OS: Red Hat Enterprise Linux 5.5(32 bit)
DB: Oracle Database 11g Release 2 (11.2) – 32 bit with ASM
WLS: Weblogic Server 10.3.2(32 bit)
For the purpose of ASM install Oracle Grid Infrastructure for Standalone Server.
All went well until root.sh from where the indications for issues started:
Obviously the indications for potential issue start from here because the creation of local OCR failed
I tried to fix it and rerun root.sh before that reconfigure is needed.
Use force option if reconfigure fails:
/oracle/grid11/crs/install/rootcrs.pl -deconfig –force
Anyway, root.sh script failed with the same error and the only thing left was to continue and skip this.
The real issue is at the stage of Oracle net Configuration Assistant.
INFO: Starting ‘Oracle Net Configuration Assistant’
INFO: Starting ‘Oracle Net Configuration Assistant’
INFO: Oracle Net Services Configuration:
INFO: # An unexpected error has been detected by HotSpot Virtual Machine:
INFO: # SIGSEGV (0xb) at pc=0xa47dd35e, pid=3117, tid=3086616784
INFO: # Java VM: Java HotSpot(TM) Server VM (1.5.0_17-b02 mixed mode)
INFO: # Problematic frame:
INFO: # C [libnnz11.so+0x3c35e]
INFO: # An error report file with more information is saved as hs_err_pid3117.log
INFO: # If you would like to submit a bug report, please visit:
WARNING: /oracle/grid11/bin/netca: line 178: 3117 Aborted $JRE $JRE_OPTIONS -classpath $CLASSPATH oracle.net.ca.NetCA $*
# cat /proc/cpuinfo
model name : Six-Core AMD Opteron(tm) Processor 8425 HE
The case is that when running 64-bit hardware you have to use 64-bit OS and Oracle 11gR2 (or later) 64-bit, otherwise NETCA fails with Java VM: Java HotSpot.
Here is what metalink 942076.1 says:
Although the Linux OS that has been installed is indeed a supported 32-bit Linux OS, the hardware that is being used is 64-bit x86_64 hardware.
You are encountering published Bug 8930861, “X86 DBCA, NETCA GIVE JAVA HOTSPOT ERROR IF ON X86_64 HARDWARE”
You have Oracle’s 32-bit 22.214.171.124.0 RDBMS software, a supported 32-bit Linux OS, but you are on 64-bit x86_64 hardware.
1. Please find out if there is any business reason that the 64-bit hardware is only running a
32-bit OS. If not, then Oracle recommends that you re-install a 64-bit OS and 64-bit Oracle to
avoid published Bug 8930861, “X86 DBCA, NETCA GIVE JAVA HOTSPOT ERROR IF ON X86_64 HARDWARE”
2. If there is some business reason that you must use 64-bit hardware running a
32-bit Linux OS, then before you can use the 11gR2 DBCA or NETCA tools, you will need to apply patch 8670579 , “NETCA/DBCA FAILED WITH HOTSPOT VIRTUAL MACHINE”. You will be downloading and using file p8670579_112010_LINUX.zip”
Obviously in this case I have to reinstall the OS and use RHEL5 (64 bit) and Oracle Database 11g Release 2 (11.2) – 64 bit.
Have this in mind at an earlier stage.