Re: Oracle supervision

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"