ORA-600 [kcblasm_1] In 10.2.0.5. (Doc ID 1133845.1)
ORA-600 [kcblasm_1] In 10.2.0.5. (Doc ID 1133845.1)
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.5.0 to 10.2.0.5.0 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 18-Jul-2013***
Symptoms
Hitting ORA-600 [kcblasm_1] in 10.2.0.5:
In the ALERT:
The call stack in the generated tracefiles looks similar to:
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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1245276/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-600(kcblasm_1)錯誤ASM
- ORA-600 kcblasm_1和kghasp1錯誤ASM
- ORA-600(kcblasm_1)和ORA-7445(kxhfNewBuffer)錯誤ASM
- RAC Instance Crash with ORA-600: [Kjbmprlst:Shadow] (Doc ID 740028.1)
- Resolving ORA-600[3020] Raised During Recovery (Doc ID 361172.1)AI
- 修改vip (Doc ID 276434.1)
- HANGFG User Guide (Doc ID 362094.1)GUIIDE
- How to Prepare Storage for ASM (Doc ID 452924.1)ASM
- ORA-600(kjxgrdecidemem1)錯誤IDE
- ORA-600(kfioUnidentify01)錯誤IDE
- Android開發簡單教程.docAndroid
- SQLT Diagnostic Tool (Doc ID 215187.1)SQL
- Oracle Text Health Check (Doc ID 823649.1)Oracle
- The DBMS_SUPPORT Package (Doc ID 62294.1)Package
- DBMS_REPAIR example (Doc ID 68013.1)AI
- Overview of Parameter Reference Notes (Doc ID 68462.1)View
- Linux OS Service 'ntpd' (Doc ID 551704.1)Linux
- ORA-600 [13011] on Delete [ID 456361.1]delete
- ORA-600(kkoipt:invalid join method)錯誤
- Oracle 最新PSU (Doc ID 2118136.2)Oracle
- Backup and Recovery Scenarios (Doc ID 94114.1)iOS
- * Master Note: Database Performance Overview (Doc ID 402983.1)ASTDatabaseORMView
- HP-UX: Asynchronous i/o (Doc ID 139272.1)UX
- Troubleshooting Database Hang Issues (Doc ID 1378583.1)Database
- No Response from the Server, Does it Hang or Spin? (Doc ID 68738.1)Server
- Common Diagnostic Scripts for AUM problems (Doc ID 746173.1)
- How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)DatabaseHive
- Remote Diagnostic Agent (RDA) - RAC Cluster Guide (Doc ID 359395.1)REMGUIIDE
- Troubleshoot Grid Infrastructure Startup Issues (Doc ID 1050908.1)ASTStruct
- ORA-600 [4553] Being Hit [ID 1243704.1]
- backup or restore OLR in 11.2 Grid Infrastructure (Doc ID 1193643.1)RESTASTStruct
- OHASD not Starting After Reboot on SLES (Doc ID 1325718.1)boot
- Oracle10G RMAN Database Duplication (Doc ID 259694.1)OracleDatabase
- Adaptive Cursor Sharing: Worked Example (Doc ID 836256.1)APT
- Master Note - Oracle GoldenGate (Doc ID 1298817.1)ASTOracleGo
- 閃回資料庫-- Doc ID 249319.1資料庫
- Procedure PqStat to monitor Current PX Queries (Doc ID 240762.1)
- RMAN Backup Shell Script Example (Doc ID 137181.1)