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 实验过程
1 > startup nomount;
2 ORACLE instance started.
3
4 Total System  Area  125829120 bytes
5 Fixed                  1247684 bytes
6 Variable              92276284 bytes
7  Buffers          25165824 bytes
8 Redo Buffers                7139328 bytes  9
10 >  status  v$instance;
11
12 STATUS
13------------
14 STARTED
15
16 >  open_mode  v$;
17  open_mode  v$
18 *
19 ERROR  line 1:
20 ORA-01507:  mounted
21
22 >  mount;
23
24  altered.
25
26 >  status  v$instance;
27
28 STATUS
29------------
30 MOUNTED
31
32 >  open_mode  v$;
33
oracle数据库怎么查询表
34 OPEN_MODE
35----------
36 MOUNTED
37
38 >  ;
39
40  altered.
41
42 >  status  v$instance;
43
44 STATUS
45------------
46
47
48 >  open_mode  v$;
49
50 OPEN_MODE
51----------
52

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。