Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.telusplanet.net!newsfeed.telus.net!news3.optonline.net!cyclone.rdc-nyc.rr.com!news.maxwell.syr.edu!postnews1.google.com!not-for-mail From: hari_om@hotmail.com (Hari Om) Newsgroups: comp.databases.oracle.server Subject: ORA-04033:Insufficent memory to grow pool(REF: Patchset 9.2.0.4) Date: 2 Feb 2004 08:46:36 -0800 Organization: http://groups.google.com Lines: 34 Message-ID: NNTP-Posting-Host: 168.179.100.240 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1075740396 3760 127.0.0.1 (2 Feb 2004 16:46:36 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 2 Feb 2004 16:46:36 +0000 (UTC) Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:253476 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