Skip to content

ORA-39029

DATAPUMP遭遇ORA-39029 ORA-04030

平台 P750*2
系统 AIX 6108
数据库 1120310 RAC

导出脚本:

expdp system/oracle DIRECTORY=DBPUMP dumpfile=js_jssi_jsrep_%U.dmp logfile=js_all_exp.log SCHEMAS=JSREP,JSSI,JYCHK,SJQY

导入脚本:

impdp system/oracle DIRECTORY=DBPUMP dumpfile=js_jssi_jsrep_%U.dmp logfile=js_all_imp.log SCHEMAS=JSREP,JSSI,JYCHK,SJQY cluster=N

遇错:

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 3 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 4194328 bytes (pga heap,buf_kgcbz2state)
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2

Job "SYSTEM"."SYS_IMPORT_SCHEMA_04" stopped due to fatal error at 10:44:55

实际现场情况是主机资源空闲,不存在资源不够的情况,所以直接就怀疑到Oracle的用户资源分配限制设置上,使用smit user登录检查oracle用户发现在sofe方面都实施RAC的人未做修改,改之。问题消失。

该问题在11.2.0.2之前可能为bug。