ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-27090: Message 27090 not found; product=RDBMS; facility=ORA

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

原创 Linux操作系统 作者:dcswinner 时间:2012-09-29 10:24:07 0 删除 编辑

今早发现一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博客 ” ,链接:https://blog.itpub.net/12129601/viewspace-745414/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-04-03

  • 博文量
    61
  • 访问量
    556427