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 Go to next message
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 #623362 is a reply to message #623354] Tue, 09 September 2014 05:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post:
- expdp command line and parameters
- impdp command line and parameters
- On source:
select * from v$version;
- On target
select * from v$version;
select owner, object_type, status from dba_objects where object_name='DBMS_METADATA';

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 Go to previous messageGo to next message
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
Re: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD [message #623374 is a reply to message #623373] Tue, 09 September 2014 07:15 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I cannot post the result now as database was re-created again.


So update when it will be online and you'll can test.
Let us know if it the import succeeds or not.

Previous Topic: data pump
Next Topic: expdp fail with ORA-39125 ORA-31642 ORA-06512 ORA-21780
Goto Forum:
  


Current Time: Thu Mar 28 17:54:34 CDT 2024