Monday, November 15, 2010

EXPDP to NFS disk fails with ORA-27054 which does not have "noac" set

Problem Description
ORA-027054 error is reported by expdp when run against a RAC enabled database if the target location for the data pump file is an NFS disk which does not have the "noac" property set against it.

"noac" is required for datafiles and many other database file types but should not be needed for expdp output files.

Cause of the Problem
The problem happened due to Oracle bug 9115046.

Solution of the Problem
Solution 01
This bug is started in server patchset 10.2.0.4 and bug is remained in
Oracle version 11.1.0.7
Oracle version 11.1.0.6
Oracle version 10.2.0.4.
This bug is fixed in Oracle database Server Patch Set version 11.2.0.2. so upgrade your Oracle database version is a solution.

Solution 02
Workaround you can use a different destination for the datapump export file which does have relevant attributes, or use a local file system.

Solution 03
Use event 10298 level 32 to disable the noac check (but take care as this avoid all NFS checks for all file types which can lead to corruption scenarios if disks are not mounted with the correct options).

No comments: