Listener - service handler

LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.7.4.0 - Production on 05-MAR-2003 10:30:33

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 8.1.7.4.0 - Production
Start Date 03-MAR-2003 05:00:02
Uptime 02 days 5 hr. 30 min. 31 sec
Trace Level off
Security OFF
SNMP ON
Listener Parameter File /u01/app/oracle/product/8.1.7/network/admin/listener.ora
Listener Log File /u32/testing/listener.log
Services Summary...
SPIN has 1 service handler(s)
SPIN has 1 service handler(s)
PLSExtProc has 1 service handler(s)
DAVE has 1 service handler(s)
INN has 2 service handler(s)
DOG has 2 service handler(s)
The command completed successfully


QUESTION1: Why do I have 2 separate service handlers for the spin database:

SPIN has 1 service handler(s)
SPIN has 1 service handler(s)

QUESTION 2: Why do I have INN showing this as the service handler:

INN has 2 service handler(s)

probably you listed it in the listener.ora file, and it also registered itself (8i onwards).

You shouldn't need to list the db in listener.ora if your setup is pretty standard, which i guess it is otherwise the instance wouldn't auto-register.