个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2011-03-01 17:00:00
公司数据库突然宕机，检查alert日志：
tue mar 01 12:12:32 2011
warning: inbound connection timed out (ora-3136)
tue mar 01 13:24:05 2011
thread 1 advanced to log sequence 24954
current log# 2 seq# 24954 mem# 0: d:\oradata\orcl\redo02.log
tue mar 01 14:50:30 2011
thread 1 advanced to log sequence 24955
current log# 3 seq# 24955 mem# 0: d:\oradata\orcl\redo03.log
tue mar 01 15:01:01 2011
process startup failed, error stack:
tue mar 01 15:01:01 2011
errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_364.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
warning: inbound connection timed out (ora-3136)
tue mar 01 13:24:05 2011
thread 1 advanced to log sequence 24954
current log# 2 seq# 24954 mem# 0: d:\oradata\orcl\redo02.log
tue mar 01 14:50:30 2011
thread 1 advanced to log sequence 24955
current log# 3 seq# 24955 mem# 0: d:\oradata\orcl\redo03.log
tue mar 01 15:01:01 2011
process startup failed, error stack:
tue mar 01 15:01:01 2011
errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_364.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
tue mar 01 15:01:02 2011
process m001 died, see its trace file
tue mar 01 15:01:02 2011
ksvcreate: process(m001) creation failed
process m001 died, see its trace file
tue mar 01 15:01:02 2011
ksvcreate: process(m001) creation failed
oracle承认这是一个bug（10.2.0.2.0之前10g版本），bug 5607984 - oracle does not close tcp connections. remains in close_wait state. [on windows 32-bit].可打补丁patch number 5639232 ,该补丁有106m。
给主人留下些什么吧！~~