Import Fails With Errors IMP-00017 And ORA-3113 (Doc ID 796341.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

On newly created system when attempting to import a database from the primary system (also 10g) to compile the application the following errors are raised:

#> imp system/passwd full=y constraints=no logfile=svprodlog.log file=/backup/export/xxxxx.dmp

IMP-00017: following statement failed with ORACLE error 3113:
"BEGIN "
"DECLARE"
" TJP DBMS_JVM_EXP_PERMS.TEMP_JAVA_POLICY;"
" CURSOR C1 IS SELECT KIND,GRANTEE,TYPE_SCHEMA,TYPE_NAME,"
" NAME,ACTION,ENABLED FROM TEMP_JAVA_PRIVS;"
"BEGIN"
" OPEN C1;"
" FETCH C1 BULK COLLECT INTO TJP;"
" CLOSE C1;"
" DBMS_JVM_EXP_PERMS.IMPORT_JVM_PERMS(TJP);"
" EXECUTE IMMEDIATE('DROP TABLE TEMP_JAVA_PRIVS');"
"END;"
"COMMIT; END;"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully

Changes

Performed an upgrade recently.

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