topic Simple script in Operating System - HP-UX

Simple script

H_16 — Fri, 21 May 2004 06:21:40 GMT

Can someone help !!

I need a shell script {HP-UX) to monitor
my oracle PMON processes...I have three databases running so I obviously have three PMON processes running..I want a script that if one or more processes are not there it sends a error message using opcmsg (OVO)

any ideas

Re: Simple script

Mark Grant — Fri, 21 May 2004 06:28:39 GMT

The simple way would be

[[ `ps -ef | grep -v grep | grep ora_pmon | wc -l` -eq 3 ]] || /opt/OV/bin/OpC/opcmsg application=Monitor object=OS msg_text="at least on pmon is missing" msg_grp= severity=critical node=

However, this might occassionally alert when there is no problem at all as other processes might make grep see ora_pmon. You could adapt it to be cleverer though.

Re: Simple script

H_16 — Fri, 21 May 2004 06:43:40 GMT

Thanks for the quick response..

Re: Simple script

Nicolas Dumeige — Fri, 21 May 2004 07:26:14 GMT

Hello,

It might be valuable to which instance is down - for instance if you want the monitoring team to re-start it - then you might want to loop on your oratab file.

My 0,02 cents

Nicolas