oracle数据泵并行导出到nas,Oracle RAC expdp 错误一例 ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout...

今天导出数据的时候，遇到一个错误。数据库是linux下面的两节点的RAC， 10.2.0.4.0。

错误消息如下：

ORA-31693: Table data object "ABC"."AAAA" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout

ORA-31617: unable to open dump file "/dba_mount/aaaa/expdp_test_02.dmp" for

Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:

/dba_mount/aaaa/expdp_test_01.dmp

/dba_mount/aaaa/expdp_test_02.dmp

/dba_mount/aaaa/expdp_test_03.dmp

Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" completed with 1 error(s) at 06:07:48

网上找了一下，有个URL适用。是因为两个节点用的mount point, 在/etc/fstab里面配置不一样造成的。修改，重新mount，即可。

参考URL如下：

摘录一小段：

What is the root cause of ORA-31693 and ORA-31617 when doing expdp in RAC environment?

The following error happens in RAC environment if someone ran export with PARALLEL=X.

The rootcause is that you are trying to export in a RAC environment with parallel clause

but the directory (FS) is not available on all RAC node clusters. You should use a NAS/SAN mount

that is shared to all RAC nodes when using expdp with PARALLEL clause otherwise you will end up with this error.

ORA-31693: Table data object “DINA.ABCD” failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout

ORA-31617: unable to open dump file “/opt/oracle/exp/dina.dmp”

=== 又记

昨天导出，遇到错误如下：

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

ORA-31693: Table data object "OWNER"."TABLES" failed to load/unload and is being skipped due to error:

ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout

ORA-39079: unable to enqueue message RQ,KUPC$C_2_20140507102039,KUPC$A_1_20140507102108

Processing object type SCHEMA_EXPORT/TABLE/TABLE

修改如下：

alter system set aq_tm_processes=1 scope=memory;

即可