ORA-12540: TNS: internal limit restriction exceeded

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).