iis服务器助手广告广告
返回顶部
首页 > 资讯 > 数据库 >ORA-600 [kcblasm_1] In 10.2.0.5
  • 913
分享到

ORA-600 [kcblasm_1] In 10.2.0.5

2024-04-02 19:04:59 913人浏览 安东尼
摘要

In this Document***Checked for relevance on 18-Jul-2013***InfORMation in this document applies to any p

In this Document


***Checked for relevance on 18-Jul-2013***
InfORMation in this document applies to any platform.oracle Database - Enterprise Edition - Version 10.2.0.5.0 to 10.2.0.5.0 [Release 10.2]APPLIES TO:

SYMPTOMS


Hitting ORA-600 [kcblasm_1] in 10.2.0.5:

In the ALERT:

ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []


The call stack in the generated tracefiles looks similar to:

kcblasm1 kcblasm kxhfFndFreeSlot kxhfNewBuffer qerhjGetNewBuffer ksxb1bqb kxhrPack

 

CHANGES

This problem is hit only in 10.2.0.5, up to PSU 10.2.0.5.4 in which problem is fixed.
Problem is affecting 10.2.0.5 to 10.2.0.5.3.

CAUSE

This is is a known and common problem hit in 10.2.0.5, investigated and corrected in unpublished Bug 7612454.

The problem was introduced in 10.2.0.5, by the fix of Bug:7523755.
This has been corrected in PSU 10.2.0.5.4 and 11.2.


SOLUTION

 To quickest way to the solution of this problem is to apply PSU 10.2.0.5.4, Patch 12419392 or later.

All alternative solutions for this problem are listed below:

  • Upgrade the database to 11.2.

    OR

  • Apply 10.2.0.5.4 Patch Set Update (Patch 12419392) or later PSUs where bug is fixed. 
    The available PSUs are mentioned in "10.2.0.5 Patch Set Updates - List of Fixes in each PSU" (Document 1337394.1)

    OR

  • Apply interim Patch 7612454 on top of 10.2.0.5 (10.2.0.5.0-10.2.0.5.3):

    • For UNIX / linux platforms apply Patch 7612454 available for download on MOS.

    • For windows platforms apply Patch 3 or higher. 
      Please check Document 342443.1 for latest patches available for Windows on top of 10.2.0.5.



Note: 
It is possible to hit ORA-600 [kcblasm_1] in 10.2.0.4 or 11.1.0.7 if an early version of the one-off Patch 7523755 was applied. 
The problem patch Patch 7523755 was quickly removed and a correct version of the patch is since long available for download at MOS.
For details of the problem of hitting ORA-600 [kcblasm_1] in 10.2.0.4 or 11.1.0.7, please take part of Document 849381.1.

REFERENCES

NOTE:849381.1 - ORA-00600 [kcblasm_1] May Occur After Applying The Patch 7523755
BUG:7523755 - ORACLE PROCESS RUNNING OUT OF OS KERNEL I/O RESOURCES EVEN AFTER APPLY 6343215

BUG:8371523 - ORA-600 [KCBLASM1_1], [103], [] LOADING DATA
BUG:9781592 - ORA-600 [KCBLASM_1] [103] DURING HASH JOIN QUERY USE ON DATABASE IN DWH
BUG:9800302 - 10.2.0.5 GETTING ORA-00600 [KCBLASM_1]
BUG:9804132 - INSERT FAILS WITH ORA-600 [KCBLASM_1], [103]

NOTE:1337394.1 - 10.2.0.5 Patch Set Updates - List of Fixes in each PSU
NOTE:209768.1 - Database, FMW, EM Grid Control, and OCS Software Error Correction Support Policy
NOTE:342443.1 - 10.2.0.x Oracle Database and Networking Patches for Microsoft Platforms
NOTE:742060.1 - Release Schedule of Current Database Releases
NOTE:7523755.8 - Bug 7523755 - "WARNING:Oracle process running out of OS kernel I/O resources" messages
NOTE:7612454.8 - Bug 7612454 - More "direct path read" operations / OERI:kcblasm_1

  ORA-600 [kcblasm_1] In 10.2.0.5


您可能感兴趣的文档:

--结束END--

本文标题: ORA-600 [kcblasm_1] In 10.2.0.5

本文链接: https://www.lsjlt.com/news/42980.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑,方便收藏和打印~

下载Word文档
猜你喜欢
软考高级职称资格查询
编程网,编程工程师的家园,是目前国内优秀的开源技术社区之一,形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容,为IT开发者提供了一个发现、使用、并交流开源技术的平台。
  • 官方手机版

  • 微信公众号

  • 商务合作