Tuesday, May 31, 2011

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

If you notice any one of these errors in Alert.log during startup then the issue is related to “aio-max-nr" kernel limit. You will see this error in 10.2.0.4

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

ORA-27090: UNABLE TO RESERVE KERNEL RESOURCES FOR ASYNCHRONOUS DISK I/O

ORA-27090: Message 27090 not found; product=RDBMS; facility=ORA
Linux-x86_64 Error: 4: Interrupted system call

You will encounter this issue when the "aio-max-nr" kernel limit is too low.

Here is how you can check the value
#/sbin/sysctl -a |grep aio

Solution : Change the "aio-max-nr" kernel limit as per Oracle recommendation
fs.aio-max-nr= 3145728

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com

3 comments: