Get more cutlery! Increase the number of processes available both system-wide and per capita.
> -----Original Message----- > From: paquette stephane [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 04, 2002 10:39 AM > To: Multiple recipients of list ORACLE-L > Subject: TNS-00510: Internal limit restriction exceeded > > > HI all > > We had those messages yesterday in the listener.log > file > 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 > > Also on the unix side, we had a message about the OS > that can not fork a new process. > > This is on 8172 32bits/AIX 4.3.3 > The sga is 1.7G, the server has 8G of ram. > There is between 150 and 300 users connected. > The init.ora process parameter is set to 425. The unix > number of process allowed is set to 500. > > I've check on metalink, but found nothing that we do > not already do. > > Any ideas ? > > Thanks > > ===== > St�phane Paquette > DBA Oracle, consultant entrep�t de donn�es > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___________________________________________________________ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en fran�ais ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
