ORA-27054 error when creating databases

From Brandonhutchinson.com

(Difference between revisions)
Jump to: navigation, search
(New page: '''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 o...)
Line 1: Line 1:
-
'''Oracle 10G R2'''
+
Oracle version: '''Oracle 10G R2'''
-
'''RHEL 5.1 x86_64'''
+
OS version: '''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:24, 31 December 2007

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