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

From: Harish Kalra <harish.kumar.kalra_at_gmail.com>
Date: Wed, 8 Mar 2006 16:35:31 +0530
Message-ID: <11ac22130603080305o6149fe60ha3bd7b0815f1f107@mail.gmail.com>

Amit:

Sometime it may happens if tcp/ip QUEUESIZE is small on OS level. I am not sure about linux OS parameter, which probably you can get from your system administrator.

For other OS, these parameters are :

Sun Solaris: tcp_conn_req_max_q (default 128) HP-UX: tcp_conn_req_max (default 20)
HP Tru64: somaxconn (default 1024)

Thanks
-Harish Kalra

On 3/7/06, Amit Verma <averma_at_umich.edu> wrote:
>
> I am getting the following errors during a loadtest with around 120
> users, 10gR2 on Linux X86 RedHat EE V3.
>
>
>
> TNS-12518: TNS:listener could not hand off client connection
>
> TNS-12547: TNS:lost contact
>
> TNS-12560: TNS:protocol adapter error
>
> TNS-00517: Lost contact
>
> Linux Error: 32: Broken pipe
>
>
>
> I tried Oracle's suggestion on enabling and disabling
> DIRECT_HANDOFF_TTC_LISTENER=on/off, but of no vail.
>
>
>
> Has anyone seen this error? Please chare your experiences, resolution.
>
>
>
> Amit Verma
> Senior Oracle DBA
> University of Michigan ITCS
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 08 2006 - 05:05:31 CST