ORA-27054 error when creating databases

From Brandonhutchinson.com

Revision as of 16:24, 31 December 2007 by Hutch (Talk | contribs)
Jump to: navigation, search

Oracle version: Oracle 10G R2 OS version: 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=149.122.39.60

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

Personal tools