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: rman failure ORA-04030 indicates memory issue

RE: rman failure ORA-04030 indicates memory issue

From: Joel Garry <joelgarry_at_anabolicinc.com>
Date: Wed, 6 Oct 2004 09:49:43 -0700
Message-ID: <FF740DD879899E418DE668EE8B6A201FADF5@lf-mail.anabolic.inc>

> ORA-12540: TNS:internal limit restriction exceeded

You can also get TNS 12540 as a result of too many processes. I would guess what may be happening is all those aborted RMAN jobs are hanging onto processes, hence everything is better after bouncing db. Perhaps you should try upping both the unix and init.ora processes settings to push the problem back. No reason not to if you aren't even close to actual swapping. And take a close look at your listeners. I can't recall if Solaris has swapinfo -a. netstat -a |grep WAIT might be interesting, too, there might be a very long timeout on the extraneous connections.

Joel =
Garry=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0
http://www.garry.to=20
=A0

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 06 2004 - 11:45:18 CDT

Original text of this message

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