In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
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
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.