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