ORA-27090 Unable to Reserve Kernel Resources Error

I got ” ORA-27090 Unable to Reserve Kernel Resources Error ”  error in Oracle database.

ORA-27090 Unable to Reserve Kernel Resources Error

Details of error are as follows.

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

Cause: The system call to reserve kernel resources for asynchronous I/O has failed.

Action: Check errno

Unable to reserve kernel resources for asynchronous disk I/O

This ORA-27090 is related with the system call to reserve kernel resources for asynchronous I/O has failed.

You discover messages of this nature in your alert log:

– OR –

– OR –

Strace against DBWR shows:

which is related to “aio-max-nr” kernel limit.

The “aio-max-nr” kernel limit is too low.

The “aio-max-nr” kernel limit should be adjusted according to Oracle recommendations which are available in this document:

Also, this parameter should be set as follows:
————————————-
fs.aio-max-nr= 3145728
————————————-

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )