Category Archives: BUG

Oracle bugs

ORA-600(13013)错误

Posted on 2012/01/10 by yangtingkun

客户环境中出现ORA-600(13013)错误。 错误信息如下： Mon DEC 26 23:13:00 2011 Errors IN file /oracle/admin/htzback/udump/htzback_ora_32522.trc: ORA-00600: 内部错误代码, 参数: [13013], [5001], [52828], [625368235], [67], [629556358], [17], []Mon Dec 26 23:13:00 2011 Errors in file /oracle/admin/htzback/udump/htzback_ora_32522.trc: ORA-00600: 内部错误代码, 参数: [13013], [5001], [52828], [625368235], [67], [629556358], [17], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(16608)错误

Posted on 2012/01/08 by yangtingkun

客户10.2.0.4环境出现ORA-600(16608)错误。 详细错误信息如下： Sun DEC 19 11:17:41 2010 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_j005_5937.trc: ORA-00600: internal error code, arguments: [16608], [2], [3], [0x8000002C4FA00DC0], [], [], [], []Sun Dec 19 11:17:41 2010 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_j005_5937.trc: ORA-00600: internal error code, arguments: [16608], [2], [3], … Continue reading →

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

ORA-600(ksmals)错误

Posted on 2012/01/07 by yangtingkun

客户数据库出现ORA-600(ksmals)错误。 错误信息为： Tue Nov 22 11:39:02 2011 Errors in file /oracle9/app/admin/db/udump/db1_ora_2319324.trc: ORA-00600: internal error code, arguments: [ksmals], [sql txt in kkslod], [], [], [], [], [], [] 查询这个错误，确认是Oracle的bug，详细描述可以参考：ORA-600 [ksmals], [sql txt in kkslod], [] Selecting Against x$kgllk [ID 550066.1]。这个问题影响9.2到11.1之间的所有版本。当查询x$kgllk内部表，或基于这个内部表的视图时，就可能引发这个问题。 从对应的trace文件中可以看到，导致错误的SQL在查询V$OPEN_CURSOR和V$SQL视图： … Continue reading →

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

ORA-600(ttcgcshnd-2)错误

Posted on 2012/01/05 by yangtingkun

客户数据库出现这个错误信息。 以前碰到过一个很老的bug，错误信息和当前十分接近，为ttcgcshnd-1，导致问题的原因是较低的jdbc驱动所致，详细情况可以参考：http://yangtingkun.itpub.net/post/468/461992 当前的问题并不太一样，导致问题的主要原因是用户取消了操作： Mon DEC 5 10:13:50 2011 Errors IN file /oracle9/app/admin/db/udump/db1_ora_1867892.trc: ORA-00600: internal error code, arguments: [ttcgcshnd-2], [0], [], [], [], [], [], [] ORA-01013: USER requested cancel OF CURRENT operation Mon DEC 5 10:13:51 2011 Trace dumping IS … Continue reading →

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

ORA-600(KGHALO4)错误

Posted on 2012/01/03 by yangtingkun

客户数据库频繁出现这个错误。 详细的错误信息为： Sat DEC 31 21:26:23 2011 Errors IN file /opt/app/oracle/admin/ynwcdma/bdump/ynwcdma_pmon_5510.trc: ORA-00600: 内部错误代码, 参数: [KGHALO4], [0xC0000003E80CD060], [], [], [], [], [], [] Error occured while spawning process CJQ0; error = 600 Sat DEC 31 21:26:25 2011 Errors IN file /opt/app/oracle/admin/ynwcdma/bdump/ynwcdma_pmon_5510.trc: … Continue reading →

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

数据泵导出碰到ORA-600(kcbz_check_objd_typ_3)错误

Posted on 2012/01/01 by yangtingkun

客户的数据库崩溃，被强制打开后，使用数据泵导出出现ORA-600(kcbz_check_objd_typ_3)错误。 以前碰到过一个ORA-600(kcbz_check_objd_typ_3)错误，是由于客户利用不同版本软件创建了控制文件，尝试打开数据库所致。详情可以参考：http://yangtingkun.itpub.net/post/468/517661 这次的情况其实有类似的地方，客户的数据库出现ORA-600(4000)的错误，被我们强制打开后，肯定数据字典存在不一致的情况。 导出时详细错误信息如下： [oracle] % expdp system/manager directory=d_output dumpfile=full_bk_2011123101.dmp FULL=y logfile=full_bk_2011123101.log parallel=4 Export: Release 10.2.0.1.0 – 64bit Production ON 星期六, 31 12月, 2011 23:02:46 Copyright (c) 2003, 2005, Oracle. ALL rights reserved. 连接到: Oracle DATABASE 10g Enterprise Edition Release … Continue reading →

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

ORA-600(opixrb-4)错误

Posted on 2011/12/28 by yangtingkun

客户环境出现ORA-600(opixrb-4)错误。 错误信息为： Fri Oct 28 05:50:47 2011 Errors IN file /oracle9/app/admin/bill/udump/bill1_ora_11075632.trc: ORA-00600: internal error code, arguments: [opixrb-4], [1036], [ORA-01036: illegal variable name/NUMBER], [], [], [], [], [] Fri Oct 28 05:56:44 2011 Errors IN file /oracle9/app/admin/bill/udump/bill1_ora_11075632.trc: ORA-00600: internal error code, … Continue reading →

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

ORA-600(unable to load XDB library)错误

Posted on 2011/12/27 by yangtingkun

AIX上的9206数据库出现这个错误。 在alert文件中发现大量的类似错误： Mon DEC 19 16:43:13 2011 Errors IN file /oracle9/app/admin/db/udump/db1_ora_15400980.trc: ORA-00600: internal error code, arguments: [unable TO LOAD XDB library], [], [], [], [], [], [], []Mon Dec 19 16:43:13 2011 Errors in file /oracle9/app/admin/db/udump/db1_ora_15400980.trc: ORA-00600: internal error code, … Continue reading →

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

ORA-600(17087)错误

Posted on 2011/12/26 by yangtingkun

客户数据库出现这个ORA-600错误。 错误信息为： Mon Jun 28 10:27:07 2010 Errors IN file /oracle/admin/ccicdb/udump/ccicdb_ora_767494.trc: ORA-00600: internal error code, arguments: [17087], [0x70000076C3E8E90], [], [], [], [], [], []Mon Jun 28 10:27:07 2010 Errors in file /oracle/admin/ccicdb/udump/ccicdb_ora_767494.trc: ORA-00600: internal error code, arguments: [17087], [0x70000076C3E8E90], [], … Continue reading →

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

ORA-7445(kcrfw_update_blk_list)错误

Posted on 2011/12/25 by yangtingkun

客户的11.2数据库测试环境中碰到了ORA-7445(kcrfw_update_blk_list)错误。 详细的错误信息如下： Tue DEC 20 22:00:02 2011 BEGIN automatic SQL Tuning Advisor run FOR special tuning task "SYS_AUTO_SQL_TUNING_TASK" Tue DEC 20 22:00:46 2011 Exception [TYPE: SIGBUS, Non-existent physical address] [ADDR:0x62652000] [PC:0x216E0C4, kcrfw_update_blk_list()+196] [flags: 0x0, COUNT: 1] Errors IN file /u01/app/oracle/diag/rdbms/fhacdb/fhacdb/trace/fhacdb_lgwr_24506.trc … Continue reading →

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