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

Thread: simple listener problem

Hybrid View

  1. #1
    Join Date
    Jun 2000
    Posts
    417
    I'm having some small problem with adding a new listner. Originally I had just FUNK, and today I wanted to add TEST. I've done this before on an 8.0.5 and an 8.1.6 installation (right now I'm using 8.1.6) and didn't have a problem, maybe I'm just missing something trivial.

    If no listeners are running, I can start the listener for funk, but then when I try to start test, it says "Listener using name funk has already been started".

    Or, if no listeners are running, I can start the listener for test, but when I try to start funk, it says "Listener using name test has already been started".

    For some reason it's not recognizing that I want to start the other listner. I'm using just "lsnrctl start test", or "lsnrctl start funk". Either one will start individually, but if I try to start the second one, it thinks I'm trying to start the first one again.

    Any ideas? Figure I just need another pair of eyes. My listener.ora is below.

    <font face="courier">
    # LISTENER.ORA Configuration File:
    # Generated by Oracle configuration tools.

    FUNK =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 2481))
    )
    )

    SID_LIST_FUNK =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /app/oralmc/product/8.1.6)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = funk)
    (ORACLE_HOME = /app/oralmc/product/8.1.6)
    (SID_NAME = funk)
    )
    )

    STARTUP_WAIT_TIME_funk = 0
    CONNECT_TIMEOUT_funk = 10
    TRACE_LEVEL_funk = OFF

    LOG_DIRECTORY_funk = /app/oralmc/product/8.1.6/network/admin
    LOG_FILE_funk = funk
    TRACE_DIRECTORY_funk = /app/oralmc/product/8.1.6/network/admin
    TRACE_FILE_funk = funk

    TEST =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 1551))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 2491))
    )
    )

    SID_LIST_TEST =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /app/oralmc/product/8.1.6)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = test)
    (ORACLE_HOME = /app/oralmc/product/8.1.6)
    (SID_NAME = test)
    )
    )
    STARTUP_WAIT_TIME_test = 0
    CONNECT_TIMEOUT_test = 10
    TRACE_LEVEL_test = OFF

    LOG_DIRECTORY_test = /app/oralmc/product/8.1.6/network/admin
    LOG_FILE_test = test
    TRACE_DIRECTORY_test = /app/oralmc/product/8.1.6/network/admin
    TRACE_FILE_test = test
    </font>

  2. #2
    Join Date
    Oct 2000
    Posts
    80
    What is the output from :
    lsnrctl service
    ?

    John Doyle

  3. #3
    Join Date
    Jun 2000
    Posts
    417
    Actually both lsnrctl service and lsnrctl status give me

    <font face="courier">
    oralmc@irad-rms:/d01/app/oralmc> lsnrctl service

    LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 02-FEB-2001 15:11:39

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

    Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
    TNS-01103: Protocol specific component of the address is incorrectly specified
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Solaris Error: 2: No such file or directory
    oralmc@irad-rms:/d01/app/oralmc>
    </font>

    Which has happened even with the old version of the database that was set up by Oracle clients before I got on the job. If you knew how to fix that it would be great too.

    lsnrctl status funk yeilds

    <font face="courier">
    .....variables....
    Services Summary...
    PLSExtProc has 1 service handler(s)
    funk has 1 service handler(s)
    The command completed successfully
    </font>

    however if I try to start test by "lsnrctl start test", it fails with the error I mentioned, but when I do "lsnrctl status funk" again I get

    <font face="courier">
    .... variables ....
    Services Summary...
    PLSExtProc has 1 service handler(s)
    funk has 1 service handler(s)
    funk has 2 service handler(s)
    test has 2 service handler(s)
    The command completed successfully
    </font>


  4. #4
    Join Date
    Oct 2000
    Posts
    80
    It's not clear why this is happening, except for a possible bug.
    I duplicated your situation on my NT network and it (8.1.5) gave me no problems. I could start either one or both listeners from the command line.
    What seems to occur is that when you specify a particular listener it runs the whole file, so that both listeners are always started. This would be the same as if you ran "LSNRCTL START" without specifying the name of the individual listener.
    This amounts to your having no problem, doesn't it? Both listeners are up. Is that a bad thing?
    I can't figure out the "service" listing problem you showed.
    John Doyle

  5. #5
    Join Date
    Aug 2000
    Posts
    194
    Could it be anything to do with the GLOBAL_DBNAME. Did you try removing that line and try starting the listener?

  6. #6
    Join Date
    Jun 2000
    Posts
    417
    If I run just "lsnrctl start", the listener for FUNK starts, but I still get

    ORA-12203: TNS:unable to connect to destination

    when I try to connect to TEST. I switched the order in the file just to see if it was starting the first one, but it still starts up FUNK and not TEST.

    But as I said, TEST starts and runs fine if I start it individually when no other listeners are running.

    Everything seems to be configured properly, it's identical to lots of listeners that have worked before, the tnsnames.ora on the client side is correct. I'm not sure what the deal is.

    Removing GLOBAL_DBNAME didn't make a difference, thanks for the suggestion though.

    [Edited by pwoneill on 02-02-2001 at 05:47 PM]

  7. #7
    Join Date
    Oct 2000
    Posts
    80
    You modified your listener.ora file using Net 8 assistant I presume.
    Maybe turdcan the whole thing and start from scratch with Net8 and make a new listener.ora file.
    Maybe reinstall the listener program. I dunno.
    John Doyle

  8. #8
    Join Date
    Jun 2000
    Posts
    417
    Problem solved, for anybody wondering you can't have two IPC entries in the listener.ora file. I removed the one for TEST and everything started up as expected.

  9. #9
    Join Date
    Nov 2000
    Posts
    26

    Unhappy

    neil,
    pls. can u put in the modified listener.ora? i am also in this fix for quite sometime now, just dismissed as some bug in oracle
    soren

  10. #10
    Join Date
    Jun 2000
    Posts
    417
    Sure, here was the section for TEST originally with the bad part highlighted

    <font face="courier">
    TEST =
    (DESCRIPTION_LIST =
    (DESCRIPTION =<font color="#FF0000">
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )</font>
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 1551))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = irad-rms)(PORT = 2491))
    )
    )
    </font>

    I removed the highlighted section and everything was fine.

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