Skip to Main Content
  • Questions
  • datapump export - ORA-39126 / ORA-12838

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Jayeeta.

Asked: July 08, 2016 - 12:15 pm UTC

Last updated: July 15, 2016 - 1:21 am UTC

Version: 11.2.0.4

Viewed 10K+ times! This question is

You Asked

HTP0#>expdp system/***** full=y DIRECTORY=data_pump_dir4bos dumpfile=EZTAG_UiAT.dmp logfile=myfullexp.log job_name=eztag_uat_ex5

Export: Release 11.2.0.4.0 - Production on Fri Jul 8 06:46:18 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting "SYSTEM"."EZTAG_UAT_EX5": system/******** full=y DIRECTORY=data_pump_dir4bos dumpfile=EZTAG_UiAT.dmp logfile=myfullexp.log job_name=eztag_uat_ex5
Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-12838: cannot read/modify an object after modifying it in parallel

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 9710

----- PL/SQL Call Stack -----
object line object
handle number name
6eaf03398 21979 package body SYS.KUPW$WORKER
6eaf03398 9742 package body SYS.KUPW$WORKER
6eaf03398 11838 package body SYS.KUPW$WORKER
6eaf03398 14674 package body SYS.KUPW$WORKER
6eaf03398 2734 package body SYS.KUPW$WORKER
6eaf03398 10422 package body SYS.KUPW$WORKER
6eaf03398 1824 package body SYS.KUPW$WORKER
6ef10a760 2 anonymous block

Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-12838: cannot read/modify an object after modifying it in parallel

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 9710

----- PL/SQL Call Stack -----
object line object
handle number name
6eaf03398 21979 package body SYS.KUPW$WORKER
6eaf03398 9742 package body SYS.KUPW$WORKER
6eaf03398 11838 package body SYS.KUPW$WORKER
6eaf03398 14674 package body SYS.KUPW$WORKER
6eaf03398 2734 package body SYS.KUPW$WORKER
6eaf03398 10422 package body SYS.KUPW$WORKER
6eaf03398 1824 package body SYS.KUPW$WORKER
6ef10a760 2 anonymous block

Job "SYSTEM"."EZTAG_UAT_EX5" stopped due to fatal error at Fri Jul 8 06:47:07 2016 elapsed 0 00:00:42


and Connor said...

That looks like either

(a) a bug, or
(b) something has been wrongly configured on your database.

I have to admit, I'm leaning toward (b) only because I just tested a full dump on my 11.2.0.4 system and had no errors.

The "ORA-12838: cannot read/modify an object after modifying it in parallel" suggests that something is perhaps forcing a parallel DML when it should not be.

So before logging a call with Support, double check you've got no init.ora parameters or login triggers etc, that are turning any serial operations into parallel when they shouldnt be.

If you're *absolutely* sure nothing is doing that, then get in touch with Support.

Export: Release 11.2.0.4.0 - Production on Sat Jul 9 10:09:06 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "MCDONAC"."EZTAG_UAT_EX5":  mcdonac/******** full=y DIRECTORY=temp dumpfile=db11.dmp logfile=myfullexp.log job_name=eztag_uat_ex5
Estimate in progress using BLOCKS method...

...

Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
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/RESOURCE_COST
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK

...

. . exported "SYSTEM"."REPCAT$_RUNTIME_PARMS"                0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_SITES_NEW"                    0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_SITE_OBJECTS"                 0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_SNAPGROUP"                    0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"             0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS"               0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS"           0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES"               0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS"             0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"          0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES"             0 KB       0 rows
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB       0 rows
Master table "MCDONAC"."EZTAG_UAT_EX5" successfully loaded/unloaded
******************************************************************************
Dump file set for MCDONAC.EZTAG_UAT_EX5 is:
  C:\TEMP\DB11.DMP
Job "MCDONAC"."EZTAG_UAT_EX5" completed with 1 error(s) at Sat Jul 9 10:11:35 2016 elapsed 0 00:02:24




Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

need further assitance

Jayeeta Sarkar, July 14, 2016 - 7:59 pm UTC

Support has been of no help.

I still have the same error. Can you give me some directions on how to resolve this.
Chris Saxon
July 15, 2016 - 1:21 am UTC

What was the SR number ?

More to Explore

VLDB

If you are new to partitioning, check out Connor McDonald's introduction series here.

VLDB

Documentation set on VLDB and Partitioning.