错误挂载选项
适用于:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1
IBM AIX on POWER Systems (64-bit)
IBM AIX Based Systems (64-bit)
AIX5L Based Systems (64-bit)
Symptoms
数据泵导出失败:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining Scoring Engine options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "
/full.Wed.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 6
The dumpfile directory is located on a NFS file system.
OR
Create database failed with:
CREATE DATABASE "test2"
*
ERROR at line 1:
ORA-1501: CREATE DATABASE failed
ORA-200: control file could not be created
ORA-202: control file: '
/control01.ctl'
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 6
原因:
这似乎是在AIX平台上的限制,所有的挂载点信息在当前系统的'/etc/filesystems'文件。当挂载信息不在这个文件中是,回导致错误。
行为被描述为基本的错误:
BUG 4719334 NFS FILE SYSTEM WHERE THE FILE IS CREATED OR RESIDES IS NOT MOUNTED ORA-27054
closed as 'OS-Vendor problem', specific for AIX platforms.
Another bug:
BUG 4968488 NEED A WAY TO AVOID FATAL ORA-27054 ERRORS FROM SKGFIFI FOR NFS FILES
Offers a possibility to workaround this.
解决方法:
禁止对事件的挂载点检查:
"10298 trace name context forever, level 32"
在10.2代码中,事件10298停用NFS的检查。
实施解决方案,请执行下列步骤之一:
1. 不要使用NFS创建文件。
或者
2. 增加NFS filesys 到 '/etc/filesystems'
这也适用于11G
或者
3. 编辑的init.ora,添加一行:
event="10298 trace name context forever, level 32"
and bounce the database again, if it already exist so that the new parameter is active.
然后重试失败的操作。