ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【故障-ORACLE】ORA-00600: [qesmmCValStat4], [3], [1] 故障处理

【故障-ORACLE】ORA-00600: [qesmmCValStat4], [3], [1] 故障处理

原创 Linux操作系统 作者:浪漫双鱼 时间:2011-11-15 12:47:48 0 删除 编辑

操作系统:Windows Server 2003 Version V5.2 Service Pack 1

数据库版本:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production

日志报错:

Fri Nov 11 11:46:35 2011

Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_10012.trc:

ORA-00600: 内部错误代码, 参数: [qesmmCValStat4], [3], [1], [], [], [], [], []

 

Fri Nov 11 11:46:43 2011

Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_10012.trc:

ORA-00600: 内部错误代码, 参数: [qesmmCValStat4], [3], [1], [], [], [], [], []

 

又一个ORA-600错误,在matelink上查询了下,发现和Bug 4401437 - CONNECT BY query may fail with OERI qergiStart1相吻合。

Bug 4401437 - CONNECT BY query may fail with OERI:qergiStart1 / OERI:qesmmCValStat4 [ID 4401437.8]


Bug 4401437  CONNECT BY query may fail with OERI:qergiStart1 / OERI:qesmmCValStat4

 This note gives a brief overview of bug 4401437. 
 The content was last updated on: 03-APR-2009
 Click 
 for details of each of the sections below.

Affects:

Product (Component)

Oracle Server (Rdbms)

Range of versions believed to be affected

Versions < 11

Versions confirmed as being affected

Platforms affected

Generic (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

Description

A connect-by query may fail with ORA-600 [qergiStart1]

 

Workaround

  Add a "no_filtering" hint to the query.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

References

 (This link will only work for PUBLISHED bugs)
 Information on the sections in this article

 

    以上文章显示这是oracleconnect by分析函数的一个bug,采用Add a "no_filtering" hint to the query的方式处理,发现虽然不再报错,但查询出来的数据不准确。最终建议客户升级数据库到10.2.0.4稳定版本。

    不过升级数据库是个大操作,需要经过严密的应用测试才能实施。所以我建议重启数据库测试下,通过重启数据库释放资源,改变了触发bug的系统环境,使数据库恢复了正常。

 

 

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11088128/viewspace-710955/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-10

  • 博文量
    87
  • 访问量
    243675