Solution : https://service.sap.com/sap/support/notes/355776 (SAP Service marketplace login required)
Summary :
When installing Oracle patch sets such as 9.2.0.2 or 9.2.0.3 on databases with JVM or XDB options, users may encounter irreparable memory errors triggered by the catpatch.sql script if 'shared_pool_size' or 'java_pool_size' are inadequately set. Check and adjust these parameters via SQL*Plus to ensure they meet the minimum requirement of 150MB to prevent such issues. Prior to installation, review 'Patch Set Notes' and specific Java and XML DB requirements. Verify the presence of database options by querying the respective users and packages using SQL commands.
Key words :
sql> show parameter java_pool_sizesql> show parameter shared_pool_size identify installed database options', java upgradeukursache und voraussetzungenthe jvm option, oracle 9i release 2 rdbms patch set, oracle profile parameter 'shared_pool_size', object_name = 'dbms_java' correct/set parameters, database option xdb, sql upgrade script, sql> select count, oracle patch set, oracle patch set 9
Related Notes :
| 600915 | Linux/IA-64: Inst. FCS/CA 4.6C: Known problems |
| 540021 | Add. information on migrating/updating to Oracle 9.2.0: UNIX |
| 539921 | Current patch set for Oracle 9.2.0 |