Troubleshooting - ORA-07445 / ORA-03113 During Full Database Export (Doc ID 421750.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Oracle RDBMS Server
***Checked for relevance on 22-Feb-2013***

Symptoms

Export fails with ORA-07445 errors, and export logs shows similar to the following.

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00000: Export terminated

ORA-07445 tracefile callstack contains java functions , and it may be similar to following

joe_debug_print_stack_trace_internal 
joe_debug_print_stack_trace_with_exception

The current sql that was failing shows the following.

SELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM2) SYNNAM2, DBMS_JAVA.LONGNAME(SYNTAB)   SYNTAB, TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, 
TABOWNID, SYNOBJNO   FROM SYS.EXU9PTS ORDER BY SYNTIME 

 

Its very likely to see these errors when we have invalid JVM / XDB in the database.  This note explains how to check and identify the problem component.

Changes

The full database export fails with ORA-03113 / ORA-07445, while exporting public synonyms.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms