oracle数据库状态是started,Oracle数据库的状态查询

1 状态查询

启动状态

SQL语句

结果

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 或者 READ ONLY

2 实验过程

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

Oracle数据库的状态查询

标签：table   rtu   pad   acl   pos   lsp   oracle数据库   err   bsp

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：http://www.cnblogs.com/diyunpeng/p/8051741.html