Skip to Content
avatar image
Former Member

Oracle process running out of OS kernel I/O resources

Hi All,

Here is our platform:

Oracle Version: 10.2.0.4.0

O/S: Linux x86_64

We are getting the below Error Msg:

ERROR:

===================================================================

WARNING:io_submit failed due to kernel limitations MAXAIO for process=128 pending aio=123 WARNING:asynch I/O kernel limits is set at AIO-MAX-NR=1048576 AIO-NR=64384 WARNING:Oracle process running out of OS kernel I/O resources

===================================================================

To avoid this we recently upgrade the Oracle to 10.2.0.4.0 and applied the below Ipatches also but still we are getting the same error:

p6051177_10204_Linux-x8664.zip

p6024730_10204_Linux-x8664.zip

p5935935_10204_Linux-x8664.zip

p5923486_10204_Linux-x8664.zip

p5895190_10204_Linux-x8664.zip

p5880921_10204_Linux-x8664.zip

p5756769_10204_Linux-x8664.zip

p5747462_10204_Linux-x8664.zip

p5561212_10204_Linux-x8664.zip

p6944036_10204_Linux-x8664.zip

p6826661_10204_Linux-x8664.zip

p6775231_10204_Linux-x8664.zip

p6768114_10204_Linux-x8664.zip

p6679303_10204_Linux-x8664.zip

p6645719_10204_Linux-x8664.zip

p6452766_10204_Linux-x8664.zip

p6379441_10204_Linux-x8664.zip

p6324944_10204_Linux-x8664.zip

p6313035_10204_Linux-x8664.zip

p6151380_10204_Linux-x8664.zip

p6084232_10204_Linux-x8664.zip

p6082832_10204_Linux-x8664.zip

p7573151_10204_Linux-x8664.zip

p7522909_10204_Linux-x8664.zip

p7513673_10204_Linux-x8664.zip

p7300608_10204_Linux-x8664.zip

p7287289_10204_Linux-x8664.zip

p7149863_10204_Linux-x8664.zip

p7027551_10204_Linux-x8664.zip

p6972843_10204_Linux-x8664.zip

p6954829_10204_Linux-x8664.zip

p7592168_10204_Linux-x8664.zip

p8201796_10204_Linux-x8664.zip

p7592346_10204_Linux-x8664.zip

p6705635_10204_Generic.zip

p7252962_10204_Generic.zip

Do we need to set any Oracle parameters?

Thanks And Regards:

Giridhar N

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 05, 2009 at 08:06 AM

    Hello,

    you may have to adjust Linux kernel parameters.

    What kind of Linux is it? (RedHat, SuSE, ..?)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      under the limits.conf i am seeing the below values:

      1. Added for SAP on 2008-07-17 15:25:47 UTC

      @sapsys soft nofile 48000

      @sapsys hard nofile 48000

      @sdba soft nofile 32800

      @sdba hard nofile 32800

      @dba soft nofile 32800

      @dba hard nofile 32800

      still i am getting the same error:

      WARNING:io_submit failed due to kernel limitations MAXAIO for process=128 pending aio=127 WARNING:asynch I/O kernel limits is set at AIO-MAX-NR=65536 AIO-NR=65536 WARNING:Oracle process running out of OS kernel I/O resources (1)

  • avatar image
    Former Member
    May 05, 2009 at 08:11 AM

    Hello Gridihar

    refer to Note 1240150,This should help you solve your issue

    "For Oracle 10.2.0.2 you can use as workaround

    alter system set "_aiowait_timeouts" = 200 scope = spfile;

    or

    set the parameter "_aiowait_timeouts = 200" into the init<SID>.ora

    In any case you need to bounce the database in order that the parameter takes effect.

    With Oracle 10.2.0.4 the parameter aiowaittimeouts = 100 is already implemented. Should the warnings still occur you can use the same workaround as for Oracle 10.2.0."

    Rohit

    Add comment
    10|10000 characters needed characters exceeded