ORA-39097: Data Pump job encountered unexpected error -12801

最新推荐文章于 2023-09-10 16:34:21 发布

转载最新推荐文章于 2023-09-10 16:34:21 发布 · 1.2k 阅读

本文详细介绍了如何解决在Oracle RAC数据库中使用数据泵导入时遇到的ORA-39097、ORA-39065、ORA-12801和ORA-1460错误的问题。通过应用特定补丁集或设置参数，最终成功解决了故障。同时，提供了升级到更高版本或应用特定补丁作为解决方案。

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Apr-2014***

Data Pump Import in a RAC database fails with errors like:

ORA-39097: Data Pump job encountered unexpected error -12801
ORA-39065: unexpected master process exception in MAIN
ORA-12801: error signaled in parallel query server PZ99, instance
ORA-01460: unimplemented or unreasonable conversion requested Job stopped due to fatal error at .

Changes

The fix for Bug 9375300 is applied (this fix is included starting with 11.2.0.2 PSU 5 and in 11.2.0.3).

The workaround from:
Note 1427537.1 - DataPump Import (IMPDP) Fails With Errors ORA-39097 ORA-39065 ORA-12801 ORA-1460 In RAC Environment
to set PARALLEL_DEGREE_POLICY=MANUAL in all instances was used without success.

Cause

The errors are caused by:
Bug 13099577 - ORA-1460 with parallel query

This is a regression introduced in 11.2.0.2.5 and 11.2.0.3 by the fix for Bug 9375300

The bug is fixed a.o. fixed in

12.1.0.1 (Base Release)
11.2.0.4 (Server Patch Set)

For the above and other fixed versions, refer to:
Please also refer to
Note 13099577.8 - Bug 13099577 - ora-12801 and ORA-1460 with parallel query

Solution

o Upgrade to 12c

- OR -

o Apply patch set 11.2.0.4

- OR -

o For 11.2.0.2 / 11.2.0.3, apply PSU 11.2.0.2.7 (Patch 13923804) or PSU 11.2.0.3.4 (Patch 14275605) or higher

- OR -

o Apply interim patch 13099577 if available for your platform and Oracle version.

    To check for conflicting patches, please use the MOS Patch Planner Tool
    Please refer to
    Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?

- OR -

o For Exadata environments:
- On top of 11.2.0.2 apply Bundle Patch 16 (Patch 13837673) or subsequent ones
- On top of 11.2.0.3 apply Bundle Patch 5 (Patch 13734832) or subsequent ones

- OR -

o A possible workaround is to set (in all instances):

PARALLEL_FORCE_LOCAL=TRUE

By setting PARALLEL_FORCE_LOCAL to TRUE, the parallel server processes are restricted.
This way, they can only operate on the same RAC node where the DW coordinator process resides.

References

BUG:13099577 - ORA-1460 WHEN PARALLEL QUERY SERVERS ARE USED
NOTE:13099577.8 - Bug 13099577 - ora-12801 and ORA-1460 with parallel query
NOTE:1427537.1 - DataPump Import (IMPDP) Fails With Errors ORA-39097 ORA-39065 ORA-12801 ORA-1460 In RAC Environment

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28869493/viewspace-1319360/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28869493/viewspace-1319360/