Re: TNS-12500: TNS:listener failed to start a dedicated server process

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 8 Jan 2009 05:59:30 -0800 (PST)
Message-ID: <80bfe5a3-6359-40ed-99f8-3710d2dbae35_at_r10g2000prf.googlegroups.com>

On Jan 8, 8:57 am, shweta.kapar..._at_googlemail.com wrote:
> Hi All
>
> We are badly being hit by the following error:
>
> 08-JAN-2009 12:43:05 * (connect_data=(server=dedicated)
> (service_name=XX)(INSTANCE_ROLE=primary)(failover_mode=(type=session)
> (method=basic)(backup=YY)(retries=180)(delay=5))(CID=(PROGRAM=oracle)
> (HOST=ZZ)(USER=oracle))(INSTANCE_NAME=AAAA)) * (ADDRESS=(PROTOCOL=tcp)
> (HOST=<IP>)(PORT=<PORT>)) * establish * BB * 12500
> TNS-12500: TNS:listener failed to start a dedicated server process
>  TNS-12540: TNS:internal limit restriction exceeded
>   TNS-12560: TNS:protocol adapter error
>    TNS-00510: Internal limit restriction exceeded
>     HPUX Error: 11: Resource temporarily unavailable
>
> This is repeating at the following interval. ( as a sample.).. It is
> intermittent.
>
> Start                    End
> 08/01/2009 12:40:03     08/01/2009 12:40:13
> 08/01/2009 12:41:03     08/01/2009 12:41:04
> 08/01/2009 12:42:04     08/01/2009 12:42:04
> 08/01/2009 12:43:04     08/01/2009 12:43:04
> 08/01/2009 12:43:05     08/01/2009 12:43:05
>
> In between above intervals connections are successful
>
> We are using "dedicated Server" connection.
>
> CPU /Mem utlisation is normal. No change seen in the pattern.
>
> Regards
>
> Shweta.

Hi Shweta,

How do your OS kernel parameter limits look, i.e. open files, max processes, etc.?

Regards,

Steve Received on Thu Jan 08 2009 - 07:59:30 CST