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

From: Marcus Reichardt <mr_at_diamanda.hh.eunet.de>
Date: Thu, 02 Jul 1998 14:35:15 +0200
Message-ID: <359B7E83.231F@diamanda.hh.eunet.de>

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
> --

Just use sqlplus (plus80) to connect to a test account and redirect output to a file. Then check that file for a ORA-xxxx: No interface driver connected - function not performed (or so). If absent, db is up and running.

Marcus Reichardt
Consultant Received on Thu Jul 02 1998 - 07:35:15 CDT