Oracle 监听(Listener) 中 services 说明
一. 查看service1.1 先看下一个监听查看的示例：
[Oracle@db2 ~]$ lsnrctl service
LSNRCTL for Linux: Version 10.2.0.1.0 -Production on 19-JUL-2011 01:24:43
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db2)(PORT=1521)))
Services Summary…
Service “PLSExtProc”has 1 instance(s).
Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) forthis service…
Handler(s):
“DEDICATED” established:0 refused:0
LOCAL SERVER
Service “dave2″has 1 instance(s).
Instance “dave2”, status READY, has 1 handler(s) for thisservice…
Handler(s):
“DEDICATED” established:5 refused:0 state:ready
LOCAL SERVER
Service”dave2XDB” has 1 instance(s).
Instance “dave2”, status READY, has 1 handler(s) for thisservice…
Handler(s):
“D000” established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=db2)(PORT=35619))
Service “dave2_XPT”has 1 instance(s).
Instance “dave2”, status READY, has1 handler(s) for this service…
Handler(s):
“DEDICATED” established:5 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle@db2 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 -Production on 19-JUL-2011 01:32:14
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db2)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version10.2.0.1.0 – Production
Start Date 12-JUL-2011 23:58:55
Uptime 6 days 1 hr. 33 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db2)(PORT=1521)))
Services Summary…
Service “PLSExtProc”has 1 instance(s).
Instance”PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…
Service “dave2” has 1 instance(s).
Instance”dave2″, status READY, has 1 handler(s) for this service…
Service “dave2XDB” has 1 instance(s).
Instance”dave2″, status READY, has 1 handler(s) for this service…
Service “dave2_XPT” has 1 instance(s).
Instance “dave2”, status READY, has 1 handler(s) for this service…
The command completed successfully
我们通常配置net service name，使用的service 和实例名是相同的。
1.2 官网对Service的说明1.2.1 Purpose
Toobtain detailed information about the datab
本文来源gao!%daima.com搞$代*!码9网(
ase services, instances, and servicehandlers (dispatchers and dedicated servers) to which the listener forwardsclient connection requests.
1.2.2 Syntax
From the operating system:
lsnrctlSERVICES listener_name
From the Listener Control utility:
LSNRCTL>SERVICES listener_name
1.2.3 Arguments
listener_name: The listener name, if thedefault name of LISTENER is not used.
From：
#NETRF112
，
转载请注明原文链接：Oracle 监听(Listener) 中 services 说明
