Home » RDBMS Server » Server Utilities » Job "SYSTEM"."SYS_IMPORT_SCHEMA_05" stopped due to fatal error (11gr2, 11.2.0, windows server 2008)
Job "SYSTEM"."SYS_IMPORT_SCHEMA_05" stopped due to fatal error [message #585589] Tue, 28 May 2013 02:26 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

When I tried to import the dump, which was taken through 10.2.0.4 database, below error occurred.
As suggested on the site, i tried to include EXCLUDE=STATISTICS but impdp throw error as - "parameter does not support".


Below are the error -

Import: Release 11.2.0.1.0 - Production on Mon May 27 16:03:09 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_05" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_05":  system/******** dumpfile=EXPDP_UICTST3_38_150_150_270513.DMP 
directory=dp_dir logfile=impDP_UICTST3_38_150_150_270513.log SCHEMAS=MS,DMS,ACC,UW,DW,DW_REP,ANALYSTADMIN,INTADM,INS,CONFREP,GEN,CNFG,REINS,TACREP,SUMMUSER,CONFSYS,
BA,BI,TAC,CMS,REPRES,BATJOB,CLM,RNL,rateeng,accext,MIISMA 
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [PROCACT_SCHEMA:"GEN"] 
ORA-06502: PL/SQL: numeric or value error
LPX-00229: input source is empty
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8165
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
000007FF7F20B9E8     18990  package body SYS.KUPW$WORKER
000007FF7F20B9E8      8192  package body SYS.KUPW$WORKER
000007FF7F20B9E8     15575  package body SYS.KUPW$WORKER
000007FF7F20B9E8      3945  package body SYS.KUPW$WORKER
000007FF7F20B9E8      8875  package body SYS.KUPW$WORKER
000007FF7F20B9E8      1649  package body SYS.KUPW$WORKER
000007FF700F0FF8         2  anonymous block
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [PROCACT_SCHEMA:"GEN"] 
ORA-06502: PL/SQL: numeric or value error
LPX-00229: input source is empty
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8165
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
000007FF7F20B9E8     18990  package body SYS.KUPW$WORKER
000007FF7F20B9E8      8192  package body SYS.KUPW$WORKER
000007FF7F20B9E8     15575  package body SYS.KUPW$WORKER
000007FF7F20B9E8      3945  package body SYS.KUPW$WORKER
000007FF7F20B9E8      8875  package body SYS.KUPW$WORKER
000007FF7F20B9E8      1649  package body SYS.KUPW$WORKER
000007FF700F0FF8         2  anonymous block
Job "SYSTEM"."SYS_IMPORT_SCHEMA_05" stopped due to fatal error at 16:04:02


Today, through same scheduled dump, i can able to import without any error. Steps are same as i had done yesterday.

Unable to understand, what could be the reason behind it.

Kindly help me out to understand the reason of it.

Regards,
Ishika

[Updated on: Tue, 28 May 2013 04:33] by Moderator

Report message to a moderator

Re: Job "SYSTEM"."SYS_IMPORT_SCHEMA_05" stopped due to fatal error [message #585597 is a reply to message #585589] Tue, 28 May 2013 03:41 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel, John, littlefoot and All Gurus,

Kindly suggest on the same.
Waiting for your kind response...

Regards,
Ishika
Re: Job "SYSTEM"."SYS_IMPORT_SCHEMA_05" stopped due to fatal error [message #585603 is a reply to message #585597] Tue, 28 May 2013 04:35 Go to previous message
Michel Cadot
Messages: 60044
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i tried to include EXCLUDE=STATISTICS but impdp throw error as - "parameter does not support".


I often use it and have no problem.
Copy and paste what you did and got when you have this error.

Regards
Michel
Previous Topic: Estimate FlatFile Size
Next Topic: Fatal error in data pump import
Goto Forum:
  


Current Time: Wed Dec 24 19:41:42 CST 2014

Total time taken to generate the page: 0.12849 seconds