Re: Oracle supervision

Hi Joe,

Just to add to Brian's note. Perl is great for doing this kind of stuff. You can also connect / as sysdba from within perl (DBI DBD-Oracle). If you are looking for help on this email me privately I have some good examples. I would suggest you goto www.activestate.com to pick up Perl (ver 2.6) for windows which is free. Once you do this use the perl package manager (ppm) to load DBI and DBD-Oracle. After that this kind of thing is very easy and highly portable (perl works on most OS and Platform).

IMHO much better than Enterprise manager events.

HTH
Frank P.

"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message news:3EE89832.4CF230B6_at_remove_spam.peasland.com...
> One could always write a Perl script to sign on to the database and do
> something trivial like "SELECT * FROM DUAL". If data is returned, then
> the database is up and running. One could also do lots of error trapping
> in their Perl program.
>
> Cheers,
> Brian
>
> Joe Smith wrote:
> >
> > Hi,
> >
> > I'm using Oracle 8.1.7 for Windows.
> >
> > From command line, I have to verify that Oracle is ok and running. With
> > cygwin utils (using ps), I can verify that there is a oracle.exe
application
> > running.
> > Is there any tool (from Oracle or other) to do this 'properly', or to
obtain
> > a more detailed information (initialisation errors, for example)?
> >
> > Thanks in advance.
> > Sorry if this question is too dumb. I've googled for this and found
nothing
> > interesting.
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Thu Jun 12 2003 - 20:47:01 CDT