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 plsextprochas 1 instance(s).
instance plsextproc, status unknown, has 1 handler(s) forthis service...
handler(s):
dedicated established:0 refused:0
local server
service dave2has 1 instance(s).
instance dave2, status ready, has 1 handler(s) for thisservice...
handler(s):
dedicated established:5 refused:0 state:ready
local server
servicedave2xdb 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_xpthas 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 plsextprochas 1 instance(s).
instanceplsextproc, status unknown, has 1 handler(s) for this service...
service dave2 has 1 instance(s).
instancedave2, status ready, has 1 handler(s) for this service...
service dave2xdb has 1 instance(s).
instancedave2, 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 purposetoobtain detailed information about the database services, instances, and servicehandlers (dispatchers and dedicated servers) to which the listener forwardsclient connection requests.
1.2.2 syntaxfrom the operating system:
lsnrctlservices listener_name
from the listener control utility:
lsnrctl>services listener_name
1.2.3 argumentslistener_name: the listener name, if thedefault name of listener is not used.
from：
#netrf112
，