日期:2014-05-16  浏览次数:20439 次

ORA-600 [ktrgcm_3] 解决方法

最近,有一个数据库总是报ORA-00600 ktrgcm_3错误,该数据库的版本为oracle 10.2.0.5.5 for linux x86_64。
具体错误信息如下:
Fri May 25 14:10:41 CST 2012
Errors in file /u01/app/oracle/admin/webdb/udump/webdb1_ora_2979.trc:
ORA-00600: internal error code, arguments: [ktrgcm_3], [], [], [], [], [], [], []
Fri May 25 14:11:14 CST 2012
Trace dumping is performing id=[cdmp_20120525141114]

在metalink上查实,该错误是此版本的bug。参见文档 Bug 14076510 - ORA-600 [ktrgcm_3] in 10.2.0.5.3 - 10.2.0.5.7 [ID 14076510.8]
???
确认影响的产品信息如下:
Product (Component)??? Oracle Server (Rdbms)
Range of versions believed to be affected ??? Versions >= 10.2.0.5 but BELOW 11.1
Versions confirmed as being affected ???

??? 10.2.0.5.7 Patch Set Update
??? 10.2.0.5.6 Patch Set Update
??? 10.2.0.5.5 Patch Set Update
??? 10.2.0.5.4 Patch Set Update
??? 10.2.0.5.3 Patch Set Update

Platforms affected??? Generic (all / most platforms affect

没有提供修复补丁包。但提供的临时解决方法,将隐含参数"_row_cr"设置为FALSE,其副作用是会降低性能。

操作方法如下:

ALTER SYSTEM SET _row_cr=FALSE SCOPE=BOTH SID='*';

官方描述如下:
? 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.
????
这个文档 Ora-600 [Ktrgcm_3] [ID 739745.1]??? 中提供的trc信息和我们webdb1_ora_2979.trc文件中的信息也是一致的。
此文档也可以去参考一下。