ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
1.1报错
ASM Alert一直报这个错误
Errors in file /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_254925.trc: ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Additional information: 3 Additional information: 128 Additional information: 8 Errors in file /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_254925.trc: ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Linux-x86_64 Error: 11: Resource temporarily unavailable Additional information: 3 Additional information: 128 Wed Aug 19 13:38:30 2020
1.2问题分析
> oerr ora 27090 27090, 00000, "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
ORA-27090 - Unable to Reserve Kernel Resources for Asynchronous Disk I/O (Doc ID 579108.1) Oracle Database - Enterprise Edition - Version 10.2.0.4 to 12.2.0.1 [Release 10.2 to 12.2] CAUSE The "aio-max-nr" kernel limit is too low. SOLUTION The "aio-max-nr" kernel limit should be adjusted according to Oracle recommendations which are available in this document: Oracle Validated Configuration: http://linux.oracle.com/pls/apex/f?p=102:2:2007385298933639::NO::P2_VC_ID:426 Also, this parameter should be set as follows: ------------------------------------- fs.aio-max-nr= 3145728 # sysctl -a|grep aio #vi /etc/sysctl.conf #sysctl -a NOTE: Per bug Bug 13554729 - CORRECT FS.AIO-MAX-NR = 3145728 the published limit in the Oracle Documentation at http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#BHCCADGD is incorrect. The Oracle documentation lists the minimum value as the max value.