Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-12540: TNS: internal limit restriction exceeded
I apologise for the wrong error #...it was a typo on my part....the error # is 12540
Here is the error stack....
Murali.
|---------+---------------------------->
| | "Faan DeSwardt" |
| | <faan_at_sbcglobal.n|
| | et> |
| | Sent by: |
| | ml-errors_at_fatcity|
| | .com |
| | |
| | |
| | 01/21/2004 03:09 |
| | PM |
| | Please respond to|
| | ORACLE-L |
| | |
|---------+----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> | | 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" <ORACLE-L_at_fatcity.com>
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 processmemory
> 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 runinto
> "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/Claritas_at_claritas.com > > 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: ListGuru_at_fatcity.com (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: faan_at_sbcglobal.net 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: ListGuru_at_fatcity.com (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/Claritas_at_claritas.com 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: ListGuru_at_fatcity.com (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).Received on Wed Jan 21 2004 - 14:54:27 CST