今天一同事做提交数据库的时候提示内存不足了,再过一会发现监听自动停止了。打开预警日志发现如下错误:
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
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
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.