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