Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: checkdb up/down script for Windows

Re: checkdb up/down script for Windows

From: Matthias Hoys <>
Date: Thu, 13 Jul 2006 21:35:17 +0200
Message-ID: <44b6a076$0$31467$>

"Chuck" <> wrote in message news:90utg.16831$Wh7.9408_at_trnddc07...

> Matthias Hoys wrote:

>> "Chuck" <> wrote in message
>> news:AJbtg.7566$Zf.1085_at_trnddc04...
>>> 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.

Yes, you can run external programs from within a VBS script with the object.

Example (should work for sqlplus also) :

set oSh = createObject("")
ret ="%comspec% /c dir >dir.out",0,true)

As for your second question (running sqlplus in the background), I have no clue how to do this with vbs but I wouldn't be surprised if it was possible - it's more powerful than most people think (actually, it's not vbs that's so powerful, it's the whole Windows Script Host environment; vbs is just a language used to access WSH objects, you could also use another language like JavaScript for example).

Matthias Received on Thu Jul 13 2006 - 14:35:17 CDT

Original text of this message