【Oracle故障】ORA-00600: internal error code, arguments: [kkslmtl-valnotfound]

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:354

数据库经常会出现以下报错信息:
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.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】