Oracle数据库使用NFS存储,启动报错提示无法锁定文件

2014-11-24 17:57:05 · 作者: · 浏览: 0

SQL> startup


> ORA-10997: another startup/shutdown operation of this instance inprogress


> ORA-09968: unable to lock file


> Linux-x86_64 Error: 37: No locks available


> Additional information: 64


message文件报错信息:(192.168.0.200为netapp存储地址)


> Jun 6 18:21:19 eccdemo sm-notify[3707]: Unable to notify bogon, giving up


> Jun 6 18:39:18 eccdemo rpc.statd[3705]: No canonical hostname found for 192.168.0.200


> Jun 6 18:39:18 eccdemo rpc.statd[3705]: STAT_FAIL to eccdemo for SM_MON of 192.168.0.200


> Jun 6 18:39:18 eccdemo kernel: lockd: cannot monitor 192.168.0.200


> Jun 6 18:39:33 eccdemo rpc.statd[3705]: No canonical hostname found for 192.168.0.200


> Jun 6 18:39:33 eccdemo rpc.statd[3705]: STAT_FAIL to eccdemo for SM_MON of 192.168.0.200


> Jun 6 18:39:33 eccdemo kernel: lo


> ckd: cannot monitor 192.168.0.200


解决办法:


按照oracle官方文档,需要增加挂载参数


mount -t nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp,actimeo=0 192.168.0.200:/vol/oraclenfs /oracle


具体挂载参数需要参考官方文档,每个版本是不一样的。


RAC



* 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 unpublished 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 or higher ONLY
**** As per BUG 11812928, the 'intr' & 'nointr' are deprecated in OEL 5.6 kernels and up including Oracle Linux 6. It is harmless to still include it, but the "NFS: ignoring mount option: nointr" will appears. This message can be ingnored.



# These mount options are for Linux kernels 2.6 and above for older kernels please check Note 279393.1




* actime=0 or noac can be used