Status queries for Oracle databases

1 Status queries

Start state	SQL Statement	Results
Nomount	Select status 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

Status queries for Oracle databases