Expdp error ORA-39029

Source: Internet
Author: User

Source end hp-unix + Oracle10g-r204-rac, target end RedHat + oracle10g.
When network_link is used for export on the target end, the following error is returned:
Rm/opt/oradir/expdp. dmp
Expdp \ "sys/oracle as sysdba \" directory = oradir network_link = portal95 schemas = rbt dumpfile = expdp. dmp logfile = expdp. log exclude = statistic

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW02" prematurely terminated
ORA-31671: Worker process DW02 had an unhandled exception.
ORA-12801: error signaled in parallel query server
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
The ORA-29400: data cartridge error
KUP-04038: internal error: kupax-meta1
ORA-06512: at "SYS. ORACLE_DATAPUMP", line 78
ORA-06512: at "SYS. KUPW $ WORKER", line 1345
ORA-06512: at line 2

Job "SYS". "SYS_EXPORT_SCHEMA_05" stopped due to fatal error at 13:53:52

Alert. log
The first error is:
Thu May 24 13:51:34 2012
The value (30) of MAXTRANS parameter ignored.
Kupprdp: master process DM00 started with pid = 38, OS id = 5089
To execute-SYS. KUPM $ MCP. MAIN ('sys _ EXPORT_SCHEMA_05 ', 'sys', 'kupc $ C_1_20120524135135 ', 'kupc $ S_1_20120524135135', 0 );
Kupprdp: worker process DW01 started with worker id = 1, pid = 39, OS id = 5091
To execute-SYS. KUPW $ WORKER. MAIN ('sys _ EXPORT_SCHEMA_05 ', 'sys ');
Kupprdp: worker process DW02 started with worker id = 2, pid = 40, OS id = 5096
To execute-SYS. KUPW $ WORKER. MAIN ('sys _ EXPORT_SCHEMA_05 ', 'sys ');
Kupprdp: worker process DW03 started with worker id = 3, pid = 42, OS id = 5098
To execute-SYS. KUPW $ WORKER. MAIN ('sys _ EXPORT_SCHEMA_05 ', 'sys ');
Kupprdp: worker process DW04 started with worker id = 4, pid = 43, OS id = 5100
To execute-SYS. KUPW $ WORKER. MAIN ('sys _ EXPORT_SCHEMA_05 ', 'sys ');
Kupprdp: worker process DW05 started with worker id = 5, pid = 44, OS id = 5102
To execute-SYS. KUPW $ WORKER. MAIN ('sys _ EXPORT_SCHEMA_05 ', 'sys ');
Kupprdp: worker process DW06 started with worker id = 6, pid = 45, OS id = 5104
To execute-SYS. KUPW $ WORKER. MAIN ('sys _ EXPORT_SCHEMA_05 ', 'sys ');
Kupprdp: worker process DW07 started with worker id = 7, pid = 46, OS id = 5106
To execute-SYS. KUPW $ WORKER. MAIN ('sys _ EXPORT_SCHEMA_05 ', 'sys ');
Kupprdp: worker process DW08 started with worker id = 8, pid = 47, OS id = 5108
To execute-SYS. KUPW $ WORKER. MAIN ('sys _ EXPORT_SCHEMA_05 ', 'sys ');
Thu May 24 13:52:15 2012

After investigation, this error is generated by creating the backup Master Table (Master TABLE) at the time of backup (using the statement like CREATE Table <table_name> (<columns_list>) INITRANS 10 MAXTRANS 30 ), the prompt that the parameter MAXTRANS has been discarded is a bug, skipped.
Continue to look down:
Memory Notification: Library Cache Object loaded into SGA
Heap size 2048 K exceeds notification threshold (2048 K)
KGL object name: SYS. KUPC $ c_000020120524135135

  • 1
  • 2
  • 3
  • Next Page

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.