Re: listener could not hand off
From: gazzag <gareth_at_jamms.org>
Date: Fri, 11 Jan 2008 02:15:14 -0800 (PST)
Message-ID: <d4b0bc9e-7f88-4f55-873c-7258c27a3a1f@v67g2000hse.googlegroups.com>
Date: Fri, 11 Jan 2008 02:15:14 -0800 (PST)
Message-ID: <d4b0bc9e-7f88-4f55-873c-7258c27a3a1f@v67g2000hse.googlegroups.com>
On 10 Jan, 20:51, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> I have 10.2.0.3 on w2003
> After some times (about one business day)
> we get the following errors
> ORA-12518 listener could not hand off
> I tried :
> DIRECT_HANDOFF_TTC_<LISTENER-NAME>=OFF
> increase PROCESSES
> with no success.
>
> What can I do ?
> Thanks in advance
This tends to be a memory problem under Windows. Are you using the / 3GB and /PAE switches in your boot.ini? How big is your SGA/PGA? How much RAM is on the server?
Lowering your SGA and/or PGA should help.
HTH -g Received on Fri Jan 11 2008 - 04:15:14 CST