According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], you must disable attribute caching on the NFS mount using '''noac''' or '''actime=0'''.

+

According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], attribute caching must be disabled on the NFS mount using '''noac''' or '''actime=0'''.

+

+

However, Oracle apparently looks at the output of the '''mount''' command (i.e., the contents of '''/etc/mtab'''). Unless the '''rsize''', '''wsize''', and '''hard''' mount options are specified when mounting the file system, they are not returned by the '''mount''' command. This causes the above Oracle errors, even though these mount options are actually in effect (i.e., '''nfsstat -m''').

+

+

As a workaround, specify these mount options when mounting the file system. e.g., '''/etc/fstab''' entry:

Current revision

These notes are from the following:

Oracle 10G R2

RHEL 5.1 x86_64

One of our DBAs was creating databases on a NAS device and received the following error:

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
WARNING:NFS file system ... mounted with incorrect options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard

Although not listed with nfsstat -m, attribute caching is enabled by default. From nfs(5):

acregmin=n The minimum time in seconds that attributes of a regular
file should be cached before requesting fresh informa-
tion from a server. The default is 3 seconds.
acregmax=n The maximum time in seconds that attributes of a regular
file can be cached before requesting fresh information
from a server. The default is 60 seconds.
acdirmin=n The minimum time in seconds that attributes of a direc-
tory should be cached before requesting fresh informa-
tion from a server. The default is 30 seconds.
acdirmax=n The maximum time in seconds that attributes of a direc-
tory can be cached before requesting fresh information
from a server. The default is 60 seconds.

According to this document[1], attribute caching must be disabled on the NFS mount using noac or actime=0.

However, Oracle apparently looks at the output of the mount command (i.e., the contents of /etc/mtab). Unless the rsize, wsize, and hard mount options are specified when mounting the file system, they are not returned by the mount command. This causes the above Oracle errors, even though these mount options are actually in effect (i.e., nfsstat -m).

As a workaround, specify these mount options when mounting the file system. e.g., /etc/fstab entry: