ORA-39125错误一例

Maclean Liu(刘相兵

ORA-39125错误一例


导出日志抱错：
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/AUDIT_OBJ
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [INDEX_STATISTICS]
ORA-22813: operand value exceeds system limits
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
70000021f61deb8     15032  package body SYS.KUPW$WORKER
70000021f61deb8      6372  package body SYS.KUPW$WORKER
70000021f61deb8      2396  package body SYS.KUPW$WORKER
70000021f61deb8      6944  package body SYS.KUPW$WORKER
70000021f61deb8      1314  package body SYS.KUPW$WORKER
70000021d4a0420         2  anonymous block
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 23:10:56


1、就报错看 是BUG  bug 6991626 EXPORT DATAPUMP FAILS WITH ORA-39126 AND ORA-22813。


2、你可以试下这样是否能Workaround:

先删掉之前声称的 dmp和log 之后 排除统计信息导出

expdp system/xxx DIRECTORY=ext_tab_dir LOGFILE=dp_fullexp_meta.log  DUMPFILE=dp_full.dmp SCHEMAS=mpvs CONTENT=METADATA_ONLY EXCLUDE=statistics,USER,ROLE,ROLE_GRANT,PROFILE


3、 查一下patch

opatch lsinventory -detail



Datapump Export Fails With Error ORA-39125 ORA-22813 Operand Value Exceeds System Limits [ID 781638.1]

Cause
Solution
References
Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 05-DEC-2011***


Symptoms

Full Datapump export fails with the following errors:


ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA
   while calling DBMS_METADATA.FETCH_XML_CLOB [....]

ORA-22813: operand value exceeds system limits
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line ....

SYS.KUPW$WORKER is present on the PL/SQL Call Stack

Cause

This problem is caused by unpublished bug 6991626 EXPORT DATAPUMP FAILS WITH ORA-39126 AND ORA-22813. DataPump export fails to write large volume data and gives error message: ORA-22813 operand value exceeds system limits.

Solution

On Windows platform, either:

- upgrade to 10.2.0.4 and install Windows Bundle Patch 10.2.0.4.P16 or above

Or:

-  upgrade to 11.1.0.7 and install Windows Bundle Patch 11.1.0.7.P2 or above

On other platforms. one-off patches may be available depending on your current release and operating system. Please verify the patch 6991626 for availability.