OraFAQ Forum: Server Administration » "ORA-12518: TNS:listener could not hand off client connection", fixed but...

Home » RDBMS Server » Server Administration » "ORA-12518: TNS:listener could not hand off client connection", fixed but...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"ORA-12518: TNS:listener could not hand off client connection", fixed but... [message #236661]

Thu, 10 May 2007 10:36

smundaye
Messages: 4
Registered: May 2007
Location: mumbai

Junior Member

Hello oracle experts,

We have dedicated oracle 10g server running on win2k server, 3gb m/c, which suddenly started throwing ORA-12518, after no. of connections reached ~100. I tried increasing sga memory, sessions, processes, open_cursors, but to no success.
But when I reduced sga memory from 1.1gb to 0.8gb, it allowed connections upto 225, before throwing ORA-12518. Now I am wondering what sga memory has to do with connections ??? and that too after decreasing sga memory it allows more connections.

The server machine has almost 2gb free memory, hence there is no problem of memory allocation. Someone please solve my doubt.

Thanks in advance,
sameer

Report message to a moderator

Re: "ORA-12518: TNS:listener could not hand off client connection", fixed but... [message #236663 is a reply to message #236661]

Thu, 10 May 2007 10:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

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.

Report message to a moderator

Re: "ORA-12518: TNS:listener could not hand off client connection", fixed but... [message #236866 is a reply to message #236663]

Fri, 11 May 2007 03:17

smundaye
Messages: 4
Registered: May 2007
Location: mumbai

Junior Member

yes. i tried configuring direct handoff too. But it couldnt solve my problem. I turned on listener tracing, and saw its trace file, which was printing lot of line, which I could hardly understand. It was print "error 233" lot of time. I searched on the net but found no relevant info. If you want I can post trace file in this thread.
But still my question remains is why decreasing SGA memory has increased no. of connections ??

Report message to a moderator

Re: "ORA-12518: TNS:listener could not hand off client connection", fixed but... [message #237231 is a reply to message #236866]

Sun, 13 May 2007 11:13

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
If you have metalink support then please take a look
Note: 340089.1

Regards
Taj

Report message to a moderator

Previous Topic:	Date and time of last table access
Next Topic:	HELP PELASE!! Have this error creating a table ORA-00604 and ORA-29540

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 17:06:55 CST 2025