oracle多进程阻塞,oracle并行进程的ORA-27090故障的解决

RAC数据库出现ORA-27090错误

/u01/app/oracle/admin/yyjm/bdump/yyjm2_p000_6379.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1

System name:Linux

Node name:node6

Release:2.6.18-92.el5

Version:#1 SMP Tue Apr 29 13:16:15 EDT 2008

Machine:x86_64

Instance name: yyjm2

Redo thread mounted by this instance: 2

Oracle process number: 42

Unix process pid: 6379, image: oracle@node6 (P000)

*** SERVICE NAME:(SYS$BACKGROUND) 2013-05-04 07:19:48.850

*** SESSION ID:(716.11196) 2013-05-04 07:19:48.850

*** 2013-05-04 07:19:48.850

Start recovery for domain 0, valid = 0, flags = 0x1

*** 2013-05-04 07:19:49.082

KCRP: blocks claimed = 10, eliminated = 0

----- Recovery Hash Table Statistics ---------

Hash table buckets = 4194304

Longest hash chain = 1

Average hash chain = 10/10 = 1.0

Max compares per lookup = 0

Avg compares per lookup = 0/10 = 0.0

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

ORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA

Linux-x86_64 Error: 4: Interrupted system call

Additional information: 3

Additional information: 128

Additional information: 65536

----- Recovery Hash Table Statistics ---------

Hash table buckets = 4194304

Longest hash chain = 1

Average hash chain = 10/10 = 1.0

Max compares per lookup = 1

Avg compares per lookup = 33/33 = 1.0

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

该问题是发生在RAC一个节点崩溃后，所有的错误都发生在并行进程PNNN上。MOS上说这个问题是由于系统参数配置不当所致：ORA-27090: MESSAGE 27090 NOT FOUND; [ID 579108.1]。

内核参数的值：aio-max-nr设置太低，推荐设置为fs.aio-max-nr= 3145728。修改参数使用/sbin/sysctl -p重新加载参数后，重启数据库即可。

下面是OTN上对该问题的讨论