今天一同事做提交数据库的时候提示内存不足了,再过一会发现监听自动停止了。打开预警日志发现如下错误:
Tue Dec 27 14:41:00 2011 Process startup failed, error stack: Tue Dec 27 14:41:00 2011 Errors in file d:\oracle\product\10.2.0\admin\telemt\bdump\telemt_psp0_1860.trc: ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997 ORA-27301: OS failure message: 重叠 I/O 操作在进行中。 ORA-27302: failure occurred at: skgpspawn
Dump file d:\oracle\product\10.2.0\admin\telemt\bdump\telemt_psp0_1860.trc Tue Dec 27 14:40:39 2011 ORACLE V10.2.0.1.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Windows Server 2003 Version V5.2 Service Pack 1 CPU : 2 - type 586, 1 Physical Cores Process Affinity : 0x00000000 Memory (Avail/Total): Ph:627M/2011M, Ph+PgF:3123M/4880M, VA:510M/2047M Instance name: telemt Redo thread mounted by this instance: 1 Oracle process number: 3 Windows thread id: 1860, image: ORACLE.EXE (PSP0) *** SERVICE NAME:(SYS$BACKGROUND) 2011-12-27 14:40:39.406 *** SESSION ID:(169.1) 2011-12-27 14:40:39.406 *** 2011-12-27 14:40:39.406 Process startup failed, error stack: ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997 ORA-27301: OS failure message: 重叠 I/O 操作在进行中。 ORA-27302: failure occurred at: skgpspawn *** 2011-12-27 14:41:00.406 Process startup failed, error stack: ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997 ORA-27301: OS failure message: 重叠 I/O 操作在进行中。 ORA-27302: failure occurred at: skgpspawn
在网上搜了下,看来还挺多人碰到这个错误的,目前我们的这个数据库是安装在windows系统32位的,而且oracle的版本是10.2.0.1,看来真是oracle的bug了。
解决方法:
1) Reduce the amount of SGA needed to be allocated for the database. 2) Limit the number of dedicated connections to the database and the amount of memory each user process will consume. 3) Change from dedicated connections to multi-threaded server (MTS) connections as MTS only uses a fraction of the amount of memory allocated to each user process when initial connection to the database is established.