时间：2021-07-01 10:21:17 帮助过：57人阅读
Oracle 监听(Listener) 中 services 说明
一. 查看service 1.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 database 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
