Switch on the listener trace ! see why the handoff is failing
"Siddharth" <siddharthbahri_at_yahoo.com> wrote in message
news:fede6a7c.0212122314.17a50fb0_at_posting.google.com...
> 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 - 06:26:44 CST
