Oracle 监听(Listener) 中 services 说明

[img]http://dl2.iteye.com/upload/attachment/0092/9662/5d416669-27f2-3e82-9ca4-70ba6b95721a.jpg[/img]
　　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 和实例名是相同的。