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

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)
>
>
Received on Tue Jun 03 2003 - 12:04:27 CDT