Category Archives: BUG

Oracle bugs

ORA-600(4454)错误

Posted on 2012/02/13 by yangtingkun

客户数据库出席ORA-600[4454]错误。 错误信息如下： Fri Feb 10 18:43:57 2012 Errors IN file /oracle9/app/admin/settl/udump/settl1_ora_1667162.trc: ORA-00600: internal error code, arguments: [4454], [], [], [], [], [], [], [] Fri Feb 10 18:43:58 2012 Errors IN file /oracle9/app/admin/settl/udump/settl1_ora_1667162.trc: ORA-00600: internal error code, arguments: [4454], [], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

STATSPACK报告REDO SIZE出现负值

Posted on 2012/02/12 by yangtingkun

客户9.2.0.8数据库的STATSPACK报告出现负的REDO SIZE。 类似信息如下： LOAD Profile ~~~~~~~~~~~~ Per SECOND Per TRANSACTION ————— ————— Redo SIZE: -263,339.94 -685,483.59Load Profile ~~~~~~~~~~~~ Per Second Per Transaction ————— ————— Redo size: -263,339.94 -685,483.59 其实经常出现的还包括逻辑读以及物理读等。其实不查询MOS也可以确定，这是Oracle的bug，而导致bug的原因应该是底层的C代码中没有使用UNSIGNED类型，以至于变量溢出后出现了负值。 在MOS中的对应描述为：Redo Size Negative In Statspack Report [ID 308414.1]，Oracle在10g中解决了这个问题。确认影响版本从8.1.7.4到9.2.0.8。

Posted in BUG | Tagged , , | Leave a comment

SHUTDOWN IMMEDIATE出现ORA-27144错误

Posted on 2012/02/10 by yangtingkun

客户的10.2.0.1 RAC for AIX数据库在关闭一个节点时碰到这个错误。 告警日志中信息如下： Tue Jan 10 21:11:42 2012 Shutting down instance (immediate) License high water mark = 721 Tue Jan 10 21:11:42 2012 Stopping Job queue slave processes Tue Jan 10 21:11:42 2012 Job queue slave processes stopped … Continue reading →

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

ORA-600(1158)错误

Posted on 2012/02/06 by yangtingkun

执行DDL时取消当前的操作出现这个错误。 详细错误信息如下： SQL> ALTER TRIGGER DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable; ^Calter TRIGGER DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable * ERROR at line 1: ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []SQL> alter trigger DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable; ^Calter trigger DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable * ERROR at … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(ktspNextL1:4)错误

Posted on 2012/02/05 by yangtingkun

告警日志出现ORA-600[ktspNextL1:4]错误。 错误信息如下： Tue Jan 15 22:00:45 2012 Errors IN file /oracle/admin/orcl/bdump/orcl_j000_13722891.trc: ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], [] Tue Jan 15 22:01:10 2012 Trace dumping IS performing id=[cdmp_20120131220118] Tue Jan 15 22:01:10 2012 Errors … Continue reading →

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

收集统计信息出现ORA-1476错误

Posted on 2012/02/04 by yangtingkun

告警日志中出现JOB运行错误，而发生错误的任务是在收集统计信息。 错误信息如下： Fri Feb 2 22:00:05 2012 GATHER_STATS_JOB encountered errors. CHECK the trace file. Fri Feb 2 22:00:05 2012 Errors IN file /oracle/admin/orcl/bdump/orcl_j000_23148.trc: ORA-01476: divisor IS equal TO zeroFri Feb 2 22:00:05 2012 GATHER_STATS_JOB encountered errors. Check the trace file. … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(17281)(1001)错误（二）

Posted on 2012/02/02 by yangtingkun

和第一次碰到这个错误不同，这次是在10.2环境中出现的。 ORA-600(17281)(1001)错误：http://yangtingkun.itpub.net/post/468/514806 告警日志中错误信息为： Tue Jan 31 15:55:55 2012 Errors IN file /oracle/admin/ORCL/udump/orcl_ora_6225970.trc: ORA-00600: internal error code, arguments: [17281], [1001], [0x70000059AB9BE38], [], [], [], [], [] ORA-01001: invalid cursorTue Jan 31 15:55:55 2012 Errors in file /oracle/admin/ORCL/udump/orcl_ora_6225970.trc: ORA-00600: internal error code, … Continue reading →

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

ORA-600(12333)错误

Posted on 2012/01/31 by yangtingkun

前不久才处理了一个ORA-600[12333]错误，不过那个问题是9i上的。 ORA-600(12333)错误和ORA-600(ttclxx1)错误：http://yangtingkun.itpub.net/post/468/526078 而这个错误是发生在10.2.0.3环境下： Tue Jan 31 15:31:14 2012 Errors IN file /oracle/admin/ORCL/udump/orcl_ora_40960504.trc: ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], [] 详细TRACE文件如下： Dump file /oracle/admin/ORCL/udump/orcl_ora_40960504.trc Oracle DATABASE 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production WITH … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-7445(kcsgrsn)错误

Posted on 2012/01/28 by yangtingkun

告警日志中出现这个错误。 错误信息如下： Thu DEC 23 01:00:02 2010 Starting background process EMN0 EMN0 started WITH pid=290, OS id=21705 Thu DEC 23 01:00:02 2010 Shutting down instance: further logons disabled Thu DEC 23 01:00:10 2010 Stopping background process QMNC Thu DEC 23 … Continue reading →

Posted in BUG | Tagged , , | 1 Comment

ORA-600(17113)错误

Posted on 2012/01/27 by yangtingkun

又是一个PL/DEVELOPER的bug。 客户数据库是9.2.0.8，告警日志中出现大量下面的错误信息： Thu DEC 1 08:37:52 2011 Errors IN file /oracle9/app/admin/db/udump/db1_ora_1995124.trc: ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], [] Thu DEC 1 08:37:52 2011 Trace dumping IS performing id=[cdmp_20111201083752] Thu DEC 1 08:38:21 2011 Errors … Continue reading →

Posted in BUG | Tagged , , | Leave a comment