Re: Confirming Database is Down on Windows

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 11 Mar 2009 14:50:00 -0700
Message-ID: <bf46380903111450w195adcc5j9989d29874ff21fc_at_mail.gmail.com>

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On Wed, Mar 11, 2009 at 1:31 PM, Charlotte Hammond < charlottejanehammond_at_yahoo.com> wrote:

> Hi Jared,
>
> I need to know for sure the database is DOWN rather than just not
> accessible to new connections, as I want to ensure it is safe to run a cold
> backup.
>

*IF* the service is also stopped when the database is down, you could use something like this:

  c:\ net start | findstr OracleService

Kind of lame, but then again, the windows cmdline is what it is.

Jared

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 11 2009 - 16:50:00 CDT