In TR-3322 it says that the mount point for the redo logs should have the forcedirectio option on and the mount point for the data files should have it off. KB7518, which appears to be more recent, doesn't say anything about mount options for redo log volumes, but I assume you should have either forcedirectio or llock on both the mount points for your redo logs and data files. Is this correct?
Thanks,
- Carl
Yeah, the Netapp documents are not consistent. This is what we have for our oracle mounts: nfs 2 yes rw,bg,vers=3,proto=tcp,hard,intr,rsize=32768,wsize=32768,forcedirectio,llock <<--- For all data files, redo logs and arch log volumes. and no forceddirectio for the Oracle binaries volume nfs 2 yes rw,bg,vers=3,proto=tcp,hard,intr,rsize=32768,wsize=32768,llock
Is this correct? It seems to be working OK for us now, we are yet to go into production though, its only a few developers working on the database. BTW, we are on Solaris 10. -G
On 5/2/07, Carl Howell chowell@uwf.edu wrote:
In TR-3322 it says that the mount point for the redo logs should have the forcedirectio option on and the mount point for the data files should have it off. KB7518, which appears to be more recent, doesn't say anything about mount options for redo log volumes, but I assume you should have either forcedirectio or llock on both the mount points for your redo logs and data files. Is this correct?
Thanks,
- Carl
It says in KB6570 that you shouldn¹t have forcedirectio and llock in the same mount statement, and in KB7518 llock is not listed as a needed option for the Oracle Binaries.
It also says in KB6570 that if you¹re running 32-bit Oracle that you should use llock and if you¹re running 64-bit Oracle that you should use forcedirectio.
- Carl
On 5/2/07 1:31 PM, "Sto Rage©" netbacker@gmail.com wrote:
Yeah, the Netapp documents are not consistent. This is what we have for our oracle mounts: nfs 2 yes rw,bg,vers=3,proto=tcp,hard,intr,rsize=32768,wsize=32768,forcedirectio,llock <<--- For all data files, redo logs and arch log volumes. and no forceddirectio for the Oracle binaries volume nfs 2 yes rw,bg,vers=3,proto=tcp,hard,intr,rsize=32768,wsize=32768,llock
Is this correct? It seems to be working OK for us now, we are yet to go into production though, its only a few developers working on the database. BTW, we are on Solaris 10. -G
On 5/2/07, Carl Howell chowell@uwf.edu wrote:
In TR-3322 it says that the mount point for the redo logs should have the forcedirectio option on and the mount point for the data files should have it off. KB7518, which appears to be more recent, doesn't say anything about mount options for redo log volumes, but I assume you should have either forcedirectio or llock on both the mount points for your redo logs and data files. Is this correct?
Thanks,
- Carl