Re: Question on listeners and handlers

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 01 Aug 1999 12:00:12 GMT
Message-ID: <37a4364c.5534782@news.demon.nl>

On Fri, 30 Jul 1999 21:18:52 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>STATUS of the LISTENER
>------------------------
>Alias LISTENER
>Version TNSLSNR for Solaris: Version 2.3.4.0.0 -
>Production
>Start Date 21-JUL-99 19:12:41
>Uptime 8 days 21 hr. 4 min. 8 sec
>Trace Level off
>Security OFF
>SNMP OFF
>Listener Parameter File
>/export/apps/oracle/734/network/admin/listener.ora
>Listener Log File
>/export/apps/oracle/734/network/log/listener.log
>Services Summary...
> DBLP2 has 2 service handler(s)
> ^^
> WHat does that mean? Other DB's have one.
>---------------
>Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>

This means it is listening for two databases, or to one database with one service for dedicated server and one for multithreaded server. Issue the services command in lsnrctl and you will know. When necessary you will need to issue set password <password in listener.ora file> first, because this command is protected by a password.

Hth,

Sybrand Bakker, Oracle DBA Received on Sun Aug 01 1999 - 07:00:12 CDT