DataPump Export To OCFS2 Fails With ORA-31693 ORA-19502 ORA-27072 File I/O Error

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Apr-2013***

Symptoms

You see the following error during DataPump export:

ORA-31693: Table data object "SCOTT"."EMP" failed to load/unload and is being skipped due to error:
ORA-19502: write error on file "/u03/test/export/FULL_EXP.dmp", block number 4158766 (block size=4096)
ORA-27072: File I/O error

The used DataPump export command line is:

#> expdp system/passwd full=y dumpfile=datapump:FULL_EXP.dmp logfile=datapump:FULL_EXP.log parallel=10

Solution from Note 803300.1 did not help.

Cause

Requirements for OCSF2 are not in place.

Solution

1. SELinux filter needs to be disabled (OCFS2 User Guide 1.4 - OS Configuration - Page 20). A bug in SELinux does not allow configfs to mount.  Disable SELinux by setting "SELINUX=disabled" in /etc/selinux/config. Change is activated on reboot. (OCFS2 1.2 - Frequently Asked Questions - http://oss.oracle.com/projects/ocfs2/dist/documentation/v1.2/ocfs2_faq.html)

2. Firewall through "iptables" need to be disabled (OCFS2 User Guide 1.4 - OS Configuration - Page 20)

3. (a) Entry to /etc/fstab need to be set as follows (OCFS2 User Guide 1.4 - Mount Options - Page 24 and Note 803300.1)

/etc/fstab: /dev/emcpowerdl1 /infshare ocfs2 rw,_netdev,datavolume,nointr 0 0

-OR-

(b) Mount manually as follows:

#> mount -o rw,_netdev,datavolume,nointr -t ocfs2 /dev/emcpowerdl1 /infshare

References

NOTE:1264715.1 - Master Note for Data Pump
NOTE:803300.1 - DataPump Export To OCFS2 Volume Fails With Errors ORA-31693 ORA-19502 And ORA-27061