Home » RDBMS Server » Server Utilities » Two Error: IMP-00017 ORA-03113 when imported a dmp file to oracle (Oracle 10g )
Two Error: IMP-00017 ORA-03113 when imported a dmp file to oracle [message #528755] Wed, 26 October 2011 21:53 Go to next message
yjiyuan
Messages: 3
Registered: October 2011
Junior Member
There is an error when I imported a dmp file to Oralce, And the google might not help, would you give me some advices.

The version of Oracle:
Destination oracle: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit for linux.
Source oracle: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production for linux.
Imp client: Oracle Database 10.2.0.3.0 32bit for win7

The imp statement:
imp userid=system/oracle@test full=n fromuser=Rm touser=Rm file=E:\test-10-11\test2-10-11.DMP log=rm.log buffer=5400000

The error is:
IMP-00017 "ALTER PACKAGE "PKG_XXX"COMPILE REUSE SETTINGS TIMESTAMP'2010-12-31:18:06:""13"
IMP-00003
ORA-03113
IMP-00000

And I successfully imported the dmp file into the other PC, the version is Oracle Enterprise 10.2.0.1.0 32 bit for linux.

Thanks.
Re: Two Error: IMP-00017 ORA-03113 when imported a dmp file to oracle [message #528756 is a reply to message #528755] Wed, 26 October 2011 22:11 Go to previous messageGo to next message
BlackSwan
Messages: 26656
Registered: January 2009
Location: SoCal
Senior Member
00017, 00000, "following statement failed with ORACLE error %lu:"
// *Cause:  Import failed to execute the statement from the export file 
//          because of an Oracle error. 
// *Action: Look up the accompanying Oracle message in the ORA message 
//          chapters of this manual and take appropriate action. ]


ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
additional clues may exist in alert_SID.log file
Re: Two Error: IMP-00017 ORA-03113 when imported a dmp file to oracle [message #528775 is a reply to message #528755] Thu, 27 October 2011 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 66851
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-03113


ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.

Regards
Michel
Re: Two Error: IMP-00017 ORA-03113 when imported a dmp file to oracle [message #528782 is a reply to message #528756] Thu, 27 October 2011 02:02 Go to previous messageGo to next message
yjiyuan
Messages: 3
Registered: October 2011
Junior Member
Thank you.
i read the alter log, and found an error: ORA-07445: exception encountered: core dump [ptmak()+191] [SIGSEGV] [Address not mapped to object] [0x000000010] [] [].
Re: Two Error: IMP-00017 ORA-03113 when imported a dmp file to oracle [message #528784 is a reply to message #528782] Thu, 27 October 2011 02:27 Go to previous messageGo to next message
Michel Cadot
Messages: 66851
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can read this article: Troubleshooting Internal Errors.

Regards
Michel

Re: Two Error: IMP-00017 ORA-03113 when imported a dmp file to oracle [message #529787 is a reply to message #528784] Thu, 03 November 2011 01:28 Go to previous message
yjiyuan
Messages: 3
Registered: October 2011
Junior Member
Thank you, Michel.
The article is very usefull for me.
Previous Topic: Load multiple tables from SQL* Loader
Next Topic: EXP-00078, EXP-00008, ORA-20000, ORA-06512
Goto Forum:
  


Current Time: Wed Feb 19 13:41:47 CST 2020