ORA-27054 error when creating databases

From Brandonhutchinson.com

(Difference between revisions)
Jump to: navigation, search
Line 5: Line 5:
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
-
The NAS share was mounted using the NFS defaults:
+
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
Flags: rw,vers=3,rsize=32768,wsize=32768,hard,proto=tcp,timeo=600,retrans=2,sec=sys,addr=192.168.1.100
Line 26: Line 29:
from a server. The default is 60 seconds.
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], you must disable attribute caching on the NFS mount using '''noac''' or '''actime=0'''.
+
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 in '''/etc/fstab''', they are not listed in '''/etc/mtab'''.
 +
 
 +
As a workaround, specify these mount options in the '''/etc/fstab''' NFS mount. e.g.,
 +
192.168.1.100:/vol/oradata1 /oradata1 nfs '''rsize=32768,wsize=32768,hard,noac''' 0 0
 +
 
 +
 
 +
 
 +
 
 +
149.122.39.60:/vol/anaemmmdo801_backuparea_oradata5_aecd01/oradata5_aecd01 /oradata5/AECD01 nfs rw,noac,addr=149.122.39.60 0 0

Revision as of 17:48, 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
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 in /etc/fstab, they are not listed in /etc/mtab.

As a workaround, specify these mount options in the /etc/fstab NFS mount. e.g., 

192.168.1.100:/vol/oradata1 /oradata1 nfs rsize=32768,wsize=32768,hard,noac 0 0



149.122.39.60:/vol/anaemmmdo801_backuparea_oradata5_aecd01/oradata5_aecd01 /oradata5/AECD01 nfs rw,noac,addr=149.122.39.60 0 0

Retrieved from "http://brandonhutchinson.com/wiki/ORA-27054_error_when_creating_databases"
Personal tools