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

From: Hari Om <hari_om_at_hotmail.com>
Date: 2 Feb 2004 08:46:36 -0800
Message-ID: <d1d5ebe4.0402020846.53f5fb55@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 Received on Mon Feb 02 2004 - 10:46:36 CST