:

ORA-39125: Worker unexpected fatal error in KUPW$WORKER

The Problem

I was using our physical standby database to run a data pump export job. I had created a guaranteed restore point so that I was able to flashback the DB to its original state but I was not able to get the export working. There was no real error message on the screen. I was seeing the below:

Export: Release 10.2.0.4.0 – 64bit Production
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning option

I checked through the alert log and saw this error message:

The value (30) of MAXTRANS parameter ignored. You can safely ignore this error as Metalink note 455021.1 states that the create tables statement which would be similar to the following no longer accepts the parameter for MAXTRANS.

create table testing (col1 number) initrans 10 maxtrans 30;

I could not see any other error messages related to this hanging of the data pump export in the alert log at the time so I had to play around with it to finally get to the root cause.

The Cause

I spent a little time trying to work out what the problem was, changing which parameters I used and the finally came across the cause of the problem by running the data pump export command without any parameters:

expdp ‘sys@<TESTDB> as sysdba’ dumpfile=TEST:test.dmp logfile=TEST:test.log
Export: Release 10.2.0.4.0 – 64bit Production
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning option

Starting “SYS”.”SYS_EXPORT_SCHEMA_01″: 
‘sys/********@database AS SYSDBA’ dumpfile=TEST:test.dmp logfile=TEST:test.log
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_LOB.CREATETEMPORARY []
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 6307

—– PL/SQL Call Stack —–
object line  object handle    number  name
000000020C262640     15032  package body SYS.KUPW$WORKER
000000020C262640      6372  package body SYS.KUPW$WORKER
000000020C262640      9206  package body SYS.KUPW$WORKER
000000020C262640      1936  package body SYS.KUPW$WORKER
000000020C262640      6944  package body SYS.KUPW$WORKER
000000020C262640      1314  package body SYS.KUPW$WORKER
000000020C2EBBA0         2  anonymous block
Job “SYS”.”SYS_EXPORT_SCHEMA_01″ stopped due to fatal error at 15:24:07

The Solution

As you can see from the errors above it shows you that there is no Temporary tablespace. Simply create the temporary tablespace or add datafiles to an empty TEMP tablespace and away you go.

Like it, share it...

Category: Data Pump


Related Posts

Comments (2)

Trackback URL | Comments RSS Feed

  1. james says:

    My temp tablespace datafiles are there but still getting this from expdp
    csslu712:fslostg:/CMS/financelegacy/SL/par $ expdp userid=system@fslostg parfile=expdp_sysadm

    Export: Release 10.2.0.3.0 – 64bit Production on Tuesday, 28 April, 2015 11:17:20

    Copyright (c) 2003, 2005, Oracle. All rights reserved.
    Password:

    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
    With the Partitioning, OLAP and Data Mining options
    Starting “SYSTEM”.”SYS_EXPORT_SCHEMA_01″: userid=system/********@fslostg parfile=expdp_sysadm
    Estimate in progress using BLOCKS method…
    Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
    ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_LOB.CREATETEMPORARY []
    ORA-00607: Internal error occurred while making a change to a data block
    ORA-00600: internal error code, arguments: [kddummy_blkchk], [503], [3], [18018], [], [], [], []

    ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
    ORA-06512: at “SYS.KUPW$WORKER”, line 6228

    —– PL/SQL Call Stack —–
    object line object
    handle number name
    38d408070 14916 package body SYS.KUPW$WORKER
    38d408070 6293 package body SYS.KUPW$WORKER
    38d408070 9108 package body SYS.KUPW$WORKER
    38d408070 1881 package body SYS.KUPW$WORKER
    38d408070 6854 package body SYS.KUPW$WORKER
    38d408070 1259 package body SYS.KUPW$WORKER
    38d3ab9a0 2 anonymous block

    Job “SYSTEM”.”SYS_EXPORT_SCHEMA_01″ stopped due to fatal error at 11:17:43

    csslu712:fslostg:/CMS/financelegacy/SL/par $

Leave a Reply

Your email address will not be published. Required fields are marked *