服务器出现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异常实例
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异常实例
解决方案 »
- 大家帮帮我,有没有好点的ORACLE视频推荐。
- 请问下监听程序和net服务名的关系是怎样的
- Oracle sql语句如何写
- oracle 10g oem web访问isql*plus打开连接时候总是报错!
- 急问,Oracle8服务器的最大游标数(Cursors)如何设置??????
- Oracle的触发器中能不能实现一行代码取出:new的所有字段
- 为什么每次重新启动机器后,OracleOraHome92manager Server服务起不来
- 请问哪查到你的Oracle的ip,还有端口?
- 怎么复制一个数据库
- 菜鸟求大神帮忙 PLSQL关于游标取数据的问题
- 请老师指点
- oracle 分页查询数据量不对 急~~~ 在线等
你是不是安装多个,
或有安装失败的经历