| TNS-12518: TNS:listener could not hand off client connection [message #54886] |
Fri, 13 December 2002 03:21  |
siddharth
Messages: 16
Registered: May 2001
|
Junior Member |
|
|
Hi,
I am using oracle 9.2.0.1.0 on RH linux 7.3 server. I am running a shared server with usually about 200 concurrent sessions.
I keep getting the following error in my listener.log file
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
When this error comes the client application gives an odbc error and doesn't show any data.
When I do a 'lsnrctl services' I see refused connections from dispatchers.
"D003" established:8882 refused:17 current:61 max:16383 state:ready
DISPATCHER <machine: orac, pid: 31439>
(ADDRESS=(PROTOCOL=tcp)(HOST=orac)(PORT=34019))
"D002" established:8501 refused:8 current:62 max:16383 state:ready
DISPATCHER <machine: orac, pid: 31437>
(ADDRESS=(PROTOCOL=tcp)(HOST=orac)(PORT=34018))
"D001" established:8155 refused:5 current:61 max:16383 state:ready
DISPATCHER <machine: orac, pid: 31435>
(ADDRESS=(PROTOCOL=tcp)(HOST=orac)(PORT=34017))
"D000" established:8780 refused:9 current:60 max:16383 state:ready
DISPATCHER <machine: orac, pid: 31433>
(ADDRESS=(PROTOCOL=tcp)(HOST=orac)(PORT=34015))
If I restart the listener nothing changes. If I restart the database the problem doesn't come for a few hours but starts again after a few hours.
Any Suggestions?
Rgds.
Siddharth
|
|
|
|
|
|
| Re: TNS-12518: TNS:listener could not hand off client connection [message #54892 is a reply to message #54890] |
Fri, 13 December 2002 06:40  |
siddharth
Messages: 16
Registered: May 2001
|
Junior Member |
|
|
Hi Mahesh,
Thanks for the reply.
I checked with DIRECT_HANDOFF_TTC_LISTENER with both ON and OFF settings. There was no change. It looks like more of a problem with the dispatchers.
I had set the queuesize of dispatchers to 80 today. I recived this error just once till now. I will monitor it for another day to see if the problem comes.
I cant turn on tracing for listener because i dont know when the error will come. Tracing turned on whole time would be very heavy for the server
Rgds.
Siddharth
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
