- 最后登录
- 2016-4-13
- 在线时间
- 49 小时
- 威望
- 65
- 金钱
- 751
- 注册时间
- 2012-3-13
- 阅读权限
- 50
- 帖子
- 95
- 精华
- 1
- 积分
- 65
- UID
- 293
|
1#
发表于 2012-6-25 21:51:48
|
查看: 3753 |
回复: 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 编辑 ] |
|