ORA-31617 Error When Executing Expdp

Today I get the next error when executiong expdp in a RAC;


ORA-31693: Table data object "FOLE"."HISTI_MOV_QCATCH" 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 "/mntfc/FLSHPRD070317Dop3_05.dmp" for write
ORA-19505: failed to identify file "/mntwfc/FLSHPRD070317Dop3_05.dmp"
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory

After of search on ML/MOS I have discovered a bug that was the problem. In this version 11.2.0.1, when execute expdp with parallel option, parallel is executed from all actives instances in the cluster. I was trying execute from only one node and I have NFS (Network File System) mount in this node.

Solutions

1- Set cluster_database=false (From doc.) I prefer if is possible stop the other instances.

2- Mount the NFS in all nodes of the cluster, (This was my solution).

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s