本文共 3817 字，大约阅读时间需要 12 分钟。
Tue Dec 1 01:20:25 2009Errors in file /oracle/admin/crmdb/bdump/crmdb1_lms7_2143190.trc:ORA-00600: internal error code, arguments: [kclchkinteg_2], [], [], [], [], [], [], []Tue Dec 1 01:20:25 2009Errors in file /oracle/admin/crmdb/bdump/crmdb1_lms7_2143190.trc:ORA-00600: internal error code, arguments: [kclchkinteg_2], [], [], [], [], [], [], []Tue Dec 1 01:20:26 2009Trace dumping is performing id=[cdmp_20091201012026]Tue Dec 1 01:20:40 2009Errors in file /oracle/admin/crmdb/bdump/crmdb1_lms7_2143190.trc:ORA-00600: internal error code, arguments: [kjmsm_epc], [], [], [], [], [], [], []Tue Dec 1 01:20:41 2009Errors in file /oracle/admin/crmdb/bdump/crmdb1_lms7_2143190.trc:ORA-00603: ORACLE server session terminated by fatal errorORA-00600: internal error code, arguments: [kjmsm_epc], [], [], [], [], [], [], []Tue Dec 1 01:20:43 2009经过和metalink确认，认为此次实例意外终止时由于"Bug 3671867 - OERI[kclchkinteg_2] possible in RAC environment":
Hdr: 3671867 10.1.0.2 RDBMS 10.1.0.2 RAC PRODID-5 PORTID-212 ORA-600Abstract: INSTANCE TERMINATED WITH ORA-600 [KCLCHKINTEG_2]PROBLEM:--------During testing, one instance was terminated with ORA-600 [KCLCHKINTEG_2]DIAGNOSTIC ANALYSIS:--------------------Alert log contains:Thu Jun 3 12:57:26 2004Private_strands 0 at log switchThread 1 advanced to log sequence 153 Current log# 1 seq# 153 mem# 0: +EMDBD1/dbotazc0/onlinelog/group_1.267.1 Current log# 1 seq# 153 mem# 1: +EMDBD1/dbotazc0/onlinelog/group_1.268.1Thu Jun 3 13:41:45 2004Private_strands 0 at log switchThread 1 advanced to log sequence 154 Current log# 2 seq# 154 mem# 0: +EMDBD1/dbotazc0/onlinelog/group_2.269.1 Current log# 2 seq# 154 mem# 1: +EMDBD1/dbotazc0/onlinelog/group_2.270.1Thu Jun 3 13:55:06 2004Errors in file /DBA/nest/oracle/DBOTA1/logs/dbota1_dbw0_82244.trc:ORA-600: internal error code, arguments: [kclchkinteg_2], [], [], [], [],[], [], []Thu Jun 3 13:55:08 2004Errors in file /DBA/nest/oracle/DBOTA1/logs/dbota1_dbw0_82244.trc:ORA-600: internal error code, arguments: [kclchkinteg_2], [], [], [], [],[], [], []Thu Jun 3 13:55:08 2004DBW0: terminating instance due to error 471Thu Jun 3 13:55:08 2004Trace dumping is performing id=[cdmp_20040603135508]Thu Jun 3 13:55:10 2004Dump system state for local instance onlyThu Jun 3 13:55:10 2004Trace dumping is performing id=[cdmp_20040603135510]The only trace file we have been sent is the dbw trace.WORKAROUND:-----------NoneRELATED BUGS:-------------There are several which end in KCLCHKINTEG but not KCLCHKINTEG_2REPRODUCIBILITY:----------------Appears only to have happened once so far.TEST CASE:----------N/ASTACK TRACE:------------ksedmp ksfdmp kgerinv kgeasnmierr kclassertle kclchkinteg kclfwrite1 kcbbic1kcbbiop kcbbdrv ksbabs ksbrdp opirip opidrv sou2o main startSUPPORTING INFORMATION:-----------------------Bruce Carter has looked at this and suggested a bug be raised.Affects: Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions < 10.2 Versions confirmed as being affected * 10.1.0.3 Platforms affected Generic (all / most platforms affected)Fixed: This issue is fixed in * 9.2.0.7 (Server Patch Set) * 10.1.0.4 (Server Patch Set) * 10.2.0.1 (Base Release)Symptoms:Related To: * Internal Error May Occur (ORA-600) * Instance May Crash * ORA-600 [kclchkinteg_2] * RAC (Real Application Clusters) / OPSDescription ORA-600 [kclchkinteg_2] possible in RAC environment
Oracle开发部分确认该3671867 bug已在9.2.0.8中得到修复，建议通过应用9.2.0.8补丁集或者打上来修复该问题；该Bug可能导致实例意外终止，因此其Severity也极高，值得手头仍有9i RAC系统需要管理的dba注意。
本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1277616
转载地址：http://yvgum.baihongyu.com/