ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Today, I get the error below from a db server

ADR Home = /opt/oracle/product/diag/asm/+asm/+ASM1:

*************************************************************************

2012-07-16 18:22:02.158000 +08:00

Errors in file /opt/oracle/product/diag/asm/+asm/+ASM1/trace/+ASM1_ora_28871.trc:

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Additional information: 3

Additional information: 128

Additional information: 1227322244

diag/rdbms/spbpro/spbpro1 Alert Log

 

By checking system kernel resources, I believe that “aio-max-nr” kernel limit is too low.

[oracle@ycsdb01 ~]$ /sbin/sysctl -a|grep aio
fs.aio-max-nr = 65536
fs.aio-nr = 56866
[oracle@ycsdb01 ~]$ cat /proc/sys/fs/aio-nr
56738

Solution : Change the “aio-max-nr” kernel limit as following
fs.aio-max-nr= 3145728

About these ads