ORA-600 [kcblasm_1] In 10.2.0.5
admin
2023-05-14 04:02:23
0

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


相关内容

热门资讯

空调制热时为什么有胶味吹出?空...   空调出风口有股烧焦味的原因及处理方法:  1、如果这个味道不是塑料烧焦的味道,可能是在使用电辅热...
买的房子有裂缝怎么办 1、若在验房的时候发现有裂缝,那么就要及时拿着合同去找开发商,并且直接和开发商进行协商,比如要求他们...
马尔代夫史上最严重单次潜水事故... 当地时间14日,在马尔代夫发生一起5名游客在潜水时全部身亡的惨剧。遇难者中包括一名大学教授和她的女儿...
180多万元莫名通过支付宝捐给... “关闭支付功能后 180多万元凌晨莫名通过支付宝捐给慈善机构”一事被曝光后,引发网友高度关注。5月1...
日本自卫队,该去捕熊了 当你清晨起床,看到一头陌生的黑熊正在敲你家的玻璃窗,是什么感觉?今年,日本的“熊灾”愈发厉害了。这些...
美团龙珠等入股AI软件开发商超... 天眼查App显示,近日,上海超维无际电子科技有限责任公司发生工商变更,新增北京龙珠股权投资基金合伙企...
苹果华为高端机降价 华为Pur... 5月15日,618大促前夕,华为苹果率先打响高端手机价格战,iPhone 17 Pro在京东、天猫、...
智启确山·AI赋能 确山县第七... 大象新闻记者 雷刚 通讯员 李闯志 纪兴红 为推进人工智能科普教育,点燃青少年科创梦想,2026年5...
社团焕彩逐光前行 科技赋能筑梦... 为进一步提升全区学校社团建设水平,搭建校际交流互鉴平台,5月12日,梁园区2026年中小学学生社团巡...
吃火锅、蒸桑拿、访企业,这位北... ·明凯,1966年出生,毕业于芬兰赫尔辛基大学政治史专业,2024年起出任芬兰驻华大使至今。当地时间...