Category Archives: BUG

Oracle bugs

ORA-600(kssadd_stage: null parent)错误

Posted on 2012/08/05 by yangtingkun

客户数据库出现频繁的ORA-600(kssadd_stage: null parent)错误。 数据库版本为10.2.0.5 RAC for AIX，报错时详细错误信息为： Tue Jul 17 14:57:39 2012 Errors IN file /oracle/10g/admin/orcl/udump/orcl2_ora_307720.trc: ORA-00600: internal error code, arguments: [kssadd_stage: NULL parent], [], [], [], [], [], [], [] Tue Jul 17 14:57:45 2012 Errors IN file /oracle/10g/admin/orcl/udump/orcl2_ora_357344.trc: … Continue reading →

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

ORA-7445(xsSSEXECUT)错误

Posted on 2012/08/04 by yangtingkun

又一个OLAP组件相关的bug。 数据库版本为10.2.0.3 32bit for Linux，在告警日志出现下面的错误： Mon Jul 30 23:29:19 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_24707.trc: ORA-07445: exception encountered: core dump [xsSSEXECUT()+13022] [SIGSEGV] [Address NOT mapped TO object] [0x14] [] []Mon Jul 30 23:29:19 2012 Errors in file /ora/app/oracle/admin/ORCL/udump/orcl_ora_24707.trc: ORA-07445: exception encountered: … Continue reading →

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

ORA-600(kghfremptyds)和ORA-600(kghasp1)错误

Posted on 2012/08/03 by yangtingkun

客户在进行OLAP的导入时出现了这个错误。 数据库版本为10.2.0.3，除了这两个错误外，同时还出现了其他的错误： Mon Jul 30 23:49:08 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xAF509008], [], [], [], [], [], [] Mon Jul 30 23:49:09 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xAF50AF34], … Continue reading →

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

ORA-600(qerrmOStart2)(1756)错误

Posted on 2012/07/30 by yangtingkun

客户数据库出现ORA-600(qerrmOStart2)(1756)错误。 ORA-600(qerrmOStart2)错误：http://yangtingkun.itpub.net/post/468/527461 之前遇到过一次类似的qerrmOStart2错误，不过上次错误的第二个参数是1740。在上一篇文章中已经提到了，这个600错误只是一个表现，实际上真正的错误是第二个函数中体现的错误。 看一下具体的错误TRACE信息： *** SERVICE NAME:(SYS$USERS) 2012-05-24 17:23:39.684 *** SESSION ID:(598.169) 2012-05-24 17:23:39.684 *** 2012-05-24 17:23:39.684 ksedmp: internal OR fatal error ORA-00600: internal error code, arguments: [qerrmOStart2], [1756], [ORA-01756: quoted string NOT properly TERMINATED ], [], [], [], [], … Continue reading →

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

ORA-600(qersqCloseRem-2)错误

Posted on 2012/07/27 by yangtingkun

客户的10.2.0.4 RAC for Hp-un环境碰到了这个错误。 错误信息为： Wed Feb 29 19:42:05 2012 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_11261.trc: ORA-00600: internal error code, arguments: [qersqCloseRem-2], [Invalid Handle], [], [], [], [], [], [] ORA-02068: following severe error FROM WEBDB.COM ORA-03113: end-of-file ON communication channel Wed … Continue reading →

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

ORA-1595和ORA-1594错误

Posted on 2012/07/26 by yangtingkun

Oracle 9i上使用自动管理回滚的错误，简单记录一下。 错误信息为： Sat May 12 21:54:17 2012 Errors IN file /oracle/app/admin/prmdb/bdump/prmdb2_smon_483522.trc: ORA-01595: error freeing extent (2) OF ROLLBACK segment (19)) ORA-01594: attempt TO wrap INTO ROLLBACK segment (19) extent (2) which IS being freedSat May 12 21:54:17 2012 Errors … Continue reading →

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

ORA-600(1265)错误

Posted on 2012/07/25 by yangtingkun

客户的数据库出现ORA-600错误，错误函数为1265。 数据库版本为10.2.0.4 for Linux，错误信息为： Fri Aug 26 22:00:11 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] Fri Aug 26 22:00:13 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: … Continue reading →

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

ORA-600(kclfusion_1)错误

Posted on 2012/07/24 by yangtingkun

10.2.0.4 RAC for HP-UX，出现600错误并导致实例崩溃。 数据库错误信息如下： Thu Oct 29 19:49:19 2009 SMON: enabling cache recovery Thu Oct 29 19:49:19 2009 LNS: Standby redo logfile selected FOR thread 2 SEQUENCE 48 FOR destination LOG_ARCHIVE_DEST_2 Thu Oct 29 19:49:19 2009 ARC0: Standby redo … Continue reading →

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

ORA-600(KSSRMP1)错误

Posted on 2012/07/23 by yangtingkun

10.2.0.4 RAC的ASM实例出现这个错误。 错误信息为： Mon Mar 14 11:45:00 2011 Errors IN file /home/oracle/admin/+ASM/udump/+asm2_ora_717148.trc: ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], [] Mon Mar 14 11:45:01 2011 Trace dumping IS performing id=[cdmp_20110314114501] Mon Mar 14 11:45:06 2011 … Continue reading →

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

ORA-600(kccida_kccsgfsz)错误

Posted on 2012/07/21 by yangtingkun

客户数据库10.1.0.4碰到这个ORA-600错误。 详细错误信息为： Sat Feb 4 13:04:31 2006 ALTER DATABASE MOUNT Sat Feb 4 13:04:31 2006 Errors IN file /oracle/admin/orcl/bdump/orcl_ckpt_122986.trc: ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], [] Sat Feb 4 13:04:32 2006 Errors IN file … Continue reading →

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