- 浏览: 4411494 次
- 性别:
- 来自: 厦门
文章分类
- 全部博客 (634)
- Oracle日常管理 (142)
- Oracle体系架构 (45)
- Oracle Tuning (52)
- Oracle故障诊断 (35)
- RAC/DG/OGG (64)
- Oracle11g New Features (48)
- DataWarehouse (15)
- SQL, PL/SQL (14)
- DB2日常管理 (9)
- Weblogic (11)
- Shell (19)
- AIX (12)
- Linux/Unix高可用性 (11)
- Linux/Unix日常管理 (66)
- Linux桌面应用 (37)
- Windows (2)
- 生活和工作 (13)
- 私人记事 (0)
- Python (9)
- CBO (15)
- Cognos (2)
- ORACLE 12c New Feature (2)
- PL/SQL (2)
- SQL (1)
- C++ (2)
- Hadoop大数据 (5)
- 机器学习 (3)
- 非技术 (1)
最新评论
-
di1984HIT:
xuexilee!!!
Oracle 11g R2 RAC高可用连接特性 – SCAN详解 -
aneyes123:
谢谢非常有用那
PL/SQL的存储过程和函数(原创) -
jcjcjc:
写的很详细
Oracle中Hint深入理解(原创) -
di1984HIT:
学习了,学习了
Linux NTP配置详解 (Network Time Protocol) -
avalonzst:
大写的赞..
AIX内存概述(原创)
故障报错
Mon Mar 19 11:30:03 GMT+08:00 2012Errors in file /oracle10g/app/oracle/admin/zgcxdb/udump/zgcxdb2_ora_52166756.trc:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
该报错是由于 打了Patch 7612454这个错误的补丁或者是补丁集中包含该补丁引起的 Bug 7523755,影响版本为10.2.0.5 至10.2.0.5.3,通过打PSU补丁Patch 12419392 升级至10.2.0.5.4或者更高版本可解决该问题。该报错metalink具体信息如下:
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
.
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.
Symptoms
ORA-600 [kcblasm_1] may occur on top of 10.2.0.4 and 11.1.0.7, after applying patch for
Bug 7523755
, or any merge patch that contains this fix.
Changes
This problem only occurs if fix for Bug 7523755
is applied to your system.
Bug 8571015
reported on top of 10.2.0.4, and Bug 8371523
reported on top of 11.1.0.7, confirms that the problem is due to the fix of Bug 7523755
.
Cause
Error:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
Call Stack:
kcblasm1 kcblasm kxhfFndFreeSlot kxhfNewBuffer qerhjGetNewBuffer ksxb1bqb kxhrPack qerhjSplitBuild qertqiFetch
Solution
Development has rebuild patch for Bug:7523755
from MOS.
Please take below steps to resolve this situation:
1. Find out if and when patch Bug:7523755
was applied to your system:
opatch lsinventory -detail
2. If Patch:7523755
or the merge patch, which includes the fix for the Bug:7523755
are older than now available for your platform and version than rollback the patch and apply the new patch.
参考至:https://support.oracle.com/CSP/main/article?cmd=show&id=849381.1&type=NOT
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1133845.1
本文原创,转载请注明出处、作者
如有错误,欢迎指正
邮箱:czmcj@163.com
发表评论
-
AIX平台下磁盘的PVID对ASM磁盘的破坏
2014-03-19 20:53 2740这篇文章将通过两篇MOS文章来讨论AIX平台下为磁盘分配 ... -
Bug 9020054,ORA-8103 BEING HIT DURING GATHERING OF STATISTICS ON TABLE PARTITION
2013-12-01 09:22 1882Bug 9020054 : ORA-8103 ... -
oracle数据库hanganalyze(原创)
2013-06-23 14:11 8333为什么要使用hanganalyzeOracle 数据库“真 ... -
Oracle:并行操作为什么无法执行(老白)
2013-06-23 10:30 5740在一次系统割接的时候,我们碰到一个十分奇怪的现象。由于进行 ... -
补写的2小节DBA日记
2013-06-05 21:52 13896月8日 ITL等待引发的RAC性能问题 从这几天的情况 ... -
ORA-27054故障排除
2013-03-08 17:57 12963在数据备份过程中,由于目标是使用NFS文件系统,因此在导入 ... -
长时间latch free等待——记一次系统异常的诊断过程
2013-01-09 19:17 3737今天发现一个报表数据库中SQL运行异常,简单记录一下问题的诊断 ... -
ORA-15063: ASM discovered an insufficient number of disks for diskgroup(原创)
2012-11-25 16:59 13088ORA-15063: ASM discovered an in ... -
libpthread.so.0: cannot open shared object file解决方法(原创)
2012-11-24 17:33 17761在linux 5上装10G RAC时,常常会碰到“libpth ... -
ora-02020故障诊断详解(原创)
2012-07-16 12:54 3207ORA-2020错发生在一个分布式事务使用的dblink数超过 ... -
Oracle数据库CPU 100%故障诊断实例(原创)
2012-07-05 13:55 16916前言 这两天一只对外提供查询的数据库CPU使用率 ... -
DBA手记:System State转储分析之问题定位
2012-04-19 22:20 2110在 Oracle 数据库的运行过程中,可能会因为一些异常遇 ... -
ORA-02050故障诊断一例
2012-04-05 17:20 8577昨天客户反映说在下午某时间段有几个事务失败了,让我查下当时数据 ... -
ORA-00308: cannot open archived log(原创)
2012-03-23 09:36 16259笔者在为客户配置DG时发现主备库日志无法正常传输,经仔细检查后 ... -
ORA-00600: internal error code, arguments: [kglhdda-bad-free](原创)
2012-03-22 09:16 2963故障报错如下 Thu Mar 15 09:51:29 G ... -
ORA-27300,ORA-27301,ORA-27302: failure occurred at: skgpalive1(原创)
2012-03-22 08:58 3349故障报错如下 Wed Mar 07 16:4 ... -
ora-07445错误相关内容
2012-03-01 17:14 1823本文档主要介绍ora-07445 错误相关内容,并给出了对这 ... -
记一次Oracle 生产库还原归档日志经历(原创)
2012-02-17 10:12 4384中午刚去吃饭,就接到同事电话说急着要恢复生产库上的归档日志。系 ... -
SMON: Parallel transaction recovery tried 引发的问题
2012-01-04 11:26 2399SMON: Parallel transaction rec ... -
ORA-00444,ORA-07446故障排查
2011-12-14 16:58 4651phenomenon startup ORA-00 ...
相关推荐
NULL 博文链接:https://gembler.iteye.com/blog/346242
描述中提到的 "ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059], [0X93953434]" 是一个Oracle数据库内部错误代码,表示遇到了无法处理的系统级异常。ORA-00600错误通常涉及到数据库的内部一致性问题,这可能是...
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
Oracle数据库报错ORA-00600是一个内部错误,通常表示系统遇到了未预见的问题或已知的软件缺陷。这个错误通常与Oracle的内核代码有关,而不是用户的SQL操作。在描述中,我们看到错误与“kcblasm_1”和参数103相关联,...
ORA-07445: exception encountered: core dump [opiaba()+639] [SIGSEGV] [ADDR:0x0] [PC:0x184CD17] ...ORA-00600: internal error code, arguments: [17147], [0x0641B8FE0], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4000], [6], [], [], [], [], [], [] ``` 2. **分析TRC文件:** 根据告警日志中的提示,进一步分析TRC文件,查找相关的块信息。例如: ``` Block header dump: 0x...
ORA-00600: internal error code, arguments: [kcrrrfswda.1], [], [], [], [], [] ORA-00600: internal error code, arguments: [1881], [25860496], [25857716], [] 五、crontab基本知识 crontab是一个 Unix ...
在数据库打开后,新的错误开始出现,比如"ORA-00600: internal error code, arguments: [17147]",这表明还有其他数据块或系统组件可能已损坏。Oracle的600错误通常需要深入的诊断和分析,可能需要使用RMAN(恢复...
——————————————————————————– p align=”JUSTIFY”>ORA-00600:internal error code,arguments:[num],[?],[?],[?],[?] 产生原因:这种错误通常为ORACLE的内部错误,只对OSS和ORACLE...
在重启源库的其中一个节点(11grac2)时,可能遇到错误"ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does"。这通常表示遇到内部错误,可能需要检查Oracle_HOME的设置或数据库服务的启动...
**ORA-00600: internal error code, arguments: [num],[?],[?],[?],[?]** 这是一个非常通用的内部错误代码,表示Oracle数据库遇到了预期之外的低级别问题。这个错误通常是由于系统内部错误、硬件故障、数据损坏或是...
当数据库崩溃并在alert.log中出现错误"ORA-00600: internal error code, arguments: [4194]"时,这通常意味着在Undo块中的最大Undo记录号与Redo块中的Undo记录号之间存在不一致。Oracle在向Undo块添加新记录之前会...