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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 8 Jan 2009 06:33:17 -0800 (PST)
Message-ID: <ba48ef2a-c3c6-4690-9b89-8166f2d80996_at_r37g2000prr.googlegroups.com>

On Jan 8, 9:29 am, shweta.kapar..._at_googlemail.com wrote:
> On Jan 8, 1:59 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
>
>
>
>
>
> > 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- Hide quoted text -
>
> > - Show quoted text -
>
> Hi Steve
>
> We have 05 databases running in Host -A
>
> I have taken below o/p  from 1st database. We ra facing this issue in
> all the databases almost at the same time.
>
> SQL>select * from v$resource_limit;
>
> RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION
> INITIAL_AL  LIMIT_VALU
> ------------------------------ ------------------- ---------------
> ---------- ----------
> processes                                      135
> 256       1000       1000
> sessions                                       134
> 252       1105       1105
> enqueue_locks                                   72
> 361      14154      14154
> enqueue_resources                               72
> 72      50000  UNLIMITED
> ges_procs                                      133
> 253       1001       1001
> ges_ress                                     37791
> 50079      90367  UNLIMITED
> ges_locks                                    28140
> 42011      96306  UNLIMITED
> ges_cache_ress                                5361
> 8522          0  UNLIMITED
> ges_reg_msgs                                   222
> 250       2230  UNLIMITED
> ges_big_msgs                                    17
> 28       2230  UNLIMITED
> ges_rsv_msgs                                     0
> 0       1000       1000
> gcs_resources                                72634           81356
> 122432     122432
> gcs_shadows                                  26643
> 26663      67337      67337
> dml_locks                                        0
> 36       1024  UNLIMITED
> temporary_table_locks                            0               2
> UNLIMITED  UNLIMITED
> transactions                                    14
> 66       1215  UNLIMITED
> branches                                         2
> 28       1215  UNLIMITED
> cmtcallbk                                        4
> 29       1215  UNLIMITED
> sort_segment_locks                             134             137
> UNLIMITED  UNLIMITED
> max_rollback_segments                           11
> 11        244        244
> max_shared_servers                               1
> 1         20         20
> parallel_max_servers                             4
> 121        241        241
>
> 22 rows selected.
>
> Thanks.- Hide quoted text -
>
> - Show quoted text -

First check to make sure you are not running out of UNIX processes, unable to fork new process issue

Second, check the ulimit values for the Oracle owner and verify that Oracle has unlimited resources allowed

HTH -- Mark D Powell -- Received on Thu Jan 08 2009 - 08:33:17 CST