Re: startup ?

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Mon, 3 Dec 2001 22:50:10 GMT
Message-ID: <3C0C01A2.8E5EDEDF@peasland.com>

After a 'ps' has verified that a database has been started, you can determine what state it is in (MOUNT, NOMOUNT,OPEN) by querying the STATUS column of V$INSTANCE as below:

 SQL> startup nomount
ORACLE instance started.

Total System Global Area 54895648 bytes

Fixed Size                   279584 bytes
Variable Size              33554432 bytes
Database Buffers           20971520 bytes
Redo Buffers                  90112 bytes

 SQL> select status from v$instance;

STATUS

---

STARTED  SQL> alter database mount;

Database altered.

 SQL> select status from v$instance;

STATUS

---

MOUNTED  SQL> alter database open;

Database altered.

 SQL> select status from v$instance;

STATUS

---

OPEN HTH,
Brian

Ban Spam wrote:
>
> "M. Cao" <mcao_at_u.washington.edu> wrote in
> news:Pine.A41.4.33.0112012056390.41142-100000_at_homer20.u.washington.edu:
>
> >
> > How to find out current database availability on unix/oracle ?
> > I mean database startup with mount, nomount or open option.
> >
> > Thanks in advance !
> > Minh
> >
> >
> >
> >
>
> $ ps -ef | grep oracle # replace "oracle" with the username who starts it
Received on Mon Dec 03 2001 - 16:50:10 CST