DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Listener - service handler

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    Wink 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)

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width