Status queries for Oracle databases

1 Status Query

launch status	SQL Statement /p>	results
Nomount	Select Statu s from V$instance;	started
select Open_mode from v$database;	ERROR at line 1: Ora-01507:database not mounted
Mount	Select status from V$instance	Mounted
Select Open_mode from V$database	Mounted
Open	Select status from V$instance	OPEN
Select Open_mode from V$database	Read WRITE or Read only

2 Experimental Process

sql> startup Nomount;

ORACLE instance started.

Total System Global area 125829120 bytes

Fixed Size 1247684 bytes

Variable Size 92276284 bytes

Database buffers 25165824 bytes

Redo buffers 7139328 bytes

Sql> select status from V$instance;

STATUS

------------

Started

Sql> select Open_mode from V$database;

Select Open_mode from V$database

*

ERROR at line 1:

Ora-01507:database not mounted

Sql> ALTER DATABASE Mount;

Database altered.

Sql> select status from V$instance;

STATUS

------------

Mounted

Sql> select Open_mode from V$database;

Open_mode

----------

Mounted

sql> ALTER DATABASE open;

Database altered.

Sql> select status from V$instance;

STATUS

------------

OPEN

Sql> select Open_mode from V$database;

Open_mode

----------

READ WRITE