Oracle监听(Listener)中services说明

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 和实例名是相同的。

Toobtain detailed information about the database services, instances, and servicehandlers (dispatchers and dedicated servers) to which the listener forwardsclient connection requests.

From the operating system:

lsnrctlSERVICES listener_name

From the Listener Control utility:

LSNRCTL>SERVICES listener_name

listener_name: The listener name, if thedefault name of LISTENER is not used.

From：

#NETRF112