NFS client mount options for Oracle and Netapp

Jephe Wu - http://linuxtechres.blogspot.com

Environment: Linux x86_64, Oracle 11g 64bit SI(Single Instance) or RAC,  use Netapp as storage for Oracle binary, datafile, rman backup and expdp
Kernel 2.6, OL 5.8 and OL 6.3

Objective: the recommended NFS mounting options


Steps:

Please refer to Mount Options for Oracle files when used with NFS on NAS devices [ID 359515.1]

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options [ID 781349.1]

and Netapp doc ID:
What are the mount options for databases on NetApp NFS?


Mount options for binary (exact order is important!)
RAC: rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600, actimeo=0
Netapp RAC: rw,bg,hard,rsize=32768,wsize=32768,vers=3,actimeo=0, nointr, suid, timeo=600, tcp

SI:    rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp
Netapp SI: rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600, tcp


For datafiles:
RAC: rw,bg,hard,nointr,rsize=32768, wsize=32768,tcp,actimeo=0, vers=3,timeo=600
Netapp RAC: rw,bg,hard,rsize=32768,wsize=32768,vers=3, actimeo=0, nointr, suid, timeo=600, tcp

SI:    rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp
Netapp SI: rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr, timeo=600, tcp

Mount options for CRS voting disk and OCR [RAC]
RAC: rw,bg,hard,nointr,rsize=32768, wsize=32768,tcp,noac,vers=3,timeo=600,actimeo=0
Netapp RAC: rw,bg,hard,rsize=32768,wsize=32768,vers=3,actimeo=0, nointr, suid, timeo=600, tcp

Note: 
For RMAN backup sets, image copies, and Data Pump dump files, the "NOAC" mount option should not be specified - that is because RMAN and Data Pump do not check this option and specifying this can adversely affect performance.

Due to Unpublished bug 5856342, it is necessary to use the following init.ora parameter when using NAS with all versions of RAC on Linux (x86 & X86-64 platforms) until 10.2.0.4. This bug is fixed and included in 10.2.0.4 patchset.
filesystemio_options = DIRECTIO

NOTE:  As per Bug 11812928, the 'intr' & 'nointr' are deprecated in UEK kernels, as well as Oracle Linux 6. It is harmless to still include it, you will get a notice..

NFS: ignoring mount option: nointr.



Variable Details: 

OptionDescription
hard Generate a hard mount of the NFS file system. If the connection to the server is lost temporarily, Oracle continues to retry the connection until the NAS device responds. 
bgTry to connect in the background if connection fails. 
proto=tcp(or tcp on Linux)Use the TCP protocol rather than UDP. TCP is more reliable than UDP. 
vers=3(or nfsvers=3 on Linux)Use NFS version 3. Oracle recommends that you use NFS version 3 where available, unless the performance of version 2 is higher. 
suid Allow clients to run executables with SUID enabled. This option is required for Oracle software mount points. 
rsize, wsize The number of bytes used when reading or writing to the NAS device. A value of 8192 is often recommended for NFS version 2 and 32768 is often recommended for NFS version 3. 
nointr (or intr)Do not allow (or allow) keyboard interrupts to kill a process that is hung while waiting for a response on a hard-mounted file system. 
noac
actimeo=0
Disable attribute caching. (a combination of sync and actimeo=0)
disable attribute caching on the client





No comments:

Post a Comment