- Faan DeSwardt <faan_at_sbcglobal.net> wrote:
> 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
Been there, done that, with 8.1.7.3.x when large
memory support was not enabled. I think that you don't
have large memory support enabled in the operating
system. Scale back on your memory allocations, or
enable large memory support in the OS. Or add more
physical memory.
quote from that note:
"Enable dead connection detection to remove abnormally
disconnected Oracle processes."
Are they kidding? What actual software user wrote
that?
That is written by a technical writer that never
attempted to run DCD on anything windows. What release
of Oracle does dead connection detection ACTUALLY work
on - not supposed to work on but does not (I've
produced the network trace files in 9.2.0.4 and
watched DCD fly right by). I'm guessing 10g, in a
future patchset. I don't know, I don't have access to
10g yet.
if you have dead connections building up, kill them
with orakill.exe:
OS scheduled task
batch script
calls .sql script that
spools .bat script
logs killed sessions
executes .bat script that orakills the threads
use the utility pslist.exe from sysinternals.
schedule this in the OS to run every 15 minutes:
pslist -m oracle >> oracle_mem.log
and mail yourself the file daily via blat.
see how much memory (and virtual memory) is being
consumed.
Large memory support works great in 9.2.0.4. Migrate.
hth.
Pd
> ----- 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).
> >
>
=== message truncated ===
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Drake
INET: discgolfdba_at_yahoo.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 - 20:59:24 CST