Check oracle database status

column database_name FORMAT A20 COLUMN status FORMAT A10 select database_name, status from v$instance; DATABASE_NAME STATUS -------------------- ---------- FREE OPEN