Wednesday, January 25, 2012

Data Pump Export Fails With ORA-39125 ORA-19502 ORA-27072 Error: 11: Resource temporarily unavailable

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem Description
In a RAC database Data Pump export or import operations are intermittently failing with:
ORA-31693: Table data object "owner"."table name" failed to load/unload and is being skipped due to error:  ORA-31644: unable to position to block number 182645 in dump file  "dump file name"  ORA-19502: write error on file "dump file name", blockno 184437 (blocksize=4096)  ORA-27072: File I/O error  Linux-x86_64 Error: 11: Resource temporarily unavailable  Additional information: 4  Additional information  
In our case data pump directory is placed on OCFS2 volume.

Cause of the Problem
The mount options for the OCFS2 volume do not include the "datavolume" and "nointr".

The "datavolume" option ensures that the Oracle processes opens these files with the o_direct flag. 
The "nointr" option ensures that the ios are not interrupted by signals. 

These two attributes needed in order to use for Oracle.

Solution of the Problem
Mount the OCFS2 volume with the "datavolume" and "nointr" options. 

For example:

# mount -o datavolume,nointr -t ocfs2 /dev/sda1 /dev/mount
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: