Murali, Have you already covered the suggestions per Note# 171636.1? If these don't help then I suggest to log a TAR with OSS and work it from there...
HTH, -f ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 12:54 PM > > I apologise for the wrong error #...it was a typo on my part....the error # > is 12540 > > Here is the error stack.... > =============================================================== > 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 > 32-bit Windows Error: 8: Exec format error > =============================================================== > > Murali. > > > > > > |---------+----------------------------> > | | "Faan DeSwardt" | > | | <[EMAIL PROTECTED]| > | | et> | > | | Sent by: | > | | [EMAIL PROTECTED]| > | | .com | > | | | > | | | > | | 01/21/2004 03:09 | > | | PM | > | | Please respond to| > | | ORACLE-L | > | | | > |---------+----------------------------> > >--------------------------------------------------------------------------- -----------------------------------| > | | > | To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> | > | cc: | > | Subject: Re: ORA-12540: TNS: internal limit restriction exceeded | > >--------------------------------------------------------------------------- -----------------------------------| > > > > > Murali, > > Have you checked the OS event logs like the system log? Sounds like you > have hit an OS limit. Please post the rest of the error stack that > followed > the ORA-12450 as this gives more information on what is the root cause of > this failure? You can find this in the listener.log at the time of the > failure. > > -f > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 21, 2004 10:19 AM > > > > > > Hi All, > > > > We are running 9.2.0.4 on windoze 2000 server and this morning we were > > forced to restart the database server. Users complained about not able to > > connect to database... > > "TNS could not start dedicated server process"...So I tried to connect to > > db using OS authentication...(sqlplus "/ as sysdba") and ran into > > ORA-12540: TNS: internal limit restriction exceeded. > > > > Where is this limit set? Is it possible to change the setting? > > > > Here is some additional information.... > > > > The application that connects to this db is java based...In the past when > > we were seeing lot of 4030 errors in the alert log, we opened a case with > > oracle (this was when we were @ 9.2.03) [[ORA-04030: out of process > memory > > when trying to allocate 2097184 bytes (joxcx callheap,ioc_allocate ufree) > > ]] > > > > Oracle response to the TAR was that there were some memory leaks with > > executing java stored procedures and recommended applying the 9.2.0.4 > > patch...which we did ...It did not fix the issue. We have noticed that > > whenever there are many occurances of 4030 in the alert log users run > into > > "TNS could not start dedicated server process" and we are forced to > > restart. > > > > Your help in this matter is greatly appreciated. > > > > Thanks for your time > > > > Murali. > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > INET: Murali_Pavuloori/[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.net > -- > Author: Faan DeSwardt > 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.net > -- > Author: > INET: Murali_Pavuloori/[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.net -- Author: Faan DeSwardt 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).