expdp错误ORA-39029

最新推荐文章于 2022-09-26 18:08:23 发布

gtlions

最新推荐文章于 2022-09-26 18:08:23 发布

阅读量7.3k

点赞数

分类专栏： Oracle Backup & Recovery Oracle Mangement 文章标签： schema warnings parallel os system

本文链接：https://blog.csdn.net/gtlions/article/details/7609963

版权

本文介绍了在源端HP-UNIX + Oracle 10g R2和目标端Redhat + Oracle 10g环境下，通过network_link导出数据时遇到的ORA-39014和ORA-39029错误。问题源于worker进程提前退出，涉及Oracle Data Pump的并行查询服务器错误。解决方案包括检查数据库警告，调整_kgl_large_heap_warning_threshold参数，并考虑可能的版本问题。

摘要由CSDN通过智能技术生成

源端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',