Re: checkdb up/down script for Windows

"Chuck" <skilover_nospam_at_bluebottle.com> wrote in message news:AJbtg.7566$Zf.1085_at_trnddc04...
> Jigar2Reshma_at_gmail.com wrote:
>> Hey everyone : I wanted to see if any one can suggest me or pass any
>> windows related script tp me on ho to check if an Oracle database on
>> windows is up/down. if down then send email. I am not a windows expert
>> but i can write a little batch script.
>>
>> any help is appreciated.
>>
>> thanks
>>
>
> The first thing I do on any Windows system is install a copy of CygWIN
> so I can use a *real* command line.
>
> As a couple of other posters have already stated, depending on the
> version of Oracle you installed either OEM or Grid Control already does
> this for you.

You can do everything and beyond with VBS/WMI, no need to install a "UNIX" command interface on Windows.
But like everyone else was saying, the built-in 10g DB Console has everything you need, and is very easy to configure (check the docs). Of course if your DB Console is down, your monitoring is down also :-) So you could add a little vbs script (scheduled with the Windows task scheduler) to monitor the status of the DB Console service.

HTH
Matthias Hoys Received on Wed Jul 12 2006 - 14:48:46 CDT