在Linux系统下,将另一台aix机器上的存储mount到linux下通过nfs,然后在linux下使用expdp导出数据存储在mount到linux下的磁盘上报错

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Additional information: 6

解决访问

Alter system set events '10298 trace name context forever,level 32'

执行这个命令，不需要重新启动,但在下次数据库重新启动后就失效了，需要再次手工执行。

如果想数据库重新启动后，自动执行这个命令，则执行下面的命令：

SQL>alter system set event='10298 trace name context forever,level 32' scope=spfile;

--------------------------------------------------------------------------------

Linux-6-64下安装Oracle 12C笔记

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

--------------------------------------------------------------------------------

-------------------------------另一例-------------------------------

今天在虚拟机环境下做实验，在将RAC环境修改为flashback on时，报出了ORA-27054错误，错误代码如下：

Errors in file /u01/app/oracle/admin/racdb/udump/racdb2_ora_25551.trc:
ORA-38701: Flashback database log 2 seq 1 thread 2: "/u01/flashback/RACDB/flashback/o1_mf_%u_.flb"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

从错误描述可以看出，闪回目录是通过nfs文件系统来实现的，而系统挂载nfs时，采用了错误的参数选项，导致oracle报错。上网查资料，通过文档359515.1顺利解决问题。整理部分内容如下：

Operating System

rw,bg,hard,nointr,rsize=32768,
wsize=32768,proto=tcp,
noac,vers=3,suid

rw,bg,hard,nointr,rsize=32768,
wsize=32768,proto=tcp,vers=3,
timeo=600

cio,rw,bg,hard,nointr,rsize=32768,
wsize=32768,proto=tcp,noac,
vers=3,timeo=600

cio,rw,bg,hard,intr,rsize=32768,
wsize=32768,tcp,noac,
vers=3,timeo=600

rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp, vers=3,
timeo=600, actimeo=0

rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp,noac,vers=3,
timeo=600

* NFS mount option “forcedirectio” is required on Solaris platforms when mounting the OCR/CRS files when using Oracle 10.1.0.4 or 10.2.0.2 or later (Oracle unpublished bug 4466428)
** AIX is only supported with NAS on AIX 5.3 TL04 and higher with Oracle 10.2.0.1 and later (NetApp)
*** NAS devices are only supported with HPUX 11.23 or higher ONLY

# These mount options are for Linux kernels 2.6 and above for older kernels please check Note 279393.1

Operating System

rw,bg,hard,rsize=32768,
wsize=32768,vers=3,nointr,
proto=tcp,suid

rw,bg,hard,rsize=32768,
wsize=32768,vers=3,intr,
timeo=600,proto=tcp

rw,bg,hard,rsize=32768,
wsize=32768,vers=3,cio,intr,
timeo=600,proto=tcp

* actime=0 or noac can be used

参照上文，修改mount参数如下：

[root@node2 bdump]# cat /etc/rc.d/rc.local
#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local

service iscsi restart
#start_udev

modprobe hangcheck-timer
mount -t nfs -o rw,bg,noac,hard,nointr,rsize=32768,wsize=32768,nolock,proto=tcp,actimeo=0,vers=3,timeo=600 192.168.2.31:/u01/flashback/ /u01/flashback/

问题成功解决！

另外，在网上查到资料，还可以使用如下方式解决

1：设置事件10298 level 32

alter system set event='10298 trace name context forever,level 32' scope=spfile;

重新启动数据库后生效.

2：打补丁:5146667

我没有试验，有兴趣的朋友可以试试，

：

您可能感兴趣的文章: