欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

expdp错误ORA-39029

程序员文章站 2022-05-25 22:37:41
...

源端hp-unix+oracle10g-r204-rac,目标端redhat+oracle10g。expdp错误ORA-39029

源端hp-unix+Oracle10g-r204-rac,目标端RedHat+oracle10g。
在目标端使用network_link导出,报错如下:
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
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
首先看到的错误是:
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

经查,该错误是备份时创建备份主表(Master Table)产生的(使用类似CREATE TABLE () INITRANS 10 MAXTRANS 30语句创建),提示参数MAXTRANS已经被废弃而已,是个bug,,略过。
继续往下看:
Memory Notification: Library Cache Object loaded into SGA
Heap size 2048K exceeds notification threshold (2048K)
KGL object name :SYS.KUPC$C_1_20120524135135

expdp错误ORA-39029