Error/Issue:
Database unable to use/create file on NFS mount point faild with following Error:
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 5
Tue Oct 02 11:20:42 2012
WARNING: NFS file system /oracle_mnt not mounted with correct options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
WARNING: NFS file system /oracle_mnt not mounted with correct options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
WARNING: NFS file system /oracle_mnt not mounted with correct options
WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,
ORA-205 signalled during: ALTER DATABASE MOUNT...
Problem:
In the above case , NFS was mounted with default rsize and wsize option and oracle doesn't like any NFS mount write/read size values (wsize) less than 32k.
AIX /etc/filesystems etntry :
/oracle_mnt:
dev = /DBA
mount = true
vfs = nfs
nodename = server_name or IP
options = rw,sort
type = nfs_mount
which is clearly written to alert.log file with Warning message.
Solution :
Mount the NFS with correct option , high lighted in the Warning message. Entry updated to following fixed the problem.
/oracle_mnt:
dev = /DBA
mount = true
vfs = nfs
nodename = server_name or IP
options = rw,hard,rsize=32768,wsize=32768
type = nfs_mount
Oracle recommend options are
rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600
for details Pls refer to
3.2.6 Checking NFS Mount and Buffer Size Parameters for Oracle Clusterware
Link http://docs.oracle.com/cd/E11882_01/install.112/e22489/storage.htm#CWLIN272
