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:0LOCAL SERVERService "dave2"has 1 instance（s）.Instance "dave2", status READY, has 1 handler（s） for thisservice...Handler（s）:"DEDICATED" established:5 refused:0 state:readyLOCAL SERVERService"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:readyDISPATCHER <machine: db2, pid: 11691>（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:readyLOCAL SERVERThe command completed successfully [oracle@db2 ~]$ lsnrctl statusLSNRCTL 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 LISTENERVersion TNSLSNR for Linux: Version10.2.0.1.0 - ProductionStart Date 12-JUL-2011 23:58:55Uptime 6 days 1 hr. 33 min. 19 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.oraListener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.logListening 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_nameFrom 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：http://download.oracle.com/docs/cd/E11882_01/network.112/e10835/lsnrctl.htm#NETRF112

Oracle 10g 配置OEM/DB CONSOLEOracle 数据库监听配置相关资讯 Oracle 监听 Oracle Listener

如何绕过Oracle listener 监听的密（07/22/2014 07:46:01）
Oracle Listener的动态注册（09/18/2013 20:43:54）
Oracle一个实例配置多个listener或（01/19/2013 09:54:49）

Oracle数据库listener 启动时提示（05/11/2014 17:21:40）
RAC Local_listener、一条 Oracle （03/11/2013 08:05:57）
使用Linux logrotate工具清理（01/07/2013 15:19:49）

本文评论查看全部评论（0）