数据泵导出出现ORA-4030错误

客户Oracle 10.2.0.3环境,在导出是碰到ORA-4030错误。
错误信息为:

Processing object TYPE SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object TYPE SCHEMA_EXPORT/TABLE/TRIGGER
Processing object TYPE SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object TYPE SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
ORA-39014: One OR more workers have prematurely exited.
ORA-39029: worker 1 WITH process name “DW01” prematurely TERMINATED
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-04030: OUT OF process memory WHEN trying TO allocate 4108 bytes (PLS non-lib hp.pdzgM60_Make)
ORA-06512: at “SYS.KUPC$QUEUE_INT”, line 277
ORA-06512: at “SYS.KUPW$WORKER”, line 1311
ORA-04030: OUT OF process memory WHEN trying TO allocate 65036 bytes (kxs-heap-c,KQL tmpbuf) 
ORA-06512: at “SYS.KUPW$WORKER”, line 13249
ORA-06512: at “SYS.KUPW$WORKER”, line 14923
ORA-06512: at “SYS.KUPW$WORKER”, line 6293
ORA-39125: Worker unexpected fatal error IN KUPW$WORKER.DISPATCH_WORK_ITEMS while calling DBMS_METADATA.FETCH_XML_CLOB [PROCOBJ:“USER1”.“PROC_SCENAR2”]
ORA-06512: at “SYS.KUPW$WORKER”, line 6988
ORA-04030: OUT OF process memory WHEN trying TO allocate 4108 bytes (PLS non-lib hp.pdzgM60_Make)
ORA-04030: OUT OF process memory WHEN trying TO allocate 16396 bytes (koh-kghu sessi,pl/SQL vc2)
ORA-06512: at “SYS.KUPF$FILE”, line 2901
ORA-06512: at “SYS.KUPW$WORKER”, line 2301
ORA-04030: OUT OF process memory WHEN trying TO allocate 16396 bytes (koh-kghu sessi,pl/SQL vc2)
ORA-06512: at “SYS.KUPW$WORKER”, line 2
Job “USER1”.“SYS_EXPORT_SCHEMA_01” stopped due TO fatal error at 10:50:29

Oracle在导出数据字典元数据时出现了异常,这显然属于Oracle的bug。查询MOS,发现大量类似的描述,其中以DataPump Export (EXPDP) Terminates With Error ORA-4030 [ID 1368462.1]的描述最为接近。
Oracle给出了三种接近方案,可以设置隐含参数_use_realfree_heap=TRUE和 _realfree_heap_pagesize_hint=262144,这是避免PL/SQL程序导致ORA-4030错误的;另外就是在EXPDP的时候指定EXCLUDE=PROCACT_SYSTEM或EXCLUDE=PROCACT_SCHEMA,对当前的情况而言,这个方法应该是最适合的;最后一个方法是设置操作系统内核参数vm.max_map_count=300000。

This entry was posted in BUG and tagged , , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *