| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: checkdb up/down script for Windows
Jigar2Reshma_at_gmail.com wrote:
> Thanks guys.
>
>
> 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
Please do not top post.
Copy this to a batch script. %1 can be passed as @database or for local connections, just ignore it. Call this script from any other batch script. Return code 0 means database is online.
Regards
/Rauf
Received on Thu Jul 13 2006 - 04:09:49 CDT
 |
 |