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

It is Oracle TMS (Thesarus Management System) v4.0.6 also with Oracle Clinical 4.0.3.
Theis nurrent certified version for Windows platform is 8.1.7.2.1.

In the next release of these application (it did not come out yet) they will probably jump directly to 9i but also as Sybrand said they (Oracle) will probably support vurrent versions of those applications on 8i for some period even beyond the life of 8i.
And I believe there will be customers who will be using it even after that since their lifcycle will probably be always behind the database server..

Regards,
Henry

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3EDCF87F.7E16F914_at_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 Wed Jun 04 2003 - 11:12:12 CDT