Re: ORA-04033:Insufficent memory to grow pool(REF: Patchset 9.2.0.4)

"Hari Om" <hari_om_at_hotmail.com> wrote in message news:d1d5ebe4.0402020846.53f5fb55_at_posting.google.com...
> I was using Oracle 9.2.0.2 on IBM AIX 5.1L box.
>
> I am in midst of installing the Patchset 9.2.0.4 for this Database and
> installed the Oracle Universal Installer and Patchset included.
> Here is my Patch Information:
> ------------------------------------------------------------------
> PATCH: 3095277
> Description: Oracle Database Family: Patchset 9.2.0.4 PATCH SET FOR
> ORACLE DATABASE SERVER
> Release:9.2.0.4
> Updated: 05-SEP-2003
> SizeE: 719MB
> ------------------------------------------------------------------
>
> I was reading the README Document section "Post-Installation Tasks"
> and it said to CHANGE init.ora paramaters SHARED_POOL_SIZE and
> JAVA_POOL_SIZE to 150MB or else I woould get some memory failure
> error.
>
> My instance is using SPFILE and so I am trying to do above using
> "ALTER SYSTEM SET SHARED_POOL_SIZE=150000000 SCOPE=BOTH;" on which I
> get following error wonder why:
> --------------------------------------------------------------------
> ORA-02097:parameter cannot be modified because specified value is
> invalid
> ORA-04033:Insufficent memory to grow pool
> --------------------------------------------------------------------
>
> Can anyone please help/guide me on this or give any tips as to how to
> solve this problem?
>
> THANKS!
>
> HARI OM
You should set a proper sga_max_size and then bounce the instance.

Only then you would be able to increase the spa dynamically (with limit set by sga_max_size).

Anurag Received on Mon Feb 02 2004 - 11:08:04 CST