这篇博客记录了一段Oracle数据库的日志，显示在2012年3月21日，数据库实例orcl11在Linux环境中遇到了操作系统I/O资源限制的问题。具体表现为Oracle进程无法提交异步I/O请求，AIO-MAX-NR和AIO-NR的内核参数设置限制了并发I/O操作。此外，还提到了一个Oracle进程因I/O资源耗尽导致的错误。在日志中，可以看到通过ORADEBUG命令尝试解决该问题。
/u01/app/oracle/admin/ecpdisk/bdump/orcl11_m000_20298.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.0/db_1
System name: Linux
Node name: disk-db1
Release: 2.6.18-194.el5
Version: #1 SMP Tue Mar 16 21:52:39 EDT 2010
Machine: x86_64
Instance name: orcl11
Redo thread mounted by this instance: 1
Oracle process number: 194
Unix process pid: 20298, image: oracle@disk-db1 (m000)
*** ACTION NAME:(Auto-Flush Slave Action) 2012-03-21 16:00:55.474
*** MODULE NAME:(MMON_SLAVE) 2012-03-21 16:00:55.473
*** SERVICE NAME:(SYS$BACKGROUND) 2012-03-21 16:00:55.473
*** SESSION ID:(1063.50673) 2012-03-21 16:00:55.473
WARNING:io_submit failed due to kernel limitations MAXAIO for process=0 pending aio=0
WARNING:asynch I/O kernel limits is set at AIO-MAX-NR=65536 AIO-NR=65504
WARNING:1 Oracle process running out of OS kernelI/O resources aiolimit=0
ksfdgo()+1488
ssd_unwind_bp: unhandled instruction at 0x150ba23 instr=68
*** 2012-03-21 19:56:27.678
Received ORADEBUG command 'unlimit' from process Unix process pid: 30254, *** 2012-03-21 19:56:55.123
Received ORADEBUG command 'dump systemstate 10' from process Unix process pid: 30254, image:
2724
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
