AIX上mount NFS

在AIX操作系统,所有的mount point信息都存储在文件 :/etc/filesystems
When mount information is not present in this file it can lead to errors.

cat /etc/filesystems
/u08:
        dev             = "/vol/xxxx"
        vfs             = nfs
        nodename        = jq_xxxx_sata
        mount           = false       //表示是否开机自动挂载
        options         = bg,hard,intr,rsize=32768,wsize=32768,timeo=600,vers=3,sec=sys    //挂载参数
        account         = false

导出文件至NFS文件系统时报错:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "********"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 5
Additional information: 18


原因:
nfs文件挂载参数配置不正确


分析:


查看/etc/filesystems
/u08:
        dev             = "/vol/backup"
        vfs             = nfs
        nodename        = jq_netapp_sata
        mount           = false
        options         = bg,hard,intr,rsize=32768,wsize=32768,timeo=600,vers=3,sec=sys
        account         = false


根据文件中写的参数手工挂载:
mount -o rw,bg,hard,intr,proto=tcp,vers=3,rsize=32768,wsize=32768,timeo=600 jq_netapp_sata:/vol/backup /u08




此类问题的官方解决方案罗列如下:
SOLUTION 
=========
To implement the solution, please execute one the following steps:


1. Don't use NFS to create the  files.


Or


2. Add the NFS filesys to '/etc/filesystems' 
--> This is also applicable for 11G


Or


3. Edit init.ora, add the line:
    event="10298 trace name context forever, level 32"    \\此方法需重启数据库


and bounce the database again, if it already exist so that the new parameter is active.


参考文章:
WRONG MOUNT OPTIONS AIX (文档 ID 420582.1)


ORA-19504 ORA-27054 Errors mounting NFS file system (文档 ID 370513.1)
solution:
1) The problem can be solved by using the recommended mounting options which are (in this case): 


(hard,bg,proto=tcp,suid,rsize=32768,wsize=32768,noac)


UG:5146667 - ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS
NOTE:359515.1 - Mount Options for Oracle files for RAC databases and Clusterware when used with NFS on NAS devices
请使用浏览器的分享功能分享到微信等