Re: TNS-12531 listener trouble on Windows 2003

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Thu, 6 Jan 2011 16:40:24 -0800 (PST)
Message-ID: <c9d816d1-c691-427c-a840-28166262950c_at_g25g2000yqn.googlegroups.com>

On Jan 6, 12:57 pm, HansP <Hans-Peter.Sl..._at_atosorigin.com> wrote:
> This is happening at a 2 node windows 2003 rac with 96G ram (free ram
> about 70G)
> Release of grid infrastructure is 11.2
> Database 10.2.0.5.
>
> When too many users connect (little fewer than 150) all listeners
> report then 12531 error and become unresponsive afterwards
>
> Thu Jan 06 13:32:43 2011
> No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
> (HOST=x.x.x.x)(PORT=1521)))
> 06-JAN-2011 13:32:43 * service_died * LsnrAgt * 12537
> 06-JAN-2011 13:32:43 * 12531
> TNS-12531: TNS:cannot allocate memory
>
> lsnrctl status gives protocol adapter error
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)
> (KEY=LISTENER_SCAN2)))
> TNS-12560: TNS:protocol adapter error
>
> We  have increased the desktop heap size to 1M.
>
> Any clues or directions?

Why are you running RAC for a system with 150 connections?

Reboot the server ... lookup with Oracle support how to fix a TNS 12531 on your platform.

96 gig RAM on a windows 2003 server and you are having memory allocation problems? Something is seriously screwed up somewhere so start with the basic install instructions and double check everything ... Received on Thu Jan 06 2011 - 18:40:24 CST