ORA-31693 ORA-19502 ORA-27061

Applies to:

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

Symptoms

When attempting to perform a DataPump export to an OCFS2 mount point, it fails with errors as seen in the following example:

ORA-31693: Table data object "<schema>.<tablename>" failed to load/unload and is being skipped due to error:
ORA-19502: write error on file "/u03/oraback/exp/ExpSchema01.DMP", block number 418451 (block size=4096)
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 512: Unknown system error
Additional information: -1
Additional information: 262144

Cause

The OCFS2 volume is not properly mounted as it requires the "nointr" option to ensure that the I/Os are not interrupted by signals.

Solution

Mount the OCFS2 with the "nointr" option. For Example:

#> mount -o datavolume,nointr -t ocfs2 /dev/sdX /dir

Or, if mounting through the /etc/fstab, the entry should be as follows:

/dev/sdX /dir ocfs2 _netdev,datavolume,nointr 0 0

References

NOTE:565574.1 - How to Fix the IO Errors Reading an Oracle Datafile On an OCFS2 Filesystem.
NOTE:566355.1 - Unable To Queue I/O (ORA-27091)