Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    8

    Unhappy Unanswered: TNS:12518 listener could not hand off client connection

    Hi,

    Oracle 9.2.0.1.0 on Solaris 8. I am getting "TNS:12518 listener could not
    hand off client connection" very frequently.

    Please help!!!

    Jammu

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    oerr tns 12518
    12518, 00000, "TNS:listener could not hand off client connection"
    // *Cause: The process of handing off a client connection to another process
    // failed.
    // *Action: Turn on listener tracing and re-execute the operation. Verify
    // that the listener and database instance are properly configured for
    // direct handoff. If problem persists, call Oracle Support.
    // *Comment: The problem can be worked around by configuring dispatcher(s)
    // to specifically handle the desired presentation(s), and connecting
    // directly to the dispatcher, bypassing the listener.
    ================================================== ======
    Based upon the above explanation , I suspect that you are running MTS
    and you don't have enough dispatchers/servers to handle the incoming load.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2004
    Posts
    8
    Thanks anacedent,

    I've modified the "dispatchers='(PROTOCOL=TCP)(DISPATCHERS=3), (PROTOCOL=TCP)'.

    Please let me know what this parameter is for, how the values affect the Connectivity?

    FYI: I am able to connect to DB thru sqlplus but not thru JDBC thin client.

    I'll observe the things & let you know the effect soon.

    Thanks
    Jammu

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I've modified the "dispatchers='(PROTOCOL=TCP)(DISPATCHERS=3), (PROTOCOL=TCP)'.

    >Please let me know what this parameter is for, how the values affect the connectivity?

    I'm no longer using MTS, but when I was the following were what I used in initSID.ora file.

    mts_dispatchers = "tcp,14"
    mts_dispatchers = "ipc,2"
    mts_max_dispatchers = 32
    mts_servers = 20
    mts_max_servers = 64

    >FYI: I am able to connect to DB thru sqlplus but not thru JDBC thin client.
    Not enough background information/details to know for sure.
    In SQL*Plus is being invoked on DB server system, then could be using BEQ;
    which bypasses SQL*Net & MTS.

    HTH & YMMV

    HAND!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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