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如下：

http://www.dbquotient.com/blogs/?page_id=25

摘录一小段：

 

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;

即可