RE: rman failure ORA-04030 indicates memory issue
- From: "Joel Garry" <joelgarry@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 6 Oct 2004 09:49:43 -0700
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
