ORA-27090 故障一例

    最近的alert日志中碰到了ORA-27090的错误信息,其错误提示为Unable to reserve kernel resources for asynchronous disk I/O。根据这个提示来看是跟异步I/O相关的内核参数问题。下面是这个问题的描述与解决。

1、故障错误信息 Wed Sep 10 09:58:17 CST 2014 Errors in file /u01/app/oracle/admin/orclls/bdump/orclls_p000_47020.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: 65536 Wed Sep 10 09:58:17 CST 2014 Errors in file /u01/app/oracle/admin/orclls/bdump/orclls_p002_47024.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: 65536  

2、故障分析 #调用oerr,没有获得比较有价值的信息,如下: suse11b:oracle:orcl102 > 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

#进一步查看trace文件,注,当前数据库版本为10.2.0.5,OS为suse 11 sp3 suse11a:oracle:orcl101 > more /u01/app/oracle/admin/orclls/bdump/orclls_p002_47024.trc /u01/app/oracle/admin/orclls/bdump/orclls_p002_47024.trc Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /u01/app/oracle/product/10.2/db_1 System name:    Linux Node name:      suse11a Release:        3.0.76-0.11-default Version:        #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990) Machine:        x86_64 Instance name: orclls Redo thread mounted by this instance: 1 Oracle process number: 35 Unix process pid: 47024, image: oracle@suse11a (P002)

*** SERVICE NAME:() 2014-09-10 09:58:17.159 *** SESSION ID:(1072.1) 2014-09-10 09:58:17.159 *** 2014-09-10 09:58:17.159 KCRP: blocks claimed = 0, eliminated = 0 ----- Recovery Hash Table Statistics --------- Hash table buckets = 32768 Longest hash chain = 0 Average hash chain = 0/0 = 0.0 Max compares per lookup = 0 Avg compares per lookup = 0/0 = 0.0 ---------------------------------------------- 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: 65536 ----- Recovery Hash Table Statistics --------- Hash table buckets = 32768 Longest hash chain = 0 Average hash chain = 0/0 = 0.0 Max compares per lookup = 0 Avg compares per lookup = 0/0 = 0.0 ---------------------------------------------- #从trace文件中也没有获得比较有价值的信息

3、故障解决 #根据ORA-27090: MESSAGE 27090 NOT FOUND; (文档 ID 579108.1)文档,我们修改内核参数fs.aio-max-nr #由于此数据库为RAC环境下,因此同时调整了2个节点,以下为调整后的情形。 suse11a:~ # grep max-nr /etc/sysctl.conf #fs.aio-max-nr = 1048576 fs.aio-max-nr = 3145728

suse11b:~ # grep max-nr /etc/sysctl.conf #aio-max-nr = 1048576 fs.aio-max-nr = 3145728

suse11a:~ # sysctl -p suse11b:~ # sysctl -p

#配置完毕后可以通过cluvy校验 #几日后观察alert日志,未发现该类错误。

Check: Kernel parameter for "aio-max-nr"   Node Name         Current       Configured    Required      Status        Comment       ----------------  ------------  ------------  ------------  ------------  ------------   suse11a           3145728       3145728       1048576       passed            suse11b           3145728       3145728       1048576       passed          Result: Kernel parameter check passed for "aio-max-nr"

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏bboysoul

linux编译安装apache

wget http://mirrors.ustc.edu.cn/apache/httpd/httpd-2.4.25.tar.gz tar -zxvf http...

30030
来自专栏三杯水

DNS主从服务器搭建

http://blog.51cto.com/yichenyang/1911098 http://blog.51cto.com/wubinary/1379595

21220
来自专栏技术总结

献给移动端的服务器搭建

application.properties这个是项目的一些配置,举例一下默认是8080端口,我们如果想改下端口的话,就可以在配置增加

28520
来自专栏程序猿DD

Spring Boot使用@Async实现异步调用:ThreadPoolTaskScheduler线程池的优雅关闭

上周发了一篇关于Spring Boot中使用 @Async来实现异步任务和线程池控制的文章:《Spring Boot使用@Async实现异步调用:自定义线程池》...

68170
来自专栏杨建荣的学习笔记

生产系统中EXP-00000的问题及解决(66天)

早上刚来的时候,客户的dba就急忙找到我说生产系统exp出问题了。exp的时候报了错误,让我帮着看一下。 > exp xxxxx file=tui.dmp l...

34860
来自专栏菩提树下的杨过

Spring Security笔记:使用数据库进行用户认证(form login using database)

在前一节,学习了如何自定义登录页,但是用户名、密码仍然是配置在xml中的,这样显然太非主流,本节将学习如何把用户名/密码/角色存储在db中,通过db来实现用户认...

20910
来自专栏乐沙弥的世界

mydumper安装及安装故障汇总

   mydumper是针对mysql数据库备份的一个轻量级第三方的开源工具,备份方式术语逻辑备份。它支持多线程,备份速度远高于原生态的mysqldump以及众...

16700
来自专栏软件开发

Spring MVC 学习总结(十一)——IDEA+Maven+多模块实现SSM框架集成

与SSH(Struts/Spring/Hibernate/)一样,Spring+SpringMVC+MyBatis也有一个简称SSM,Spring实现业务对象管...

31320
来自专栏bboysoul

使用永恒之蓝(MS17-010)漏洞入侵windows7

前几天,被勒索病毒(Wannacry)刷屏了,这个病毒是大家知道了备份文件的重要性,当然,我是不怕什么病毒的,因为我是一天备份一次文件,而且微云一份,坚果云,移...

2.7K40
来自专栏醉生梦死

shell脚本--练习1(爬虫)

37740

扫码关注云+社区

领取腾讯云代金券