Re: SQL command to determine if DB is open

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Tue, 7 Aug 2001 13:15:08 -0400
Message-ID: <SoVb7.27727$jA2.1939219@news20.bellglobal.com>

Hi Andy,

If I understand you correctly, how about using something like the v$instance view (described next)

SQL> desc v$instance

 Name                            Null
 ------------------------------- ----

 INSTANCE_NUMBER
 INSTANCE_NAME
 HOST_NAME
 VERSION
 STARTUP_TIME
 STATUS
 PARALLEL
 THREAD#
 ARCHIVER
 LOG_SWITCH_WAIT
 LOGINS
 SHUTDOWN_PENDING SQL> select status from v$instance;

STATUS

---

OPEN SQL> You could specify the INSTANCE_NAME you're interested in etc...

Hopefully this helps..

Steve
"Andy Weiss" <amw157_at_aol.com> wrote in message news:6b0f7239.0108070910.40766f3f_at_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
Received on Tue Aug 07 2001 - 12:15:08 CDT