当前位置: 代码迷 >> Oracle技术 >> 在网络不稳定的情况下执行有DBlink的语句后报ORA-07445解决方案
  详细解决方案

在网络不稳定的情况下执行有DBlink的语句后报ORA-07445解决方案

热度:36   发布时间:2016-04-24 08:30:51.0
在网络不稳定的情况下执行有DBlink的语句后报ORA-07445
Alter log 如下:
Thu Dec 08 14:24:16 2011
DISTRIB TRAN XXXDB.ce2e2088.19.41.416066
  is local tran 19.41.416066 (hex=13.29.65942)
  change pending prepared tran, scn=22949660500 (hex=5.57e80754)
  to pending collecting tran, scn=22949660500 (hex=5.57e80754) 
DISTRIB TRAN XXXDB.ce2e2088.19.41.416066
  is local tran 19.41.416066 (hex=13.29.65942))
  delete pending collecting tran, scn=22949660500 (hex=5.57e80754)
Thu Dec 08 14:25:09 2011
Thread 1 advanced to log sequence 41365
  Current log# 2 seq# 41365 mem# 0: D:\ORACLE\XXXSFCDB\REDO02.LOG
Thu Dec 08 14:25:14 2011
Errors in file d:\oracle\bdump\xxxsfcdb_j001_5776.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kpnfch+224] [PC:0xF986B4] [ADDR:0x84] [UNABLE_TO_READ] []

Thu Dec 08 14:26:13 2011
Errors in file d:\oracle\bdump\xxxdb_j000_4908.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kpnfch+224] [PC:0xF986B4] [ADDR:0x84] [UNABLE_TO_READ] []

希望各位大虾帮忙看一下是什么原因导致的.

开始怀疑与网络有关,但经过几次测试后推翻了结论,真的很急,希望各位大虾给予指导。

------解决方案--------------------
请参考:http://blog.sina.com.cn/s/blog_4d22b9720100tk6w.html
  相关解决方案