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 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
，
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至253000106@qq.com举报，一经查实，本站将立刻删除。
发布者：PHP中文网，转转请注明出处：https://www.chuangxiangniao.com/p/1905489.html
