在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
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10173379/viewspace-2134172/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10173379/viewspace-2134172/