Category Archives: BUG

Oracle bugs

统计信息收集出现DFS等待导致实例HANG死

Posted on 2013/07/07 by yangtingkun

客户10.2.0.4 RAC环境，出现大量的library cache lock和cursor: pin S wait on X等待，经分析是由于统计信息收集僵死导致的。 数据库在8点到9点期间，数据库两个节点都存在明显的cursor: pin S wait on X和library cache lock的等待： Event Waits Time(s) Avg   Wait(ms) %   Total Call Time Wait   Class cursor:   pin S wait on X 1,573,056 30,651 … Continue reading →

Posted in BUG | Tagged , , , , | Leave a comment

ORA-600(kposcws-2)错误

Posted on 2013/07/06 by yangtingkun

客户11.2.0.2 RAC环境出现ORA-600[kposcws-2]错误。 错误信息为： Thu Sep 27 10:48:15 2012 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_34145026.trc (incident=682292): ORA-00600: 内部错误代码, 参数: [kposcws-2], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_682292/orcl1_ora_34145026_i682292.trcThu Sep 27 10:48:15 2012 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_34145026.trc … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(kollasg:client-side tmp lob)错误

Posted on 2013/07/05 by yangtingkun

客户11.2.0.3 RAC环境，出现ORA-600[kollasg:client-side tmp lob]错误。 错误信息为： Thu Apr 28 20:54:53 2011 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_31916032.trc (incident=148665): ORA-00600: 内部错误代码, 参数: [kollasg:client-side tmp lob], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_148665/orcl1_ora_31916032_i148665.trc Thu Apr 28 20:54:59 … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

ORA-600(ksxp_rm_check0)错误

Posted on 2013/07/04 by yangtingkun

客户11.2.0.3 RAC的ASM实例出现ORA-600[ksxp_rm_check0]错误。 错误信息如下： Tue Jul 02 19:22:59 2013 Errors IN file /u01/app/grid/diag/asm/+asm/+ASM2/trace/+ASM2_ora_6488960.trc (incident=165804): ORA-04031: unable TO allocate 3000 bytes OF shared memory ("shared pool","select INSTANCE_NUMBER , IN…","sga heap(1,0)","call") USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 … Continue reading →

Posted in BUG | Tagged , , , , , , , , | Leave a comment

11.2.0.3 ASM实例出现ORA-4031导致数据库归档失败

Posted on 2013/07/03 by yangtingkun

客户的11.2.0.3 RAC数据库出现了归档失败的情况，导致单个实例出现HANG死的状况。 检查错误信息发现： Tue Jul 02 16:49:13 2013 ARC1: Error 19504 Creating archive log file TO ‘+DATA02’ ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance orcl1 – Archival Error ORA-16038: log 14 SEQUENCE# 68244 cannot be archived ORA-19504: … Continue reading →

Posted in BUG | Tagged , , , , , , , , | Leave a comment

ORA-7445(ptmax)错误

Posted on 2013/07/02 by yangtingkun

一个9.2.0.8上的bug。 虽然12c已经发布，但是仍然有部分客户的核心数据库还跑在9i环境上，有碰到了一个9208上的bug。 Thu May 16 14:18:48 2013 Errors IN file /oracle/oracle/admin/orcl/udump/orcl_ora_11922.trc: ORA-07445: 出现异常: 核心转储 [00000001023A0F08] [SIGSEGV] [Address NOT mapped TO object] [0x000000010] [] [] Thu May 16 14:19:49 2013 Errors IN file /oracle/oracle/admin/orcl/udump/orcl_ora_12389.trc: ORA-07445: 出现异常: 核心转储 [00000001023A0F08] [SIGSEGV] [Address NOT … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

ORA-600(ktsfbfmt:objdchk_kcbnew_3)错误

Posted on 2013/06/29 by yangtingkun

客户的11.2.0.3 RAC环境出现ORA-600[ktsfbfmt:objdchk_kcbnew_3]错误。 错误信息为： Sat May 18 01:37:23 2013 Errors IN file /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j009_13090.trc (incident=1002558): ORA-00600: 内部错误代码, 参数: [ktsfbfmt:objdchk_kcbnew_3], [3], [5370496], [0], [], [], [], [], [], [], [], [] Incident details IN: /oracle/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_1002558/orcl1_j009_13090_i1002558.trc USE ADRCI OR Support Workbench TO package the … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(kcbchg1_12)和ORA-600(kdifind:kcbget_24)错误

Posted on 2013/06/28 by yangtingkun

客户11.2.0.3 RAC for Aix上出现的错误。 在客户环境中，上述两个错误都出现了： Sun May 19 01:20:41 2013 Errors in file /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j003_32468.trc (incident=1002135): ORA-00600: 内部错误代码, 参数: [kdifind:kcbget_24], [5296768], [1], [0], [1], [], [], [], [], [], [], [] ORA-06512: 在 “CP_TMS.TMP_P_TMS_MAIL_AGENCY_OUT”, line 386 ORA-06512: 在 line 2 Incident … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

Logminer获取UNKNOWN的USERNAME

Posted on 2013/06/27 by yangtingkun

客户反馈尝试通过LOGMINER获取USERNAME和PROGRAM信息，但是即使打开了SUPPLEMENTAL LOG，仍然到得UNKNOWN的结果。 查询了MOS文档，果然找到了一个对应的BUG：Some Column Values Change To UNKNOWN Or NULL When Querying V$LOGMNR_CONTENTS [ID 1307497.1]。 当在START_LOGMINER的时候指定了START_SCN并在OPTIONS中指定了DDL_DICT_TRACKING时，查询V$LOGMNR_CONTENTS视图，第一次访问可以得到正确的USERNAME、MACHINE_NAME、OS_USERNAME、SESSION_INFO等信息，但是再次查询上述列会变成NULL或者UNKNOWN。 这个BUG影响版本从10.2.0.4到11.2.0.2，在11.2.0.3中被FIXED，Oracle还提供了单独了PATCH 10129774来解决这个问题。不过其实最简单避免这个错误的方法就是在START_LOGMINER后，通过CREAT TABLE的方式将V$LOGMNR_CONTENTS视图的内容保留下来，这其实也可以避免多次扫描V$LOGMNR_CONTENTS视图造成后台进行多次的日志挖掘。

Posted in BUG | Tagged , , , , , , , , , | Leave a comment

ORA-600(kjbrref:pkey)错误

Posted on 2012/11/27 by yangtingkun

客户数据库碰到这个ORA-600错误，导致实例崩溃。 详细错误信息为： Fri Nov 23 23:38:46 2012 minact-scn: Master returning AS live inst:2 has inc# mismatch instinc:4 cur:6 errcnt:0 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lms1_2097994.trc (incident=1520217): ORA-00600: internal error code, arguments: [kjbrref:pkey], [7232], [107], [249516], [0], [], [], [], [], [], [], … Continue reading →

Posted in BUG | Tagged , , , , , , | Leave a comment