oracle 使用nfs挂載的目錄不能進行歸檔

在做實驗時将oracle的歸檔目錄放在nfs伺服器上，啟動資料庫就會死掉，也不能進行歸檔。

在報警日志中發現

WARNING:NFS file system /mnt mounted with incorrect options

WARNING:Expected NFS mount options: rsize>=16384,wsize>=16384,hard,noac/actimeo=0

Wed Apr 17 06:28:15 2013

Errors in file /u01/oracle/admin/sid31/bdump/sid312_arc1_21845.trc:

ORA-19504: failed to create file "/arc/arc1/2_13_812841120.arc"

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Additional information: 3

ARC1: Error 19504 Creating archive log file to '/arc/arc1/2_13_812841120.arc'

ARC1: Failed to archive thread 2 sequence 13 (19504)

ARCH: Archival stopped, error occurred. Will continue retrying

Wed Apr 17 06:28:18 2013

ORACLE Instance sid312 - Archival Error

ORA-16038: log 3 sequence# 13 cannot be archived

重新修改挂載方式

mount 192.168.1.31:/arc /mnt  -o rsize=65534,wsize=65534,hard,noac,actimeo=0 /mnt

在修改後重新啟動資料庫發現還是起不了

報錯内容：

Errors in file /u01/oracle/admin/sid31/udump/sid312_ora_27149.trc:

ORA-27086: unable to lock file - already in use

Linux Error: 37: No locks available

Additional information: 10

Wed Apr 17 06:32:15 2013

ARCH: Error 19504 Creating archive log file to '/arc/arc1/2_13_812841120.arc'

ARCH: Failed to archive thread 2 sequence 13 (19504)

這個再加一個nolock選項就可以了

mount 192.168.1.31:/arc /mnt  -o rsize=65534,wsize=65534,hard,noac,actimeo=0,nolock /mnt

 本文轉自zhaoyun00 51CTO部落格，原文連結:http://blog.51cto.com/zhaoyun/1179651