Category Archives: BUG

Oracle bugs

ORA-600(kkoljt1)错误

Posted on 2012/10/28 by yangtingkun

又是一个ANSI标准SQL导致的BUG。 数据库版本10.2.0.1，错误信息为： Wed Nov 09 19:15:27 2011 Errors IN file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_784.trc: ORA-00600: 内部错误代码, 参数: [kkoljt1], [], [], [], [], [], [], []Wed Nov 09 19:15:27 2011 Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_784.trc: ORA-00600: 内部错误代码, 参数: [kkoljt1], [], [], [], [], [], [], … Continue reading →

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

ORA-7445(_kkdlavc)错误

Posted on 2012/10/27 by yangtingkun

客户10.2.0.1 for Windows出现ORA-7445错误。 没有打过补丁的数据库出现问题的几率果然很大： Thu Mar 29 15:11:50 2012 Errors IN file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_880.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkdlavc+233] [PC:0x7F6661] [ADDR:0x0] [UNABLE_TO_READ] []Thu Mar 29 15:11:50 2012 Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_880.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkdlavc+233] [PC:0x7F6661] [ADDR:0x0] [UNABLE_TO_READ] [] 这个问题是由于访问了一个不正常的视图所致，解决方法就是重建视图。关于这个bug的描述可以参考文档ORA-07445 … Continue reading →

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

ORA-7445(_kkqtnloCbk)错误

Posted on 2012/10/25 by yangtingkun

客户10.2.0.1 for Windows 32数据库出现ORA-7445[_kkqtnloCbk]错误。 告警日志中错误信息为： Tue Nov 08 14:56:39 2011 Errors IN file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4720.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkqtnloCbk+124] [PC:0x1DB818C] [ADDR:0xF5] [UNABLE_TO_READ] []Tue Nov 08 14:56:39 2011 Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4720.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkqtnloCbk+124] [PC:0x1DB818C] [ADDR:0xF5] [UNABLE_TO_READ] [] … Continue reading →

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

ORA-7445(lnxadd)错误

Posted on 2012/10/23 by yangtingkun

一个由于低版本JDBC驱动导致的错误。 告警日志中错误信息为： Fri Aug 12 19:00:03 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl2_ora_28464.trc: ORA-07445: exception encountered: core dump [lnxadd()+471] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Fri Aug 12 19:00:04 2011 Trace dumping IS performing id=[cdmp_20110812190004]Fri Aug 12 19:00:03 2011 … Continue reading →

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

ORA-600(6033)错误

Posted on 2012/10/22 by yangtingkun

客户10.2.0.4 RAC for Linux X64环境，告警日志出现ORA-600(6033)错误。 详细错误信息为： /opt/app/oracle/admin/orcl/udump/orcl1_ora_25075.trc Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production WITH the Partitioning, REAL Application Clusters, OLAP, DATA Mining AND REAL Application Testing options ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1 System name: Linux Node name: hb1 … Continue reading →

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

ORA-600(2801)错误

Posted on 2012/10/21 by yangtingkun

10.2.0.4 RAC环境关闭数据库时出现ORA-600[2801]错误。 详细错误信息为： Mon Apr 11 22:44:24 2011 ALTER DATABASE ADD supplemental log DATA Tue Apr 12 00:11:42 2011 Thread 1 advanced TO log SEQUENCE 3108 (LGWR switch) CURRENT log# 1 seq# 3108 mem# 0: +DATA/orcl/onlinelog/group_1.307.727394923 CURRENT log# 1 seq# … Continue reading →

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

ORA-600(3689)错误

Posted on 2012/10/20 by yangtingkun

这是一个10.2.0.1到10.2.0.4上都存在的bug。 错误发生在DG的STANDBY数据库中： Fri Oct 19 12:01:16 2012 Errors IN file /DATA/oracle/admin/vodapp/bdump/vodapp_mrp0_21304.trc: ORA-00600: internal error code, arguments: [3689], [33], [], [], [], [], [], [] Errors WITH log /baceldba/archive/1_30374_730819916.dbf MRP0: Background Media Recovery TERMINATED WITH error 600Fri Oct 19 12:01:16 2012 … Continue reading →

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

ORA-7445(kgskhighthreshold)错误

Posted on 2012/10/19 by yangtingkun

10.2.0.4 RAC环境的ASM实例出现这个ORA-7445错误。 错误信息为： Fri DEC 3 19:49:49 2010 Errors IN file /opt/app/oracle/admin/+ASM/bdump/+asm2_lck0_19876.trc: Fri DEC 3 19:50:44 2010 Errors IN file /opt/app/oracle/admin/+ASM/bdump/+asm2_ckpt_19863.trc: ORA-07445: exception encountered: core dump [kgskhighthreshold()+32] [SIGSEGV] [Address NOT mapped TO object] [0x0000001F6] [] [] Fri DEC 3 19:51:00 … Continue reading →

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

ORA-600(kjbldrmrpstp:key)错误

Posted on 2012/10/18 by yangtingkun

客户10.2.0.3 RAC环境启动后碰到DRM问题导致实例崩溃。 错误信息为： Mon Jan 19 12:42:58 2009 DATABASE Characterset IS ZHS16GBK replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started WITH pid=28, OS id=4496 Mon Jan 19 12:43:01 2009 Completed: ALTER DATABASE OPEN Mon … Continue reading →

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

ORA-7445(qsmmixComputeClusteringFactor)错误

Posted on 2012/10/17 by yangtingkun

Oracle 11.2.0.2上SQL TUNING的bug。 数据库版本为11.2.0.2 RAC for Solaris，错误信息为： Thu Jul 05 22:00:01 2012 BEGIN automatic SQL Tuning Advisor run FOR special tuning task "SYS_AUTO_SQL_TUNING_TASK" Thu Jul 05 22:28:35 2012 Exception [TYPE: SIGSEGV, Address NOT mapped TO object] [ADDR:0x4] [PC:0x102B3CC08, qsmmixComputeClusteringFactor()+1640] [flags: … Continue reading →

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