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  |
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 |
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Feb 07 01:26:17 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
