当前位置:首页 > 开发 > 数据库 > 正文

ORA-00600: internal error code, arguments: [kglhdda-bad-free](原创)

发表于: 2012-03-22   作者:czmmiao   来源:转载   浏览次数:
摘要: 故障报错如下 Thu Mar 15 09:51:29 GMT+08:00 2012Errors in file /oracle10g/app/oracle/admin/zgscdb/udump/zgscdb2_ora_39322018.trc: ORA-00600: internal error code, arguments: [kglhdda-bad-free], [], [], [],

故障报错如下

Thu Mar 15 09:51:29 GMT+08:00 2012Errors in file /oracle10g/app/oracle/admin/zgscdb/udump/zgscdb2_ora_39322018.trc:
ORA-00600: internal error code, arguments: [kglhdda-bad-free], [], [], [], [], [], [], []

该报错是由于Bug 8298501引起的,受影响的版本有10.2.0.4与10.2.0.5,至今不丁尚未发布,但可以采用设置如下跟踪事件的方式避免报错event="8298501 trace name context forever, level 1"。该报错主要是由于多个会话访问了同一个library cache中的对象,但由于对象没有更新自身的锁链表而导致访问冲突。metalink上的具体描述如下

Bug 8298501  ORA-600 [17070] / ORA-600 [kglhdda-bad-free] under heavy load

 This note gives a brief overview of bug 8298501.
 The content was last updated on: 17-SEP-2011
 Click here for details of each of the sections below.

Affects:

Product (Component ) Oracle Server (Rdbms)
Range of versions believed to be affected Versions BELOW 11.1
Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in
  • (None Specified)

Symptoms:

Related To:

  • (None Specified)

Description

ORA-600 [17070] (in 10.2.0.4 or earlier) or ORA-600 [kglhdda-bad-free] 
(in 10.2.0.5) can occur under heavy concurrency against the same 
library cache object.
 
Rediscovery Notes:
  This problem shows in systemstate dumps as multiple sessions 
  accessing the same library cache object with one process
  holding a library cache lock against the object but the
  session does not show up in the lock owners list.
 
Note: This fix is disabled by default as it introduces 
      an additional latch get. To enable the fix set
      event 8298501 to any non zero level.
      eg: event="8298501 trace name context forever, level 1"

参考至:https://support.oracle.com/CSP/ui/flash.html#tab=KBHome%28page=KBHome&id=%28%29%29,%28page=KBNavigator&id=%28bmDocTitle=Bug%208298501%20-%20ORA-600%20[17070]%20/%20ORA-600%20[kglhdda-bad-free]%20under%20heavy%20load&bmDocType=PATCH&bmDocID=8298501.8&viewingMode=1143&bmDocDsrc=KB&from=BOOKMARK%29%29

本文原创,转载请注明出处、作者

如有错误,欢迎指正

邮箱:czmcj@163.com

ORA-00600: internal error code, arguments: [kglhdda-bad-free](原创)

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

编辑推荐
IDEA编译异常: 编译器 (1.5.0_09) 中出现异常。 如果在 Bug Parade 中没有找到该错误,请在 Java De
说句实在的话,学习jQuery的路是很艰难的,解决某此问题的历程与浪费时间太多。 那些痛苦就不在此分
Internal Server Error 说句实在的话,学习jQuery的路是很艰难的,解决某此问题的历程与浪费时间太
刚才在VS2012测试一个小功能,出现了这个一个如标题错误,它的意思是说,“一个asp.net设置已被发现
Symbian error code : -15 引起原因:启动时没有在XXX.jad设置的MIDlet里加上你要调试的MIDlet,就会
不久前重新安装了Windows7,在安装了VS2010 开发平台之后,将网站发布到IIS,访问发生如下错误: HT
先前写了一个网站,.net framework版本是v3.5的,昨天晚上重写了一些方法,调用一个方法,发现3.5版
PostgreSQL internal variable ON_ERROR_STOP defaults to 0 for interactive common execution, su
An internal error occurred during: "Fetching children of Database". org.slf4j.spi.LocationAwar
http://www.cnblogs.com/syblogs/articles/httperror500.html 昨天在 windows 7 下用 IIS 7.5 运行
版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号