27054错误解决两例(2)

Due to Unpublished bug 5856342, it is necessary to use the following init.ora parameter when using NAS
with all versions of RAC on Linux (x86 & X86-64 platforms) until 10.2.0.4. This bug is fixed and included in 10.2.0.4 patchset.
filesystemio_options = DIRECTIO

Single Instance

Operating System

  Mount options for Binaries   Mount options for Oracle Datafiles  
Sun Solaris *
(8, 9, 10)  

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

  rw,bg,hard,rsize=32768,
wsize=32768,vers=3,[forcedirectio or llock],
nointr,proto=tcp,suid  
AIX (5L) **  

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

 
HPUX 11.23 ****   rw,bg,hard,rsize=32768,
wsize=32768,vers=3,nointr,
timeo=600,proto=tcp,suid   rw,bg,hard,rsize=32768,
wsize=32768,vers=3,nointr,
timeo=600,proto=tcp,suid  
Linux x86
#   rw,bg,hard,rsize=32768,
wsize=32768,vers=3,nointr,
timeo=600,tcp   rw,bg,hard,rsize=32768,
wsize=32768,vers=3,nointr,
timeo=600,tcp,actime=0*  
Linux x86-64 #   rw,bg,hard,rsize=32768,
wsize=32768,vers=3,nointr,
timeo=600,tcp   rw,bg,hard,rsize=32768,
wsize=32768,vers=3,nointr,
timeo=600,tcp,actime=0*  
Linux – Itanium   rw,bg,hard,rsize=32768,
wsize=32768,vers=3,nointr,
timeo=600,tcp   rw,bg,hard,rsize=32768,
wsize=32768,vers=3,nointr,
timeo=600,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

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