If you try a bogus userid/password and use the ORA-1017 as "proof" that the database is up, you wouldn't know if the database is in restricted session mode. (Something that has burned me before.) I personally think the best way for verifying that the database is up is to create a session (create a userid that only has "create session" privilege and use that for verification.
> -----Original Message-----
> testa_at_dmc-it.com
>
> Mike, make your script attempt to login into the database(even with a
> bogus userid/password),
>
> you get a ORA-1017 invalid userid/password, you know the
> database is up
> and you got a connection to it.
>
> Joe
>
>
> > I have to write an HP-UX Korn shell script to check the status of 20
> > databases - up or down - and send an email if any are down. I'm a
> > relative newbie at Unix. I'm not asking anyone to "do it
> for me", but
> > does anyone know of any scripts to check database status by
> greping or
> > otherwise looking at the oratab or other file and checking
> the status?
> >
> > Mike
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Mar 11 2004 - 15:51:52 CST
