We are using the ORACLE database for our internal applications, however today we are getting the below error so here is the 1 command to fix ORA:27090 error in ORACLE.
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
Follow the below steps to fix this ORA-27090 error:
The ORA:27090 error occurs due to lack of system resources configured on the OS level kernel parameter. So, when the /sbin/sysctl parameter “aio-max-nr” kernel limit is set too low, then “ORA-27090: UNABLE TO RESERVE KERNEL RESOURCES FOR ASYNCHRONOUS DISK I/O” error occurs.
The error ORA-27090 can be solved by increasing the “aio-max-nr” kernel limit:
Use the below command to set the kernel parameter:
fs.aio-max-nr= 3145728
After changing the OS Kernel Parameter the issue has resolved :).