Re: How to find out an Oracle DB is up and running?

From: JHY <jhy_at_earthling.net>
Date: Wed, 01 Jul 1998 21:32:34 -0400
Message-ID: <6nenvi$n6l@bgtnsc01.worldnet.att.net>

Try this. Create the following files with these commands. Yes, I know UP.SQL contains a password. If you can figure out another way I'd love to see it.

UP.SQL:
SET STOPONERROR ON
connect system/manager
spool UP.OUT
show sga
exit

UP.BAT:
DEL UP.OUT
SVRMGR23 @UP.SQL
IF EXIST UP.OUT ECHO Oracle is up
IF NOT EXIST UP.OUT ECHO Oracle is down

Xuening Sun wrote:

> Hi,
>
> Could someone help me with this: is there a simple way in which I can find
> out an Oracle database is up and running from a batch script (the
> platform is NT 4.0)?
>
> Thanks.
>
> Xuening Sun
> --
Received on Wed Jul 01 1998 - 20:32:34 CDT