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

一套11.2.0.4的rac库巡检,发现asm实例日志有如下报错

2.5.2
locate alert_+${hst}.log
tail -n 200 /oracle/app/grid/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log
Errors in file /oracle/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_96212.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Sat Apr 13 00:40:13 2024
Errors in file /oracle/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_96217.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128

...

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Sat Jun 08 01:00:04 2024
Errors in file /oracle/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_37329.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Sat Jun 08 01:00:04 2024
Errors in file /oracle/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_37331.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 134612968
..................................................

时间上也没啥规律,隔几天就会来几条。两个rac节点都有。

根据

ORA-27090 - Unable to Reserve Kernel Resources for Asynchronous Disk I/O (Doc ID 579108.1)

确定了现场的aio-max-nr配置就是3145728

但是仍然出现了这个问题。简单看来,还需要将该值调大,但是调多大呢?找到了一片前人改过的更大值:

Oracle 11g RAC 生产库 ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O故障处理记录 - 墨天轮 (modb.pro)

sysctl -w fs.aio-max-nr=50000000

cat /proc/sys/fs/aio-nr

cat /proc/sys/fs/aio-max-nr

vi /etc/sysctl.conf

fs.aio-max-nr = 50000000

sysctl -p

两个rac节点都需要改。无需重启数据库和os。

至于到底是什么偷走了aio异步io资源,可以参见下面这三篇文章。

Oracle:ORA-27090 问题解决总结_ITPUB博客

[Oracle]&[Linux]Linux异步IO的怪事,aio被贼偷走了 (qq.com)

Troubleshooting ORA-27090 async I/O errors with systemtap (pythian.com)

 

相关推荐

  1. <span style='color:red;'>ORA</span>-29548

    ORA-29548

    2024-06-15 12:44:01      37 阅读
  2. Leetcode.2709 最大公约数遍历

    2024-06-15 12:44:01       34 阅读
  3. expdp时报错ORA-31693&ORA-02354&ORA-01555

    2024-06-15 12:44:01       52 阅读
  4. ORA-01031: insufficient privileges

    2024-06-15 12:44:01       59 阅读
  5. 【Oracle】ORA-32017和ORA-00384错误处理

    2024-06-15 12:44:01       73 阅读
  6. 新建pdb 打不开 ORA-65104 ORA-25153

    2024-06-15 12:44:01       28 阅读

最近更新

  1. docker php8.1+nginx base 镜像 dockerfile 配置

    2024-06-15 12:44:01       94 阅读
  2. Could not load dynamic library ‘cudart64_100.dll‘

    2024-06-15 12:44:01       100 阅读
  3. 在Django里面运行非项目文件

    2024-06-15 12:44:01       82 阅读
  4. Python语言-面向对象

    2024-06-15 12:44:01       91 阅读

热门阅读

  1. 媒体查询的屏幕尺寸范围

    2024-06-15 12:44:01       33 阅读
  2. LeetCode 7题:整数翻转(原创)

    2024-06-15 12:44:01       35 阅读
  3. 使用静态方法接受对象参数

    2024-06-15 12:44:01       29 阅读
  4. SpringBoot集成websocket

    2024-06-15 12:44:01       26 阅读
  5. 基于starknet构建应用链之Madara

    2024-06-15 12:44:01       32 阅读
  6. 算法训练营day59

    2024-06-15 12:44:01       32 阅读
  7. SpringBoot集成Elasticsearch实例

    2024-06-15 12:44:01       23 阅读
  8. 什么是JWT?为什么用JWT?JWT的实战案例

    2024-06-15 12:44:01       33 阅读
  9. Android EventLog简介

    2024-06-15 12:44:01       28 阅读
  10. 设置服务器禁止和ip通信

    2024-06-15 12:44:01       29 阅读
  11. 网络安全(补充)

    2024-06-15 12:44:01       32 阅读