ORA-27054 error when creating databases

From Brandonhutchinson.com

(Difference between revisions)
Jump to: navigation, search
Current revision (17:51, 31 December 2007) (edit) (undo)
 
(6 intermediate revisions not shown.)
Line 1: Line 1:
-
Oracle version: '''Oracle 10G R2'''
+
These notes are from the following:
-
OS version: '''RHEL 5.1 x86_64'''
+
* Oracle 10G R2
 +
* 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:
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
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:
+
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=149.122.39.60
+
Flags: rw,vers=3,rsize=32768,wsize=32768,hard,proto=tcp,timeo=600,retrans=2,sec=sys,addr=192.168.1.100
-
According to this document[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], you must disable attribute caching on the NFS mount using '''noac''' or '''actime=0'''.
+
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[http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#CHDIAGAD], 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

Current revision

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