Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TNS-12518: TNS:listener could not hand off client connection

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

From: <chabir_at_gmail.com>
Date: 1 Dec 2005 00:56:08 -0800
Message-ID: <1133427368.841124.304240@z14g2000cwz.googlegroups.com>


Hello,
I had the same problem like you but my database were in the shared server (9.2.0.6.0) mode. The problem were in a lack in large pool memory. Verify that the large pool is enough to hundle client connection and have a look on disptacher's trace files. Hope that helps.

Shailesh wrote:
> Hello,
>
> RDBMS Version:: 10.2.0.1.0
> Operating System and Version:: Windows 2000 SP4
> Client Operating System and Version:: Windows XP SP2
> Client Net Version:: 8.1.6/8.1.7
>
> Today we have observed following error.
>
> 30-NOV-2005 17:44:28 *
> (CONNECT_DATA=(SERVICE_NAME=qo762)(CID=(PROGRAM=D:\ITBMed4\i1W.exe)(HOST=PC-RUPALI-XP)(USER=rupali)))
> * (ADDRESS=(PROTOCOL=tcp)(HOST=10.83.3.67)(PORT=2180)) * establish *
> qo762 * 12518
> TNS-12518: TNS:listener could not hand off client connection
> TNS-12560: TNSrotocol adapter error
> TNS-00530: Protocol adapter error
> 32-bit Windows Error: 233: Unknown error
>
> We did set following parameter in listener.ora and restarted listener.
>
> DIRECT_HANDOFF_TTC_LISTENER=OFF
>
> But this workaround doesn't work. Can anyone help us please to solve
> this issue. It's urgent.
>
> Thanks & Regards,
>
> Shailesh
Received on Thu Dec 01 2005 - 02:56:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US