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/，如需轉載，請註明出處，否則將追究法律責任。