ORA-27054 error when creating databases

From Brandonhutchinson.com

Revision as of 16:28, 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

The NAS share was mounted using the NFS defaults:

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], you must disable attribute caching on the NFS mount using noac or actime=0.