ORA-27054 error when creating databases

From Brandonhutchinson.com

(Difference between revisions)
Jump to: navigation, search
Line 1: Line 1:
-
 
+
These notes are from the following:
-
* '''Oracle 10G R2'''
+
* Oracle 10G R2
-
* '''RHEL 5.1 x86_64'''
+
* RHEL 5.1 x86_64
One of our DBAs was creating databases on a NAS device and received the following error:
One of our DBAs was creating databases on a NAS device and received the following error:

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