Catpatch.sql Problem

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Sun, 16 Mar 2003 21:31:04 -0800
Message-ID: <3E755D98.4D7673A3@exxesolutions.com>

Finally I've got a problem I can't solve.

Just patched from 9.2.0.1.0 to 9.2.0.2 and now it is time to run catpatch.sql on a 500MB PIII running W2K. And here's the error message

DOC>#######################################################################

DOC>#######################################################################

DOC> The following statement may cause an
DOC> ORA-29554: unhandled Java out of memory condition
DOC> error, and thereby terminate the sqlplus connection.

DOC> If so, this is because there is insufficient system tablespace, DOC> shared or java pool size, or some other resource value is too small.

DOC> An additional message describing the problem will be output by
DOC> the statement.
DOC>#######################################################################

DOC>#######################################################################

DOC*/
BEGIN initjvmmaux.check_sizes_for_cjs; END;

*
ERROR at line 1:

ORA-29554: unhandled Java out of memory condition
ORA-06512 at "SYS.INITJVMAUX", line 167
ORA-06512 at line 1

And yes I've checked the google archives and yes I've run all over otn and tahiti and metalink. And I will tell you for free the information at metalink is so bad Oracle should hang its head in shame. Lots of statements about what the problem is ... not a single solution.

Ive done shutdown followed by startup migrate numerous times and it seems that no setting for the following:

java_pool_size=51200000
java_soft_sessionspace_limit=10240000

solves the problem. These are my current values.

Has anyone done this successfully and could you please post the init parameters that made it work. If not these ... which ones?

Thanks,

Daniel Morgan Received on Sun Mar 16 2003 - 23:31:04 CST