服务器出现szedis实例自动停掉的情况,查看alert log日记和trc基本情况如下,有没高手能够分析下是什么原因导致的,是否有解决方案呢??alert log日记:Wed Jun 19 09:28:17 2013
Errors in file d:\oracle\product\10.2.0\db_1\rdbms\trace\szedis_ora_5172.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc]
[PC:0x646381E] [ADDR:0x18] [UNABLE_TO_READ] []Wed Jun 19 09:29:40 2013
Process startup failed, error stack:
Wed Jun 19 09:29:40 2013
Errors in file d:\oracle\product\10.2.0\admin\szedis\bdump\szedis_psp0_3900.trc:
ORA-27300: OS 系统相关操作: spcdr:9261:4200 失败, 状态为: 997
ORA-27301: OS 系统故障: 重叠 I/O 操作在进行中
ORA-27302: 错误发生在: skgpspawnWed Jun 19 09:29:41 2013
Process J000 died, see its trace file
Wed Jun 19 09:29:41 2013
kkjcre1p: unable to spawn jobq slave process
Wed Jun 19 09:29:41 2013
Errors in file d:\oracle\product\10.2.0\admin\szedis\bdump\szedis_cjq0_5196.trc:Wed Jun 19 09:30:41 2013
Errors in file d:\oracle\product\10.2.0\db_1\rdbms\trace\szedis_ora_5136.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc]
[PC:0x646381E] [ADDR:0x18] [UNABLE_TO_READ] []
szedis_ora_5172.trc文件内容:Dump file d:\oracle\product\10.2.0\db_1\rdbms\trace\szedis_ora_5172.trc
Wed Jun 19 09:28:17 2013
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU                 : 8 - type 8664, 2 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:329M/20478M, Ph+PgF:8M/23876M
Instance name: szedisRedo thread mounted by this instance: 0 <none>Oracle process number: 0Windows thread id: 5172, image: ORACLE.EXE (SHAD)
*** 2013-06-19 09:28:16.031
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x646381E] [ADDR:0x18] [UNABLE_TO_READ] []
Current SQL information unavailable - no SGA.
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
clsdcxini+62                  0000000000000000     000000000 000000000 000000000
                                                   000000000
clsdinit+82          CALL???  clsdcxini+62         1EA78E218 000000011 000000000
                                                   000000001
ksdnfy+256           CALL???  clsdinit+82          000000000 000000000 000000000
                                                   000000000
kscnfy+691           CALL???  ksdnfy+256           000000003 000000000 000000000
                                                   0059CAB58
opiino+151           CALL???  kscnfy+691           000000007 000000000 000000000
                                                   000000000
opiodr+1305          CALL???  opiino+151           00000003C 000000004 1EA78FBB0
                                                   000000000
opidrv+815           CALL???  opiodr+1305          00000003C 000000004 1EA78FBB0
                                                   000000000
sou2o+52             CALL???  opidrv+815           10000003C 100000004 1EA78FBB0
                                                   7FF7FC48580
opimai_real+131      CALL???  sou2o+52             000000000 1EA78FCB0
                                                   7FFFFEDB258 078EE478C
opimai+96            CALL???  opimai_real+131      7FF7FC48580 7FFFFEDA000
                                                   0001F0003 000000000
OracleThreadStart+6  CALL???  opimai+96            1EA78FF00 1E937FF3C 1EA78FCD0
09                                                 7FF7FC48580
0000000078D3B71A     CALL???  OracleThreadStart+6  1E937FF3C 000000000 000000000
                              09                   1EA78FFA8Oracle异常实例