ORA-00600: internal error code, arguments: [ktrgcm_3]

本来今天晚上我打算进行Oracle数据字典深入研究的,但是在我马上要研究完的时候收到在北京的一个朋友的消息,说是 他们的生成库出问题了,让我看一下帮忙解决一下,我是非常高兴的,帮助别人是我的快乐,同样也提高了自己,,特此在此时此刻记录一下,写完这篇日志在继续我的研究。

trace日志信息如下:

dbfs/oradata/admin/htdb/udump/htdb_ora_704518.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/10.2.0.5
System name: AIX
Node name: ECMora01
Release: 3
Version: 5
Machine: 00C05BB64C00
Instance name: htdb
Redo thread mounted by this instance: 1
Oracle process number: 206
Unix process pid: 704518, image: oracle@ECMora01


Affects:

Product (Component)Oracle Server (Rdbms)

Range of versions believed to be affectedVersions >= 10.2.0.5 but BELOW 11.1

Versions confirmed as being affected

Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in

  • 10.2.0.5.8 Database Patch Set Update
  • 10.2.0.5 Patch 19 on Windows Platforms
  • 2)
    DescriptionThis problem is introduced in Database PSU version 10.2.0.5.3and can affect 10.2.0.5.3 through 10.2.0.5.7 inclusive. The problem can also occur with interim patch 6157713 installedon top of 10.2.0.5.3 through 10.2.0.5.5 inclusive. ORA-600 [ktrgcm_3] can occur in the above releases. Workaround Disabling rowCR (which is an optimization to reduce consistent-read rollbacks during queries) by setting "_row_cr"=FALSE in the initialization files in one workaround. However, this could cause performance degradation of queries - the statistics "RowCR hits" / "RowCR attempts" can help show if this workaround may be detrimental to performance. Note: This issue was previously incorrectly listed as fixed in Windows 10.2.0.5 bundle 17 but the fix did not get included until bundle 19.
    因此我们可以设置_row_cr这个隐含参数。如和设置该参数可以参考我写的《oracle之参数文件深入探究》见

    ORA-00600: internal error code, arguments: [ktrgcm_3]-LMLPHP

    09-19 00:40