ORA-27054 error when creating databases

From Brandonhutchinson.com

Revision as of 17:48, 31 December 2007

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

The NAS share was mounted using the NFS defaults. From nfsstat -m:

Flags: rw,vers=3,rsize=32768,wsize=32768,hard,proto=tcp,timeo=600,retrans=2,sec=sys,addr=192.168.1.100

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 in /etc/fstab, they are not listed in /etc/mtab.

As a workaround, specify these mount options in the /etc/fstab NFS mount. e.g.,

192.168.1.100:/vol/oradata1 /oradata1 nfs rsize=32768,wsize=32768,hard,noac 0 0

149.122.39.60:/vol/anaemmmdo801_backuparea_oradata5_aecd01/oradata5_aecd01 /oradata5/AECD01 nfs rw,noac,addr=149.122.39.60 0 0