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

今早发现一BI的oracle数据库的alert日志报如下错误：

Sat Sep 29 09:02:03 2012
Errors in file /home/oracle/admin/tjdb/bdump/tjdb1_p020_4803.trc:
ORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA
Linux-x86_64 Error: 4: Interrupted system call
Additional information: 3
Additional information: 30
Additional information: 65536
Sat Sep 29 09:02:03 2012
Errors in file /home/oracle/admin/tjdb/bdump/tjdb1_p013_4788.trc:
ORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA
Linux-x86_64 Error: 4: Interrupted system call
Additional information: 3
Additional information: 30
Additional information: 65536
Sat Sep 29 09:02:03 2012
Errors in file /home/oracle/admin/tjdb/bdump/tjdb1_p010_4766.trc:
ORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA
Linux-x86_64 Error: 4: Interrupted system call
Additional information: 3
Additional information: 30
Additional information: 65536
Sat Sep 29 09:02:03 2012
Errors in file /home/oracle/admin/tjdb/bdump/tjdb1_p019_4801.trc:
ORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA
Linux-x86_64 Error: 4: Interrupted system call
Additional information: 3
Additional information: 30
Additional information: 65536
Sat Sep 29 09:02:03 2012
Errors in file /home/oracle/admin/tjdb/bdump/tjdb1_p011_4770.trc:
ORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA
Linux-x86_64 Error: 4: Interrupted system call
Additional information: 3
Additional information: 30
Additional information: 65536
Sat Sep 29 09:02:03 2012
Errors in file /home/oracle/admin/tjdb/bdump/tjdb1_p018_4799.trc:
ORA-27090: Message 27090 not found;  product=RDBMS; facility=ORA
Linux-x86_64 Error: 4: Interrupted system call
Additional information: 3
Additional information: 30
Additional information: 65536
Sat Sep 29 09:02:03 2012
Errors in file /home/oracle/admin/tjdb/bdump/tjdb1_p012_4781.trc:

这个是一个rac数据库，这个错误出现在rac的另一个节点重启的时候，所有的并行进程都跳到这个节点上，查看metalink文档发现，是由于操作系统的内核参数的值：aio-max-nr设置太低。

查看现在此参数设置的大小：

[root@cnpl-bidb01 ~]# sysctl -a|grep fs.aio-max-nr
fs.aio-max-nr = 65536

根据metalink文档，将此参数设置为3145728，在/etc/sysctl.conf里面添加：

fs.aio-max-nr = 3145728

执行sysctl -p使其生效。

再查看：

[root@cnpl-bidb01 ~]# sysctl -a|grep fs.aio-max-nr
fs.aio-max-nr = 3145728

 

再观察一段时间看看下次会不会出现此错误。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12129601/viewspace-745414/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12129601/viewspace-745414/