Home » RDBMS Server » Server Utilities » ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD (11g, 11.2.0.3, Window server 2008)
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD [message #623354] |
Tue, 09 September 2014 03:59 |
ashishkumarmahanta80
Messages: 231 Registered: October 2006 Location: kolkatta
|
Senior Member |
|
|
Dear All,
I met an error while importing the dump into the database. Below is the error -
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-04067: not executed, package body "SYS.DBMS_METADATA" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_METADATA"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 62
ORA-06512: at "SYS.KUPW$WORKER", line 6226
I tried to import dump twice at the same server, after re-creation of database. Every time, occurred the same error.
After goggling, found that, might be dump would be having some problem (bug).
I have checked the expdp logfile and everything is fine.
Master table "SYSTEM"."SYS_EXPORT_FULL_02" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_02 is:
E:\DP_DIR_ABCDEMO\EXPDP_ABCDEMO_247_148_08092014.DMP
Job "SYSTEM"."SYS_EXPORT_FULL_02" successfully completed at 10:17:13
When I tried importing the same dump on other server, it imported successfully.
Now, I am confused about the dump. How can we check which dump is having correct one?
Please suggest....
Regards,
Ashish Kumar Mahanta
|
|
|
|
Re: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD [message #623373 is a reply to message #623362] |
Tue, 09 September 2014 06:56 |
ashishkumarmahanta80
Messages: 231 Registered: October 2006 Location: kolkatta
|
Senior Member |
|
|
Dear Michel,
Through googling, I had checked the result of below query.
select owner, object_type, status from dba_objects where object_name='DBMS_METADATA';
There were records available (SYS.DBMS_METADATA). I cannot post the result now as database was re-created again.
Below are the version available at export & import log file-
Export: Release 11.2.0.1.0 - Production on Mon Sep 8 09:57:18 2014
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
Starting "SYSTEM"."SYS_EXPORT_FULL_02": system/******** DUMPFILE=EXPDP_ABCDEMO_247_148_08092014.DMP LOGFILE=EXPDP_ABCDEMO_247_148_08092014.LOG DIRECTORY=DP_DIR EXCLUDE=STATISTICS FULL=Y
Estimate in progress using BLOCKS method...
;;;
Import: Release 11.2.0.1.0 - Production on Tue Sep 9 12:57:12 2014
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_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** dumpfile=EXPDP_ABCDEMO_247_148_08092014.DMP directory=dp_dir logfile=imp_ASHPRD.log SCHEMAS=ACCEXT,BATJOB,CLM,CMS,CNFG,CONFSYS,DMS,DW,DW_REP,GEN,HLTHCHK,INFS,INS,MIISMA,MULTCURR,RATEENG,REINS,RILOG,RNL,SUMMUSER,UW
Processing object type DATABASE_EXPORT/SCHEMA/USER
|
|
|
|
Goto Forum:
Current Time: Sun Sep 29 01:11:16 CDT 2024
|