Home » RDBMS Server » Server Utilities » IMP-00017: following statement failed with ORACLE error 3113
IMP-00017: following statement failed with ORACLE error 3113 [message #274480] Tue, 16 October 2007 03:47 Go to next message
dragonsoftware
Messages: 4
Registered: October 2007
Location: Beijing
Junior Member

when I try to import the dump file into oracle 9.2.04 on ultra64 Sun solaris(5.Cool, the following error happen:
--------------------------------------------------------
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
IMP-00017: following statement failed with ORACLE error 3113:
"BEGIN "
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"
"N_CONTEXT_OBJ, 'SYS',TRUE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"
"N_CONTEXT_OBJ, 'DBA',TRUE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"
"N_CONTEXT_OBJ, 'AQ_ADMINISTRATOR_ROLE',TRUE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"
"N_CONTEXT_OBJ, 'MDSYS',TRUE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"
"N_CONTEXT_OBJ, 'CTXSYS',FALSE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO"
"N_CONTEXT_OBJ, 'WKSYS',FALSE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"
"ATION_CONTEXT, 'SYS',TRUE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"
"ATION_CONTEXT, 'DBA',TRUE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"
"ATION_CONTEXT, 'MDSYS',TRUE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"
"ATION_CONTEXT, 'CTXSYS',FALSE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU"
"ATION_CONTEXT, 'WKSYS',FALSE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_EVALUA"
"TION_CONTEXT, 'SYS',TRUE);"
""
"SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_EVALUA"
"TION_CONTEXT, 'DBA',TRUE);"
""
.............
IMP-00003: ORACLE error 3113 encountered

ORA-03113: end-of-file on communication channel

-------------------------------------

appreciate for any message.

Frank.
Re: IMP-00017: following statement failed with ORACLE error 3113 [message #274506 is a reply to message #274480] Tue, 16 October 2007 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Check alert.log and trace file.

Regards
Michel

[Updated on: Tue, 16 October 2007 04:41]

Report message to a moderator

Re: IMP-00017: following statement failed with ORACLE error 3113 [message #274983 is a reply to message #274506] Thu, 18 October 2007 00:53 Go to previous messageGo to next message
dragonsoftware
Messages: 4
Registered: October 2007
Location: Beijing
Junior Member

Thanks Michel.

I have solved it by myself.

I export the database by user, then import it into new instance.

It works.

Regards

Frank
Re: IMP-00017: following statement failed with ORACLE error 3113 [message #275014 is a reply to message #274983] Thu, 18 October 2007 02:13 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
That's a good workaround. Thanks.

Regards
Michel
Previous Topic: Dump File
Next Topic: Import with broken Export possible?
Goto Forum:
  


Current Time: Tue Dec 24 23:42:53 CST 2024