We recently replaced all our hardware with pretty much Oracle everything. We're in the process of moving from VMWare to OVM.
In order to make use of snapshots we were told that the disk for Oracle database files need to be NFS mounted filesystems.
The consultants we hired to help us configure the servers told us to use a vanilla default NFS mount
| x.x.x.x:/export/client/oradata1 /oradata1 nfs | defaults | 0 0 |
We have recently been seeing some performance problems when moving large amounts of data about (such as loading databases with sqlloader) - we're almost certain it's the NFS mounts that are causing us the problem
Searching around the interwebs and looking at the Oracle documentation we've seen several examples and we're thinking that our consultants have led us up a tree.
From the Oracle 11 docs there's a table talking about the options: https://docs.oracle.com/cd/B28359_01/install.111/b32002/app_nas.htm#LADBI439
Haven't found that in the 12 docs yet.
Have found a couple of MOS docs:
This one refers to RAC (we're not running RAC): Mount Options for Oracle files for RAC databases and Clusterware when used with NFS on NAS devices (Doc ID 359515.1)
This one is a generic question on NFS mount settings: ORA-27054: NFS file system where the file is created or resides is not mounted with correct options (Doc ID 781349.1)
What I'm after is some feedback from someone who's used NFS mounts for single instance Oracle 12 to make sure we reconfigure our mounts correctly.
359515.1 says: rw,bg,hard,nointr,rsize=32768, wsize=32768,tcp,actimeo=0, vers=3,timeo=600
781349.1 says: rw,bg,hard,rsize=32768,wsize=32768,vers=3,forcedirectio,nointr,proto=tcp,suid
These strings are similar but not quite the same.
Any wisdom from actual experience on what we should have?
We are running OVM 3.4.2 / OEL 6.5 / Oracle 12.1.0.2 SE2
Thanks