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

From: <shweta.kaparwan_at_googlemail.com>
Date: Thu, 8 Jan 2009 05:57:14 -0800 (PST)
Message-ID: <d39d16e4-6598-41ff-9170-8e0569e2c005_at_j39g2000yqn.googlegroups.com>



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. Received on Thu Jan 08 2009 - 07:57:14 CST

Original text of this message