Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-12540: TNS: internal limit restriction exceeded

Re: ORA-12540: TNS: internal limit restriction exceeded

From: Faan DeSwardt <faan_at_sbcglobal.net>
Date: Wed, 21 Jan 2004 18:14:25 -0800
Message-ID: <F001.005DDC9F.20040121181425@fatcity.com>


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" <ORACLE-L_at_fatcity.com> 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" |
> | | <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 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/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).
-- 
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).
Received on Wed Jan 21 2004 - 20:14:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US