Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: checkdb up/down script for Windows
The script posted may not work properly. ORA-01017 indicates invalid
username/password only. What if the database string is simply
non-existence or something wrong with sqlnet setup etc, network etc?
The command of echo exit|sqlplus username/password
will always yield a success return no matter what happens (same for
UNIX and Windows)
The only sure way is to examine the output to see if it is success or not.
I run something like this:
sqlplus -s /nolog @check
type check.lst|findstr /b 'okay' 1>null 2>&1
if errorlevel == 1 (echo error)
where check.sql is something like this:
spool check_list
connect username/password
select 'okay--' from dual;
exit
The Database would be up and available only if we get the string 'okay' in the response. Of course, everything is parameter driven and email sent out if it happens etc.
Rauf Sarwar wrote:
> 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
>
>
>