OraFAQ Forum: Server Utilities » IMP-00017: following statement failed with ORACLE error 3113

Home » RDBMS Server » Server Utilities » IMP-00017: following statement failed with ORACLE error 3113

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP-00017: following statement failed with ORACLE error 3113 [message #274480]

Tue, 16 October 2007 03:47

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.

Report message to a moderator

Re: IMP-00017: following statement failed with ORACLE error 3113 [message #274506 is a reply to message #274480]

Tue, 16 October 2007 04:41

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Report message to a moderator

Re: IMP-00017: following statement failed with ORACLE error 3113 [message #275014 is a reply to message #274983]

Thu, 18 October 2007 02:13

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

That's a good workaround. Thanks.

Regards
Michel

Report message to a moderator

Previous Topic:	Dump File
Next Topic:	Import with broken Export possible?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 23 13:57:57 CDT 2024