Oracle view database and database listening startup status

1, Database status query: Sql>select status from V$instance; 2, the Database monitoring status query: C:/Documents and Settings/skate_db>lsnrctl status

    1, Database Status command results detailed:   [email protected]/export/home/oracle >  sqlplus / as sysdba      SQL*Plus: Release  11.2.0.1.0 production on mon aug 24 10:40:38 2015       Copyright  (c)  1982, 2009, oracle.  all rights reserved.          connected to:   oracle database  11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production    With the Partitioning, OLAP, Data Mining and Real  application testing options      sql> select status  from v$instance;      status   ------------    open 

   2, Database Listener command result details:    c:/documents and settings/skate_db>lsnrctl  status   lsnrctl for 32-bit windows: version 10.2.0.1.0 -  production on 19-7 Month  -2008   12:1   1:19    copyright  (c)  1991, 2005, Oracle. All rights reserved.    Connecting to   (description= (address= (PROTOCOL=IPC) (Key=extproc1))    LISTENER      STATUS   ------------------------    Aliases    LISTENER     version    tnslsnr for 32-bit windows: version 10.2.0.1.0 -    Produ   ction    Start date    19-7 month  -2008    11:47:59    uptime    0  days  0  hours  23  minutes  19 seconds     Tracking Level  &NBsp; off    Safety    ON: Password or Local OS    Authentication   SNMP   OFF    Listener parameter File    e:/ oracle/product/10.2.0/db_3/network/admin/listener.ora    Listener log File    e:/oracle/ product/10.2.0/db_3/network/log/listener.log    Listener Endpoint Profile ...    (DESCRIPTION= (ADDRESS = (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC1IPC)))     (description= (address= (protocol=tcp) (host= Skate) (port=1522))     Service Summary:     Services     "Plsextproc"   includes  1  cases.     routines   "Plsextproc",  status  UNKNOWN,   1  handlers that contain this service ...     Services     "ORCL"   includes  1  cases.     routines   ORCL,  status  READY,   1  handlers ...    services that contain this service   "Orclxdb"   includes a  1 instance.     routines   "ORCL",   Status  READY,   1  handlers for this service ...    services   "ORCL_XPT"   includes  1  cases.     routines     "ORCL",  status  READY,   1  handlers that contain this service ...     Command execution succeeded

   2, database listening local query results:   [email protected]/export/home/oracle >  lsnrctl status       lsnrctl for solaris: version  11.2.0.1.0 - production on 24-aug-2015 10:49:42       copyright  (c)  1991, 2009, Oracle.  All rights reserved.       Connecting to  (address= (protocol=tcp) (host=) (port=1521))     status of the listener   ------------------------   Alias                       LISTENER   Version                    TNSLSNR for Solaris: Version  11.2.0.1.0 - production   start date                 24-AUG-2015 10:34:13   Uptime                     0 days 0 hr.  15 min. 28 sec   Trace Level                off   Security                   on: local os  Authentication   SNMP                       OFF   Listener Log  file         /u01/app/oracle/diag/tnslsnr/t5120/listener/alert/ Log.xml   listening Endpoints Summary...      (description= (address= (protocol=tcp) (host=t5120) ( port=1521))    Services Summary...   Service  "Orca"  has 1  instance (s) .     instance  "Orca",  status ready, has 1  handler (s)  for this service...   Service  "Orcaxdb"  has 1  instance (s) .     instance  "Orca",  status ready, has 1  handler (s)  for this service...   The command completed  Successfully

Oracle view database and database listening startup status