Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2009
    Posts
    2

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

    Hi there!

    I have here a SuSE SLES 10 64bit System with an Oracle Database Version 10.2.0.3.0

    Sometimes the listener get a fault like this:

    TNS-12518: TNS:listener could not hand off client connection
    TNS-12547: TNS:lost contact
    TNS-12560: TNSrotocol adapter error
    TNS-00517: Lost contact
    Linux Error: 32: Broken pipe

    At dmesg I found this:

    tnslsnr[3089]: segfault at 0000000000000018 rip 00002b2d68ad2778 rsp 00007fff43f033c0 error 4

    What is the reason for the "Broken pipe" error? The metalink 550859.1 was not very helpful.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Is any type of Operating System Virtualization involved on this system?
    If so, please elaborate.

    http://www.dbforums.com/query.php?do...%3A%23336699%3
    Last edited by anacedent; 12-29-09 at 23:32.
    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
    Dec 2009
    Posts
    2
    Hi anacedent,

    there is no Operating System Virtualization involved on this system.

  4. #4
    Join Date
    Aug 2009
    Posts
    262
    possible solutions:
    - in listener.ora set DIRECT_HANDOFF_TTC_LISTENER=OF
    - If the logfile for the listener being to big, try to clear it, rename it ...
    - limit the maximum connections of each developer to a smaller number. It's a temporary solution.

    Starting TNS Listener gives "Linux Error: 32: Broken pipe"

    by Jeff Hunter, Sr. Database Administrator

    You have successfully install Oracle on Linux, installed and configured your application and everything is working fine. You get a call several months later from an angry user saying that he cannot login to the application. The error message indicates a problem connecting to the Oracle database. After noticing the Oracle TNS listener is not running, you attempt to start it and get the following stack trace error:

    % lsnrctl start

    LSNRCTL for Linux: Version 8.1.7.4.0 - Production on 18-JUL-2003 10:54:01

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

    Starting /u01/app/oracle/product/8.1.7/bin/tnslsnr: please wait...

    TNS-12547: TNS:lost contact
    TNS-12560: TNSrotocol adapter error
    TNS-00517: Lost contact
    Linux Error: 32: Broken pipe
    You then check with the SYS admin to only find out that nothing has changed with any of the network settings!
    This is one of those troubleshooting issues that can take several hours to track done. But as it turns out, the most common reason for this stack trace when attempting to start the listener is the log file for the listener ($ORACLE_HOME/network/log/listener.log) has reached its 2GB file size limit on Linux. To alleviate the problem, simply archive or delete the file and restart the listener.

  5. #5
    Join Date
    Jun 2010
    Posts
    2
    HI

    I have the same problem from with System Virtualization on hyper-V and Centos 5.5


    TNS-12518: TNS:listener could not hand off client connection
    TNS-12547: TNS:lost contact
    TNS-12560: TNSrotocol adapter error
    TNS-00517: Lost contact
    Linux Error: 32: Broken pipe

    The test with isql work fine by a direct name DB to sql server, but in the
    dblink appear error


    I need help please.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Linux Error: 32: Broken pipe
    Likely due to OS mis-configuration.
    Oracle is victim; not culprit
    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.

  7. #7
    Join Date
    Jun 2010
    Posts
    2
    HI

    The problem was solve installing patch of oracle 10.2.0.4.

    thanks by the observations!!!

Posting Permissions

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