Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

65

积分

0

好友

31

主题
1#
发表于 2012-6-25 21:51:48 | 查看: 3782| 回复: 0
我把执行结果copy,熟悉的人自然会发现问题在哪里?

i2ksvr:~ # su - oracle
[email=oracle@i2ksvr]oracle@i2ksvr[/email]:~> lsnrctl
LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 21-JUN-2012 14:06:49
Copyright (c) 1991, 2008, Oracle.  All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status LISTENER
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                20-JUN-2012 15:59:26
Uptime                    0 days 22 hr. 7 min. 28 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /opt/oracle/oradb/diag/tnslsnr/i2ksvr/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=i2ksvr)(PORT=1521)))
Services Summary...
Service "inomc" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
Service "inomcXDB" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
Service "inomc_XPT" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status inomc
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=i2ksvr)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=inomc)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                20-JUN-2012 15:59:26
Uptime                    0 days 22 hr. 7 min. 58 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /opt/oracle/oradb/diag/tnslsnr/i2ksvr/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=i2ksvr)(PORT=1521)))
Services Summary...
Service "inomc" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
Service "inomcXDB" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
Service "inomc_XPT" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status aaaTNS-01101: Could not find service name aaaLSNRCTL> service LISTENER
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "inomc" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:24686 refused:0 state:ready
         LOCAL SERVER
Service "inomcXDB" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: i2ksvr, pid: 11014>
         (ADDRESS=(PROTOCOL=tcp)(HOST=i2ksvr)(PORT=42135))
Service "inomc_XPT" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:24686 refused:0 state:ready
         LOCAL SERVER
The command completed successfully
LSNRCTL> status inomc
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=i2ksvr)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=inomc)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                20-JUN-2012 15:59:26
Uptime                    0 days 22 hr. 8 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /opt/oracle/oradb/diag/tnslsnr/i2ksvr/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=i2ksvr)(PORT=1521)))
Services Summary...
Service "inomc" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
Service "inomcXDB" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
Service "inomc_XPT" has 1 instance(s).
  Instance "inomc", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status inomcXDB
TNS-01101: Could not find service name inomcXDB
LSNRCTL> service inomcXDB
TNS-01101: Could not find service name inomcXDB
LSNRCTL>

我找Oracle的官方文档,看看它的描述吧
<<
Oracle?Database
Net Services Administrator's Guide
11g Release 2 (11.2)
E10836-07
>>

Determining the Current Status of a Listener
To show the current status of a listener, use either the STATUS command of the Listener
Control utility or Oracle Enterprise Manager. The status output provides basic status
information about a listener, a summary of listener configuration settings, the listening
protocol addresses, and a summary of services registered with the listener.
Using Listener Control to Show Status
To show the status the listener from the command line, enter:
lsnrctl STATUS [listener_name]In the preceding command, listener_name is the name of the listener defined in the
listener.ora file. It is not necessary to identify the listener if you are using the default
listener, named LISTENER.
Example 9–6 shows example output of the STATUS command.
Example 9–6 Listener Control Utility's STATUS Command Output
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=net)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.0.2
Start Date 15-NOV-2009 20:22:00
Uptime 0 days 0 hr. 5 min. 22 sec
Trace Level support
Security OFF
SNMP OFF
Listener Parameter File /oracle/admin/listener.ora
Listener Log File /oracle/network/log/listener.log
Listener Trace File /oracle/network/trace/listener.trc
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=net)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=sales-server)(PORT=2484)))
Services Summary...
Service "sales.us.example.com" has 1 instance(s).
Instance "sales", status READY, has 3 handler(s) for this service...
Service "hr.us.example.com" has 1 instance(s).
Instance "hr", status READY, has 2 handler(s) for this service...
The command completed successfully
The STATUS command generates output with the sections described in Table 9–2.

SQL> col name format a30;
SQL> select name,value,type from v$parameter where name like '%name%';
NAME                           VALUE                                TYPE
------------------------------ -------------------- --------------------
lock_name_space                                                        2
db_file_name_convert                                                   2
log_file_name_convert                                                  2
global_names                   FALSE                                   1
instance_name                  inomc                                   2service_names                  inomc                                   2db_name                        inomc                                   2
db_unique_name                 inomc                                   2
8 rows selected

lsnrctl STATUS  后面只能接 Listener的名字,为何我接服务名也不报错呢?
神奇啊?
至少是Oracle的文档有问题把?


[ 本帖最后由 etl2007 于 2012-6-25 21:59 编辑 ]
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 03:20 , Processed in 0.044311 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569