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

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?

-Siddharth Received on Fri Dec 13 2002 - 01:14:41 CST