Results 1 to 7 of 7

Thread: Listener error

  1. #1
    Join Date
    Apr 2002
    Location
    The Netherlands
    Posts
    4

    Unanswered: Listener error

    Hello,

    I am not an experienced user of listener.

    When I try to start the listener, I get the following error:


    LSNRCTL> start
    Starting tnslsnr80: please wait...

    TNSLSNR80 for 32-bit Windows: Version 8.0.4.0.0 - Production
    System parameter file is C:\orawin95\net80\admin\listener.ora
    Log messages written to C:\orawin95\net80\log\listener.log
    Trace information written to C:\orawin95\net80\trace\listener.trc
    Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=192)(HOST=127.0.0.1)(P ORT=1521))
    Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
    TNS-12560: TNS: protocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 161: Unknown system error



    I am running the listener on a M$ W2K machine, in M$ Win 98 it was running correct.

    Does anybody know how to solve this issue,

    Thanx in advance,

    Regards,
    Ray
    Last edited by Rijke111; 04-08-02 at 07:41.

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Don't know exactly what goes wrong there..
    But can't you remove the ADRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1)) part from the listener.ora?
    Normally you just need the TCP part.

    Groetjes
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Apr 2002
    Location
    The Netherlands
    Posts
    4
    Hoi,

    I've already tried to do that, but the problem is that I have more Listener.ora files.

    Is it that when the first Listener.ora file doesn't work the next one takes over??

    Thanks already for your reply.

    Groeten,
    Raymond

  4. #4
    Join Date
    Apr 2002
    Location
    The Netherlands
    Posts
    4
    Hoi,

    I just renamed the rest of the Listener.ora files.
    It did not work.

    It still comes up with:

    Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))

    This is what my Listener.ora says:

    LISTENER =
    (ADDRESS_LIST =
    # (ADDRESS =
    # (PROTOCOL = TCP)
    # (Host = *.*.*.*)
    # (Port = 1521)
    # )
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = 127.0.0.1)
    (Port = 1521)
    )
    # (ADDRESS =
    # (PROTOCOL = SPX)
    # (Service = CACST W95_lsnr)
    # )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = ADMIN
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = ORCL)
    (SID_NAME = ORCL)
    )

    )

    Is there something wrong with this file???

    Thanks in advance.

    Groeten,
    Raymond
    Last edited by Rijke111; 04-08-02 at 11:34.

  5. #5
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Are you sure it's using the correct listener.ora file?
    You can see this by typing 'lsnrctl status'
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  6. #6
    Join Date
    Apr 2002
    Location
    The Netherlands
    Posts
    4
    Here is the status:

    LSNRCTL> status
    Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521) )
    TNS-12224: TNS:no listener
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown system error

    So I think it is using the correct Listener.ora file.

    Thanks,
    Raymond

  7. #7
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Hmm that's strange..

    Here's what I found on Metalink about this problem:

    Problem Description:
    ====================

    You cannot start the listener on Windows NT.

    When trying to start the listener from the LSNRCTL80 prompt, you are see the
    following errors:

    TNS-12560: "protocol adapter error"
    Cause: A generic protocol adapter error occurred.
    Action: Check addresses used for proper protocol specification. Before
    reporting this error, look at the error stack and check for
    lower level transport errors. For further details, turn on
    tracing and reexecute the operation. Turn off tracing when the
    operation is complete.

    TNS-00530: "protocol adapter error"
    Cause: A generic protocol adapter error occurred.
    Action: For further details, turn on tracing and reexecute the operation.

    32-Bit Windows error:38:file name too long


    Solution Description:
    =====================

    Delete the protocols in your "listener.ora" file that you do not use.

    Edit the "listener.ora" file and look at the protocol section. Make sure that
    only the protocols that you use on your system are there (i.e., TCP, IPC, ...)
    and that there are no entries listed for SPX or NMP (named pipes).


    Explanation:
    ============

    In this case, the SPX protocol was listed first in the "listener.ora" file
    which was not being used and since the adapter was installed for SPX, the
    listener was failing on trying to start up SPX.


    -----------------------------------------------------------------------------------
    Failed to start service, TNS-12560, TNS-00530 when create new listener
    services

    Problem:
    To recreate Oracle TNS listener service on Windows NT, you delete the
    service entry in registry. When using lsnrctl to start the listener,
    you get the following errors:

    LSNRCTL> start
    Starting tnslsnr: please wait...

    Failed to start service, error 3.

    TNS-00530: Protocol adapter error

    The Listener service is not recreated and the Listener would not start.
    You are using a valid listener.ora file and protocol adapters.


    Solution:
    After you delete the Listener service from registry, you have to reboot NT
    for it to take effect. Then you can use lsnrctl to start the Listener,
    which would re-create the listener service.


    Explanation:
    The Listener service is marked 'disabled', but it still exists after you
    delete the service from registry.



    Don't know if this helps, but I can't think of anything else.

    Ruud
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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