TNS-12500: TNS:listener failed to start a dedicated server process
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