ITPUX技术网

交流 . 资讯 . 分享
Make progress together!
Oracle数据库DBA高级工程师培训视频
Oracle数据库培训-备份恢复-性能优化-集群容灾
mysql数据库视频教程

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

内容发布:风哥| 发布时间:2013-12-21 21:41:54
数据库经常会出现以下报错信息:
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.
OR
2.  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.


上一篇:【Oracle故障】Oracle9i RAC建库报错ORA-29807: specified operator does not exist
下一篇:【Oracle故障】ORA-07445: [$cold_qerfxArrayMaxSize()+7456] and ORA-00081
189070296,150201289

专业提供Oracle数据库服务、主机、存储、备份、中间件等相关技术支持服务,QQ号:176140749
关注ITPUX技术网微信公众号itpux_com  ,了解本站最新技术资料的分享.

欢迎加QQ群,提供超多高质量Oracle/Unix/Linux技术文档与视频教程的下载。

Oracle/MySQL/Linux群4-5:189070296  150201289  
Oracle/MySQL/Linux群6-8:244609803   522261684   522651731
备注:请勿重复加群,另请注明 from itpux

加群分享视频教程部分如下:

1、公开课视频:Oracle/MySQL数据库工程师职业发展前景讲解(免费)
http://edu.51cto.com/course/7015.html

2、51CTO学院Oracle数据库高级工程师培训(高薪就业.课程介绍)
http://edu.51cto.com/px/train/131?xiaotu

3、Oracle DBA数据库高级工程师培训视频课程1.1(系列78套+七大阶段+上千案例)
套餐视频地址: http://edu.51cto.com/topic/1121.html

4、MySQL数据库(终身门徒)套餐:http://edu.51cto.com/sd/1e1a6

回复

使用道具 举报

内容发布:weitianyi| 发布时间:2015-4-1 15:17:19
真 不 容 易,  顶 一 下 啦!  
回复 支持 反对

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表