ORA-600 [kclnloc_1] (文档 ID 406791.1)

简介:

一、描述

数据库版本:10.2.0.2
操作系统:AIX 5.3

报错信息如下:
WARNING: inbound connection timed out (ORA-3136)
Wed Oct 18 12:27:46 2017
WARNING: inbound connection timed out (ORA-3136)
Wed Oct 18 12:33:44 2017
Errors in file /oracle/admin/elg/bdump/elg1_lms0_737516.trc:
ORA-00600: internal error code, arguments: [kclnloc_1], [6], [5], [], [], [], [], []
Wed Oct 18 12:33:50 2017
Trace dumping is performing id=[cdmp_20171018123350]
Wed Oct 18 12:33:51 2017
Errors in file /oracle/admin/elg/bdump/elg1_lms0_737516.trc:
ORA-00600: internal error code, arguments: [kclnloc_1], [6], [5], [], [], [], [], []
Wed Oct 18 12:33:58 2017
Errors in file /oracle/admin/elg/bdump/elg1_lms0_737516.trc:
ORA-00600: internal error code, arguments: [kclnloc_1], [6], [5], [], [], [], [], []
Wed Oct 18 12:33:58 2017

LMS0: terminating instance due to error 484
Instance terminated by LMS0, pid = 737516
Wed Oct 18 12:35:05 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 en1 10.10.10.0 configured from OCR for use as a cluster interconnect
Interface type 1 en0 199.1.100.0 configured from OCR for use as  a public interface
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.


二、bug内容

Bug:
ORA-600 [kclnloc_1] (文档 ID 406791.1)

This note gives a brief overview of bug 6733655. 
 The content was last updated on: 15-SEP-2014
 Click here for details of each of the sections below.

Affects:

Product (Component)                                   Oracle Server (Rdbms)
Range of versions believed to be affected    Versions BELOW 11.1
Versions confirmed as being affected    
10.2.0.4/10.2.0.3
Platforms affected    Generic (all / most platforms affected)

Fixed:

The fix for 6733655 is first included in    
11.1.0.6 (Base Release)
10.2.0.5 (Server Patch Set)
10.2.0.4.1 Database Patch Set Update
10.2.0.4 Patch 22 on Windows Platforms
10.2.0.4 RAC Recommended Patch Bundle #3

Interim patches may be available for earlier versions - click here to check.

Description

This bug is only relevant when using Real Application Clusters (RAC)
Under certain circumstances in RAC an internal lock chain may 
get corrupted resulting in a variety of symptoms including 
ORA-600 [kclnloc_1], ORA-600 [kclnrembg] and/or 
dumps in/under kclnloc and kclnrembg.

打最新的10.2.0.4 的PSU!!!










本文转自 roidba 51CTO博客,原文链接:http://blog.51cto.com/roidba/1973794,如需转载请自行联系原作者
目录
相关文章
创建asm disk 磁盘组出错! ORA-15018 And ORA-15107 (Doc ID 2678808.1)
ORA-15018: diskgroup cannot be created ORA-15107: missing or invalid ASM disk name
145 0
|
存储 Oracle 关系型数据库
ORACLE:根据父id查询所有子孙数据,或者根据子id查询所有父数据(start with connect by prior)
一、需求: 我们在开发中经常遇到一种数据库表的设计:一个表中包含父子信息数据,也就是常说的树形数据. —> 最常见的例子就是省市区一体表,就是通过id、pid、level来进行控制,从而一张表来存储数据.我们进行拿数据的时候,不用再连表拿取,直接通过(start with connect by prior)直接便利就会得到数据.
768 2
ORACLE:根据父id查询所有子孙数据,或者根据子id查询所有父数据(start with connect by prior)
|
SQL Oracle 关系型数据库
Oracle 使用DB link update table & TNS:linstener was not given the servicename in connect_data处理方式
业务需求:需要在Oracle1 的A表增加一个字段,这个字段来自于Oracle2 的B表的一个字段。
124 0
|
Oracle 关系型数据库
Oracle创建Sequence时Order/NoOrder选项
Oracle创建Sequence时Order/NoOrder选项
318 0
ORA-01400: 无法将 NULL 插入 ("S01"."A02_EMPLOYEES"."ID") 错误
这个问题很多时候是没有为该表建立触发器导致的,或者是sequence没建立,或者是trigger没建立。 建立其中一个或两个即可。
530 0
|
SQL Oracle 关系型数据库
关于ORACLE通过file_id与block_id定位数据库对象遇到的问题的一点思考
在ORACLE中,我们可以通过file_id(file#)与block_id(block#)去定位一个数据库对象(object)。例如,我们在10046生成的trace文件中file#=4 block#=266 blocks=8,那么我可以通过下面两个SQL去定位对象   SQL 1:此SQL效率较差,执行时间较长。
1132 0
|
关系型数据库 数据库 Oracle
【MOS】 EXPDP - ORA-39166 (Object Was Not Found) (文档 ID 1640392.1)
                                                                                           ...
1117 0

热门文章

最新文章