oracle查询数据库状态sql语句

select   status   from   gv$instance;

[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>