SELECT * FROM v$instance;

INSTANCE_N INSTANCE_NAME    HOST_NAME        VERSION           STARTUP_T STATUS  PAR THREAD#    ARCHIVE LOG_SWITCH_ LOGINS     SHU DATABASE_STATUS  
---------- ---------------- ---------------- ----------------- --------- ------- --- ---------- ------- ----------- ---------- --- -----------------
         1 orcl                              8.1.5.0.0         20-JUL-00 OPEN    NO           1 STOPPED             ALLOWED    NO  ACTIVE