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

"Henry" <henry_2303_at_hotmail.com> wrote in message news:<k73Da.121909$cK1.102755_at_news01.bloor.is.net.cable.rogers.com>...
> 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

Henry,

Please re-read the readme.htm for the patchset carefully. In that doc - it mentions that you must set the java_pool_size to a minimum value for the rebuild of the java machine to succeed - and it may mention a minimum size for the shared pool while rebuilding the dictionary.

In any event, there are several steps you need to perform while patching.
I prefer to use a separate init.ora file that has the following parameters set:
(this is all covered in detail in the readme.htm)

job_queue_processes=0
_system_trig_enabled=false

you also must pay attention to:

select * from duc$ where PACK='JIS$INTERCEPTOR$';

for applying the patchset 9.2.0.3 - the recommended pool sizes are 150 MB.

hth,

Paul Received on Tue Jun 03 2003 - 17:54:21 CDT