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

Home -> Community -> Usenet -> c.d.o.server -> Re: Please help - ORA 04030: out of process memory...

Re: Please help - ORA 04030: out of process memory...

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 03 Jun 2003 12:35:27 -0700
Message-ID: <3EDCF87F.7E16F914@exxesolutions.com>


Henry wrote:

> Hi,
>
> Thanks for your advise. The vendor of the application is also Oracle and the
> today certified version for the application is 8.1.7.2.1.
> Also I dont care about my resume at the moment :)
>
> I wonder if you/anyone have similar experience with this version if this a
> known problem on this version. The strange is that I succesfully installed
> the same thing at the client (may be on more powerfull machine) and did not
> have the problem.
>
> Thanks,
>
> Henry
>
> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3EDCC834.189CAA30_at_exxesolutions.com...
> > Henry wrote:
> >
> > > Hi,
> > >
> > > I'm getting this error (ORA 04030: out of process memory...) when I
> tried to
> > > upgrade existing 8.1.7 database to 8.1.7.2.1 and also when I tried to
> create
> > > new instance after I upgraded the server the server to 8.1.7.2.1.
> > >
> > > In the upgrade if fails during the catproc.sql. Few objects were invalid
> > > after the script but I was able to recompile/rebuild most of them.
> > > The one remained invalid - SYS.DBMS_PRVTAQIS. I have got the ORA 04030
> again
> > > when i tried to run prvtaquis.plb to recreate this package
> individualy...
> > >
> > > During the new instance creation with database assistant I got the same
> > > error when addind plsql support - so it probably related to the same
> problem
> > > as in the first case...
> > >
> > > I tried to patch the server to 8.1.7.2.7 but it did not helped for this
> > > case.
> > >
> > > I'm running Win 2000 on Pentium III 600MHz with 384MB Ram and the
> pagefile
> > > growed to 1.6GB during this steps.
> > > I tried to install the same thing Pentium IV with 512MB RAM but same
> > > thing... so it does not seem to be a lack of resources but rather some
> leak
> > > in Oracle...
> > >
> > > I'm thinking to to try higher version of Oracle but Application we are
> using
> > > is certified to 8.1.7.2 so I would rather avoid that.
> > >
> > > Does anyone has similar experience or have any suggestions how to
> proceed ?
> > >
> > > Thanks a lot,
> > > Henry
> >
> > The current release of 8i is 8.1.7.4. There is a reason why it is .4
> rather than
> > .2. Then
> > set compatible in the init.ora to 8.1.7.2 if you must. But I'd sack the
> vendor
> > if they can't
> > stay reasonably currentl with Oracle. 8i will begin the desupport process
> at the
> > end of this year.
> > And you, and your resume, will be at least 8 releases behind what will be
> > current.
> >
> > Patch to the current version.
> > --
> > Daniel Morgan
> > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > damorgan_at_x.washington.edu
> > (replace 'x' with a 'u' to reply)
> >
> >

Follow Sybrand's advice but I'd be really interested in knowing what product Oracle is selling that is only certified on a soon to be unsupported database. Please provide the name and version number.

Thanks.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Jun 03 2003 - 14:35:27 CDT

Original text of this message

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