【Oracle故障】ORA-00600: internal error code, arguments: [kkslmtl-valnotfound]
数据库经常会出现以下报错信息:
ORA-00600: internal error code, arguments: [kkslmtl-valnotfound], [], [], [], [], [], [], []
经查询,以上报错是oracle 10205 psu5的一个bug,需要安装patch:13349665,metalink文档描述如下: Symptoms:After applying PSU 10.2.0.5.5 the following errors occur from sessions of the DBSNMP user:ORA-00600: internal error code, arguments: [kkslmtl-valnotfound], [], [], [], [], [], [], []With PSU 10.2.0.5.4 applied we had no such problems. Changes:The 10.2.0.5.5 PSU was applied to the database. Cause:The issue is due to unpublished Bug 13349665 ORA-600 [KKSLMTL-VALNOTFOUND] WITH PSU 10.2.0.5.5. The assertion of the ORA-600 [kkslmtl-valnotfound] might be seen for some literal-replaced cursors when CURSOR_SHARING is set to FORCE or SIMILAR. Solution:1. If available for your platform, download and apply Patch:13349665. OR2. Use one of the following workarounds: ?Set cursor sharing to the default value: CURSOR_SHARING=EXACT.or ?Relink the "oracle" executable with the 10.2.0.5.4 PSU "kksl.o" object module, here is an example to do that in AIX platform.: 1. Shutdown the instance (10.2.0.5.5). 2. Backup libserver10.a file. $cd $ORACLE_HOME/lib $cp libserver10.a libserver10.a.102055 3. Extract "kksl.o" from a 10.2.0.5.4 installation. $ar -x -X32_64 libserver10.a kksl.o 4. Copy file kksl.o from step3 to $ORACLE_HOME/lib for 10.2.0.5.5 5. Replace the file kksl.o on 10.2.0.5.5 with the version from 10.2.0.5.4 $ar -rc -X32_64 libserver10.a kksl.o 6. Relink oracle $relink oracle 7. Start up the instance. For specific parameters for the "ar" command on other platforms please contact your OS administrator.