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

From: David Jakubowski <jakubowski_at_brutele.be>
Date: 29 Jun 2004 08:12:53 -0700
Message-ID: <748b935a.0406290712.1199b2cb@posting.google.com>

Hello all,

Running Oracle 9.2 on a Solaris machine, I get the below error nearly each day.

Restarting the oracle listener helps, else after a while we are getting TNS-12518: TNS:listener could not hand off client connection errors. So new connections are either hard or impossible to get.

This is part of the listening trace.

...

nttgetport: port resolved to 59357
nttbnd2addr: looking up IP addr for host: charxxxxx.xxx ntus2err: sd=113, op=14, resnt[0]=507, resnt[1]=0, resnt[2]=0 nsbequeath: error reading REDIR/NSE msg
nserror: nsres: id=101, op=72, ns=12560, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0
nstimarmed: no timer allocated
nsclose: closing transport
...

listener.log

29-JUN-2004 11:08:11 *
(CONNECT_DATA=(SID=imx)(CID=(PROGRAM=)(HOST=haxxx)(USER=a pache))) * (ADDRESS=(PROTOCOL=tcp)(HOST=194.x.x.x)(PORT=44829)) * establish

imx * 12518 TNS-12518: TNS:listener could not hand off client connection TNS-12560: TNS:protocol adapter error

...

The number of registered connections is raising all the time after some time.

nsevwait: entry
nsevwait: 663 registered connection(s)
nsevwait: 0 pre-posted event(s)
nsevwait: waiting for transport event (1 thru 664)...
nsevwait: 1 newly-posted event(s)
nsevfnt: cxd: 0x1430b10 stage 4: NT events set:
        WRITE

nsevfnt: cxd: 0x1430b10 stage 4: NS events set:
        OUTGOING CALL COMPLETE

....

Any ideas ?

David. Received on Tue Jun 29 2004 - 10:12:53 CDT