免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 6582 | 回复: 1
打印 上一主题 下一主题

[数据库] oracle 数据库运行一段时间后自动宕机,求解? [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2013-12-13 20:40 |只看该作者 |倒序浏览
一个生产中用到的数据库出现如下告警日志:遇到这样的问题怎么解决呢,谢谢!

Archived Log entry 60 added for thread 1 sequence 1475 ID 0x89e1442a dest 1:
Fri Dec 13 17:26:30 2013
Errors in file /opt/oracle/diag/rdbms/hrdb/HRDB/trace/HRDB_ora_13649.trc  (incident=15161):
ORA-00600: 内部错误代码, 参数: [kglLockOwnersListDelete], [0x0BE483408], [0x0AFF7FA40], [], [], [], [], [], [], [], [], []ORA-03135: 连接失去联系
Incident details in: /opt/oracle/diag/rdbms/hrdb/HRDB/incident/incdir_15161/HRDB_ora_13649_i15161.trc
Fri Dec 13 17:26:37 2013
opidcl aborting process unknown ospid (13520) as a result of ORA-3113
Fri Dec 13 17:27:13 2013
opidcl aborting process unknown ospid (13649) as a result of ORA-600
Fri Dec 13 17:27:13 2013
Errors in file /opt/oracle/diag/rdbms/hrdb/HRDB/trace/HRDB_pmon_11490.trc  (incident=14817):
ORA-00600: internal error code, arguments: [kglLockOwnersListDelete], [0x0BE483408], [0x0A27318D0], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/hrdb/HRDB/incident/incdir_14817/HRDB_pmon_11490_i14817.trc
Fri Dec 13 17:27:14 2013
Trace dumping is performing id=[cdmp_20131213172714]
Fri Dec 13 17:27:14 2013
Sweep [inc][15161]: completed
Sweep [inc][14817]: completed
Sweep [inc2][15161]: completed
Sweep [inc2][14817]: completed
Fri Dec 13 17:27:37 2013
Errors in file /opt/oracle/diag/rdbms/hrdb/HRDB/trace/HRDB_pmon_11490.trc:
ORA-00600: internal error code, arguments: [kglLockOwnersListDelete], [0x0BE483408], [0x0A27318D0], [], [], [], [], [], [], [], [], []
PMON (ospid: 11490): terminating the instance due to error 472
Instance terminated by PMON, pid = 11490



opt/oracle/diag/rdbms/hrdb/HRDB/trace/HRDB_ora_13649.trc
      Redo pool range [0x0 0x7f80c35df690 0x7f80c35e1e90]
      Undo pool range [0x0 0x7f80c35dce90 0x7f80c35df690]
       chnf control flags 0x100         CHNF hwm uba uba: 0x00000000.0000.00      ----------------------------------------
      SO: 0xbbb80f10, type: 51, owner: 0xbbf529f8, flag: -/-/-/0x00 if: 0x3 c: 0x3
       proc=0xbfe441f0, name=Block List, file=ktlcts.h LINE:175, pg=0
      (List of Blocks) next index = 2
      index   itli   buffer hint   rdba       savepoint
      -----------------------------------------------------------
          0      2   0x85fb8638    0x142fbe0    0x6f9a5e
          1      2   0x8cf95818    0x142f7cd    0x6f9a61
      ----------------------------------------
      SO: 0xbbb80ad8, type: 51, owner: 0xbbf529f8, flag: -/-/-/0x00 if: 0x3 c: 0x3
       proc=0xbfe441f0, name=Block List, file=ktlcts.h LINE:175, pg=0
      (List of Blocks) next index = 10
      index   itli   buffer hint   rdba       savepoint
      -----------------------------------------------------------
          0      3   0x8efe4c58    0x142d49e    0x6f900f
          1      2   0x8ef968b8    0x142d4a0    0x6f9010
          2      3   0x8ef6ee98    0x142d4a3    0x6f9012
          3      3   0x8ef6e518    0x142fd71    0x6f9013
          4      3   0x8efb9478    0x142fd72    0x6f9014
          5      2   0x8efb9a68    0x142d4a8    0x6f9016
          6      2   0x8efb9938    0x142d4aa    0x6f9018
          7      2   0x8ef6e188    0x142fd76    0x6f901a
          8      3   0x8ef6e778    0x142d4ad    0x6f901b
          9      2   0x8efb90e8    0x142fd77    0x6f901d
  ----------------------------------------
  SO: 0x906c4a10, type: 3, owner: 0xbfe441f0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
   proc=0xbfe441f0, name=call, file=ksu.h LINE:11463, pg=0
  (call) sess: cur bdc19858, rec 0, usr bdc19858; flg:20 fl2:1; depth:0
  svpt(xcbnil) sptn:0x6fb0dd uba: 0x00000000.0000.00)
  ksudlc FALSE at location: 6
(k2g table)
error 472 detected in background process
ORA-00600: internal error code, arguments: [kglLockOwnersListDelete], [0x0BE483408], [0x0A27318D0], [], [], [], [], [], [], [], [], []

*** 2013-12-13 17:27:37.802
PMON (ospid: 11490): terminating the instance due to error 472

论坛徽章:
7
天蝎座
日期:2013-08-16 23:19:32丑牛
日期:2014-01-08 09:20:14寅虎
日期:2014-01-11 11:03:44午马
日期:2014-04-28 11:02:40天秤座
日期:2014-05-16 23:24:24摩羯座
日期:2014-07-20 10:46:04卯兔
日期:2014-08-08 15:21:41
2 [报告]
发表于 2013-12-21 11:41 |只看该作者
ORA-00600错误,到metalink查找原因。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP