9i升级到11gR2中报java，ORA-03113,ORA-03114的错误解决方法

秋风No.1 发表于 2011-12-23 03:47

从9i升级数据库到11gR2，在upgrade的过程中，报下面的错误导致升级暂停 SQL> -- Verify that a simple java stored procedure works 
SQL> select dbms_java.longname('foo') from dual; 
select dbms_java.longname('foo') from dual 
* 
ERROR at line 1: 
ORA-03113: end-of-file on communication channel 
ERROR: 
ORA-03114: not connected to ORACLE 通过查询MOS，解决方法如下： <table border="0" cellpadding="0" cellspacing="6" width="100%"><tbody><tr><td colspan="6" align="left" valign="TOP">ORA-29553: class in use error on 9.2 to 11.2 Migration </td>
</tr>
<tr>
 <td colspan="6" align="left" valign="TOP"></td>
</tr> <tr>
 <td colspan="2" valign="TOP" width="25%"> </td>
 <td colspan="3" nowrap="nowrap" valign="TOP" width="50%">修改时间 15-JUN-2011     类型 PROBLEM     状态 MODERATED</td>
 <td valign="TOP"> </td>
</tr>
</tbody></table>

In this Document 
  <a href="https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1225653.1&addClickInfo=%3Cdata%20search_text=%22java%20longname%20ora-03113%22%20search_result_size=%226%22%20search_result_count=%226%22%20powerview_id=%22%22%20on_off=%22off%22%20item_position_in_list=%221%22/%3E#SYMPTOM" target="_blank">Symptoms</a> 
  <a href="https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1225653.1&addClickInfo=%3Cdata%20search_text=%22java%20longname%20ora-03113%22%20search_result_size=%226%22%20search_result_count=%226%22%20powerview_id=%22%22%20on_off=%22off%22%20item_position_in_list=%221%22/%3E#CAUSE" target="_blank">Cause</a> 
  <a href="https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1225653.1&addClickInfo=%3Cdata%20search_text=%22java%20longname%20ora-03113%22%20search_result_size=%226%22%20search_result_count=%226%22%20powerview_id=%22%22%20on_off=%22off%22%20item_position_in_list=%221%22/%3E#FIX" target="_blank">Solution</a> 
  <a href="https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1225653.1&addClickInfo=%3Cdata%20search_text=%22java%20longname%20ora-03113%22%20search_result_size=%226%22%20search_result_count=%226%22%20powerview_id=%22%22%20on_off=%22off%22%20item_position_in_list=%221%22/%3E#REF" target="_blank">References</a> 



<table align="center" border="1" cellpadding="4" cellspacing="0">
 <tbody>
 <tr>
 <td>This document is being delivered to
you via Oracle Support's Rapid Visibility (RaV) process and therefore
has not been subject to an independent technical review.</td>
 </tr>
 </tbody>
</table>


Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later    Information in this document applies to any platform. 

<a name="SYMPTOM"></a>Symptoms
When doing a migration from database version 9.2 to version 11.2. the following issues are seen:

1) Catupgrd.sql fails with following error: SQL> -- Verify that a simple java stored procedure works SQL> select dbms_java.longname('foo') from dual; select dbms_java.longname('foo') from dual * ERROR at line 1: ORA-03113: end-of-file on communication channel 2) Associated error in alertlog is: ORA-07445: exception encountered: core dump 
<a name="CAUSE"></a>Cause
This error actually stems from earlier in the catupgrd.sql output
when the JVM was not loaded correctly due to ORA-29553: class in use. SQL> SQL> -- Load all the Java classes SQL> begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then 2 initjvmaux.rollbacksetup; 3 commit; 4 initjvmaux.rollbackset; 5 initjvmaux.exec('create or replace java system'); 6 commit; 7 initjvmaux.rollbackcleanup; 8 initjvmaux.endstep; 9 end if; end; 10 / begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then * ERROR at line 1: ORA-29553: class in use: SYS.javax/jms/TemporaryTopic ORA-06512: at "SYS.INITJVMAUX", line 23 ORA-06512: at line 5 Note: The class named in the Ora-29553 error can be different than shown in this example.

This is result of unpublished  <a href="https://support.oracle.com/CSP/main/article?cmd=show&type=BUG&id=10165223" target="_blank">Bug 10165223</a>. 
It can occur when more than one heap manager subpool is in use, and
Java class objects can potentially remain heap-manager pinned leading to
the ORA-29553.
<a name="FIX"></a>Solution
Request a one off patch for bug or the following workarounds are available. For manual migrations from 9.2 to 11.2: - Use a SGA size less than 1GB. 

OR - Set hidden parameter '_kghdsidx_count' to 1 in parameter
file. This sets use of 1 subpool and can be removed after migration is
complete. For migrations using DBUA from 9.2 to 11.2: - Use a SGA size less than 1GB.

页: [1]

Chinaunix's Archiver

9i升级到11gR2中报java，ORA-03113,ORA-03114的错误解决方法