环境:P550*2,DS4500,AIX 5306,Oracle 10G R2 RAC
背景:客户需要备份RAC数据库,因使用了祼设备存放数据库文件,故决定采取NFS的方式来实现归档文件的共享存取。
配置好NFS后,Oracle用户的读写权限正常,但在进行日志切换时,Oracle hang住无法登录,费了好大劲才强行关闭。
经查alert*.log,有关于nfs mount options的警告信息,经查,对不同的Oracle文件内容,如果要使用NFS且正常工作,需要不同的mount选项,如下:
This document is relevant to all environments using 10g CRS along with 10gRAC.
Mount Options for Oracle files when used with NAS devices
--------------------------
Mount options for Binaries:
Sun Solaris * rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,noac,vers=3,suid
AIX (5L) ** rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600
HPUX 11.23 **** rw,bg,vers=3,proto=tcp,noac,hard,nointr,timeo=600,rsize=32768,wsize=32768,suid
Windows Not Supported
Linux x86 rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actime=0
Linux x86-64 rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actime=0
Linux - Itanium rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actime=0
-----------
Mount options for Oracle Datafiles:
Sun Solaris * rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,noac,forcedirectio,vers=3,suid
AIX (5L) ** cio,rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,noac,vers=3,timeo=600
HPUX 11.23 **** rw,bg,vers=3,proto=tcp,noac,forcedirectio,hard,nointr,timeo=600,rsize=32768,wsize=32768,suid
Windows Not Supported
Linux x86 rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600
Linux x86-64 rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600
Linux - Itanium rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600
-----------
Mount options for CRS Voting Disk and OCR:
Sun Solaris * rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,noac,forcedirectio
AIX (5L) ** cio,rw,bg,hard,intr,rsize=32768,wsize=32768,tcp,noac,vers=3,timeo=600
HPUX 11.23 **** rw,bg,vers=3,proto=tcp,noac,forcedirectio,hard,nointr,timeo=600,rsize=32768,wsize=32768,suid
Windows Not Supported
Linux x86 rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600
Linux x86-64 rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600
Linux - Itanium rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600
-------------
The NFS mount option “forcedirectio” is required on Solaris platforms when mounting the OCR/CRS files when using
Oracle 10.1.0.4 or 10.2.0.2 or later (Oracle bug 4466428)
AIX is only supported with NAS on AIX 5.3 TL04 and higher with Oracle 10.2.0.1 and later (NetApp)
NAS devices are only supported with HPUX 11.23 ONLY
-------
使用linux as3u3作NFS server, hp 11.23作nfs client对oracle 10g是不可以的.
最终处理办法:
在/etc/filesystems中将NFS文件系统的mount选项修改为cio,rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,noac,vers=3,timeo=600,mount时报TCP选项无效,看来跟AIX版本有关,不用理会。启动CRS和数据库,切换日志归档正常。
阅读(5406) | 评论(0) | 转发(1) |