ORA-27054 error when creating databases

From Brandonhutchinson.com

Revision as of 17:51, 31 December 2007 by Hutch (Talk | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

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 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:

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