Re: checkdb up/down script for Windows

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Thu, 13 Jul 2006 15:53:41 GMT
Message-ID: <90utg.16831$Wh7.9408@trnddc07>

Matthias Hoys wrote:
> "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
>
>

With VBS, can I run sqlplus and pipe the output to a filter? Or launch sqlplus in background and interactively communicate with it?

VBS is worlds better than batch files but IMO it still doesn't hold a candle to cygwin or a real unix shell. Received on Thu Jul 13 2006 - 10:53:41 CDT