This discussion is archived
11 Replies Latest reply: May 15, 2013 1:12 PM by Dean Gagne RSS

expdp error

939088 Newbie
Currently Being Moderated
Dear Experts

this error face on me, how to resolve this error.

+[oracle@online ~]$ expdp directory=sys schemas=t01 dumpfile=t01_20130514.dmp parallel=8 logfile=t01_export_20130514_2.log+

Export: Release 11.2.0.1.0 - Production on Tue May 14 22:34:44 2013

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

Username: / as sysdba

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
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  /******** AS SYSDBA directory=sys schemas=t01 dumpfile=t01_20130514.dmp parallel=8 logfile=t01_export_20130514_2.log
Job "SYS"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 22:35:26

+[oracle@online ~]$ cat sys/t01_export_20130514_2.log+
+;;;+
Export: Release 11.2.0.1.0 - Production on Tue May 14 22:34:44 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
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  /******** AS SYSDBA directory=sys schemas=t01 dumpfile=t01_20130514.dmp parallel=8 logfile=t01_export_20130514_2.log
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-39079: unable to enqueue message RQ
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 965
ORA-00931: missing identifier
ORA-06512: at "SYS.KUPW$WORKER", line 16746
ORA-06512: at "SYS.KUPW$WORKER", line 19035
ORA-06512: at "SYS.KUPW$WORKER", line 8191
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN []
ORA-06512: at "SYS.KUPW$WORKER", line 1705
ORA-44002: invalid object name
ORA-06512: at line 2
Job "SYS"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 22:35:26

Edited by: LiverBird on May 14, 2013 7:53 AM

Edited by: LiverBird on May 14, 2013 10:07 PM
  • 1. Re: expdp error
    sybrand_b Guru
    Currently Being Moderated
    You shouldn't use / as sysdba to export a database.
    Also when you configure multiple workers (parallel=8) you will export to 8 files, so you either need to specify 8 files or use the documented %U syntax to get automatically numbered files.


    ----------
    Sybrand Bakker
    Senior Oracle DBA
  • 2. Re: expdp error
    DK2010 Guru
    Currently Being Moderated
    Hi,

    Welcome to the forum,

    use the dumpfile name _%U as suffix since you are using the parallel option. datapump worker issue with parallel
    expdp directory=sys schemas=t01 dumpfile=t01_20130514_%U.dmp parallel=8 logfile=t01_export_20130514_2.log
    HTH
  • 3. Re: expdp error
    Antonio Navarro Pro
    Currently Being Moderated
    Have you probed parallel = 1?

    HTH
    Antonio NAVARRO
  • 4. Re: expdp error
    Fran Guru
    Currently Being Moderated
    welcome to otn forums

    i think that you didn't read the documentation too well or use expdp help=y

    please check the examples on ducumentation
    http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_export.htm

    HTH
  • 5. Re: expdp error
    939088 Newbie
    Currently Being Moderated
    Hi DK2010


    [oracle@online ~]$ expdp directory=sys schemas=t01 dumpfile=t01_20130514_%U.dmp parallel=8 logfile=t01_export_20130514_2.log

    Export: Release 11.2.0.1.0 - Production on Tue May 14 22:55:10 2013

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

    Username: / as sysdba

    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
    FLASHBACK automatically enabled to preserve database integrity.
    Starting "SYS"."SYS_EXPORT_SCHEMA_02": /******** AS SYSDBA directory=sys schemas=t01 dumpfile=t01_20130514_%U.dmp parallel=8 logfile=t01_export_20130514_2.log
    Job "SYS"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at 22:55:46

    [oracle@online ~]$ cat sys/civil_export_20130514_2.log
    ;;;
    Export: Release 11.2.0.1.0 - Production on Tue May 14 22:55:10 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
    FLASHBACK automatically enabled to preserve database integrity.
    Starting "SYS"."SYS_EXPORT_SCHEMA_02": /******** AS SYSDBA directory=sys schemas=t01 dumpfile=t01_20130514_%U.dmp parallel=8 logfile=t01_export_20130514_2.log
    ORA-39014: One or more workers have prematurely exited.
    ORA-39029: worker 1 with process name "DW00" prematurely terminated
    ORA-31671: Worker process DW00 had an unhandled exception.
    ORA-39079: unable to enqueue message RQ
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
    ORA-06512: at "SYS.KUPC$QUE_INT", line 965
    ORA-00931: missing identifier
    ORA-06512: at "SYS.KUPW$WORKER", line 16746
    ORA-06512: at "SYS.KUPW$WORKER", line 19035
    ORA-06512: at "SYS.KUPW$WORKER", line 8191
    ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN []
    ORA-06512: at "SYS.KUPW$WORKER", line 1705
    ORA-44002: invalid object name
    ORA-06512: at line 2
    Job "SYS"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at 22:55:46
  • 6. Re: expdp error
    DK2010 Guru
    Currently Being Moderated
    Hi,

    Can you please check the Invalid object in SYS schema related to datapump.
  • 7. Re: expdp error
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    As noted above, do not use "/ as sysdba" to perform expdp or impdp - http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#i1012781

    Pl see if this MOS Doc is relevant

    DataPump Export Fails With Errors ORA-39014 ORA-39029 ORA-39079 [ID 465655.1]

    HTH
    Srini
  • 8. Re: expdp error
    939088 Newbie
    Currently Being Moderated
    Sorry DK2010, How to check ORA-44002: invalid object name?
  • 9. Re: expdp error
    DK2010 Guru
    Currently Being Moderated
    Hi

    you can use
    select object_type,object_name from dba_objects where status = 'INVALID' and owner='SYS' 
  • 10. Re: expdp error
    Richard Harrison . Expert
    Currently Being Moderated
    Hi,
    Does the error still happen when parallel=1?

    Regards,
    Harry

    http://dbaharrison.blogspot.com
  • 11. Re: expdp error
    Dean Gagne Expert
    Currently Being Moderated
    This looks like a queuing error. Are you sure that the package body that controls queues is valid. What was the outcome of the invalid sys objects that you were asked to get?

    Also, if enough files was not specified for the number of parallel processes allowed, the export would still run, it would just be running with essentially parallel 1. All of the other workers would be waiting for the file to be released before it could do anything. The job should not fail in this situation.

    Dean