oracle查询数据库状态sql语句

oracle查询数据库状态sql语句

select   status   from   gv$instance;
1

运行展示

[oracle@dm02dbadm01 ~]$ source /home/oracle/12c.env 
[oracle@dm02dbadm01 ~]$ export ORACLE_SID=gooddb1
[oracle@dm02dbadm01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 31 14:50:54 2022

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SYS@gooddb1> select   status   from   gv$instance;

STATUS
------------
OPEN
OPEN

SYS@gooddb1> 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21