From: "Lowell Paden" <paden_lv@nospam.yahoo.com>
Newsgroups: comp.databases.oracle.misc
References: <6b0f7239.0108070910.40766f3f@posting.google.com>
Subject: Re: SQL command to determine if DB is open
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <iCec7.2$84.62@dit4.state.va.us>
Date: Wed, 8 Aug 2001 13:31:10 -0400
NNTP-Posting-Host: 198.176.41.2
X-Trace: dit4.state.va.us 997291534 198.176.41.2 (Wed, 08 Aug 2001 13:25:34 EDT)
NNTP-Posting-Date: Wed, 08 Aug 2001 13:25:34 EDT
Organization: Dept of Information Technology


If the database is down, you can't even logon.
Any successful query will indicate that the database is up, even select *
from dual.

"Andy Weiss" <amw157@aol.com> wrote in message
news:6b0f7239.0108070910.40766f3f@posting.google.com...
> I need a quick command that I can execute in SQL Plus to determine if
> a database is open or not.  Been wading through Oracle's documentation
> hopelessly for hours.
>
> Any suggestions?
> Andy