Oracle to view database and database snooping startup status

1. Database status query: SQL > select status from instance; 2. Database monitoring status query: C:/Documents and Settings/skate_db > lsnrctl status 1, database status command result description: oracle.orca@/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 listening command details: C:/Documents and Settings/skate_db > lsnrctl status LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on 19-July-2008 12:1 1:19 Copyright (c) 1991, 2005, Oracle. All rights reserved. STATUS connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=IPC) (KEY=EXTPROC1) LISTENER-alias LISTENER version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0-Produ ction launch date 19-July-2008 11:47:59 uptime 0 days 0 hours 23 minutes 19 seconds trace Level off security 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 summary. (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (PIPENAME=//./pipe/EXTPROC1ipc) (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=skate) (PORT=1522) Service Summary. The service "PLSExtProc" contains 1 routine. Routine "PLSExtProc", status UNKNOWN, contains 1 handler for this service. The service "orcl" contains 1 routine. Routine "orcl", status READY, contains 1 handler for this service. The service "orclXDB" contains 1 routine. Routine "orcl", status READY, contains 1 handler for this service. The service "orcl_XPT" contains 1 routine. Routine "orcl", status READY, contains 1 handler for this service. Command executed successfully 2. Database listens to local query results: oracle.orca@/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