Home » RDBMS Server » Server Administration » "ORA-12518: TNS:listener could not hand off client connection", fixed but...
"ORA-12518: TNS:listener could not hand off client connection", fixed but... [message #236661] Thu, 10 May 2007 10:36 Go to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
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 Go to previous messageGo to next message
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 ??
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 Go to previous message
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
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:
  


Current Time: Thu Dec 08 14:30:00 CST 2016

Total time taken to generate the page: 0.14243 seconds