Category Archives: BUG

Oracle bugs

ORA-600(KSSRMP2)错误

Posted on 2012/07/20 by yangtingkun

客户的Oracle 10.1.0.4环境碰到这个错误。 详细错误信息为： Wed DEC 14 21:10:27 2005 Errors IN file /oracle/admin/ocrl/bdump/ocrl_smon_160060.trc: ORA-00600: internal error code, arguments: [KSSRMP2], [0x1102F0128], [0], [0], [], [], [], [] ORA-01157: cannot identify/LOCK DATA file 201 – see DBWR trace file ORA-01110: DATA file 201: … Continue reading →

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

ORA-4031导致CJQ进程出现ORA-1003错误

Posted on 2012/07/17 by yangtingkun

客户数据库出现ORA-4031错误，随后出现了大量的ORA-1003和ORA-604错误。 数据库版本为10.2.0.3 RAC for HP-UX，详细的报错信息为： Mon Jul 16 15:30:30 2012 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl2_ora_2389.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable TO allocate 32 bytes OF shared memory ("shared … Continue reading →

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

ORA-7445(plcurClose)错误

Posted on 2012/07/16 by yangtingkun

11.2.0.2 RAC环境，碰到这个错误。 详细错误信息为： Tue Mar 13 14:25:17 2012 Exception [TYPE: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x37434AD, plcurClose()+27] [flags: 0x0, COUNT: 1] Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_29472.trc (incident=279439): ORA-07445: exception encountered: core dump [plcurClose()+27] [SIGSEGV] [ADDR:0x0] [PC:0x37434AD] [SI_KERNEL(general_protection)] [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_279439/orcl2_ora_29472_i279439.trc USE … Continue reading →

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

ORA-600(qctopn1)错误

Posted on 2012/07/12 by yangtingkun

客户11.2.0.2环境数据库出现这个ORA-600错误。 详细错误信息如下： Tue Jun 12 09:50:47 2012 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_28252.trc (incident=329000): ORA-00600: internal error code, arguments: [qctopn1], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_329000/orcl2_ora_28252_i329000.trc Tue Jun 12 09:51:21 2012 Dumping diagnostic … Continue reading →

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

删除归档出现ORA-15028错误

Posted on 2012/07/11 by yangtingkun

在10.2.0.4 RAC环境中使用RMAN删除归档报错ORA-15028。 错误信息如下： RMAN> DELETE archivelog ALL completed BEFORE ‘sysdate-3’; Do you really want TO DELETE the above objects (enter YES OR NO)? YES RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure OF DELETE command … Continue reading →

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

ORA-600(kffmXpGet)错误

Posted on 2012/07/10 by yangtingkun

第一次碰到Exadata上的bug。 数据库环境Exadata V2-2，数据库版本为11.2.0.2，错误信息为： Wed Apr 25 11:32:35 2012 Errors IN file /u01/app/oracle/diag/rdbms/ods/orcl2/trace/orcl2_ora_9495.trc (incident=304808): ORA-00600: internal error code, arguments: [kffmXpGet], [145], [69784], [], [], [], [], [], [], [], [], [] ORA-03135: connection lost contact Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_304808/orcl2_ora_9495_i304808.trc USE ADRCI … Continue reading →

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

ORA-600(kfnsBackground03)错误

Posted on 2012/07/08 by yangtingkun

客户的数据库出现了ORA-600(kfnsBackground03)错误。 数据库版本为10.2.0.3 RAC for HP-UX 11.23。这个错误在ASM实例和数据库实例都可能出现，如果发生在ASM实例，并不会导致ASM实例的崩溃，但是如果发生在数据库实例，则会导致数据库实例被强制关闭： Tue May 15 10:28:05 2012 NOTE: DATABASE ORCL1:ORCL failed during msg 19, reply 2 Tue May 15 10:32:50 2012 NOTE: DATABASE ORCL1:ORCL failed during msg 19, reply 2 Tue May 15 10:33:05 2012 NOTE: … Continue reading →

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

升级不正确导致ORA-27468错误

Posted on 2012/07/02 by yangtingkun

客户10.2.0.4环境告警日志出现ORA-27468错误。 详细错误信息为： Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl1_j000_18724.trc: ORA-12012: error ON auto EXECUTE OF job 42791 ORA-27468: "EXFSYS.RLM$EVTCLEANUP" IS locked BY another processErrors in file /u01/app/oracle/admin/orcl/bdump/orcl1_j000_18724.trc: ORA-12012: error on auto execute of job 42791 ORA-27468: "EXFSYS.RLM$EVTCLEANUP" is locked by another process 导致这个错误的原因在于升级时没有执行catupgrd.sql，而是执行了建库的部分脚本如catalog.sql和catproc.sql，这导致只有CATALOG视图和系统的PACKAGE以及TYPE的版本更新到10.2.0.4，而其他数据库中组件的版本并没有升级，仍然是10.2.0.1。 … Continue reading →

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

ORA-600(kkdlfjou_1)错误

Posted on 2012/06/22 by yangtingkun

10.2.0.5 RAC环境出现ORA-600[kkdlfjou_1]错误。 错误信息： Thu Jun 02 10:09:38 EAT 2011 Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_17796.trc: ORA-00600: internal error code, arguments: [kkdlfjou_1], [], [], [], [], [], [], [] Thu Jun 02 10:09:40 EAT 2011 Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_29452.trc: ORA-00600: 内部错误代码, 参数: [kkdlfjou_1], … Continue reading →

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

ORA-600(krbounotread_noctx)错误

Posted on 2012/06/21 by yangtingkun

由于RMAN备份导致的BUG。 ORA-600(krboReadBitmap_badbitmap)错误：https://yangtingkun.net/?p=863 这个问题和以前碰到的问题属于同一个BUG，错误信息为： Tue May 8 02:18:42 2012 Backup optimization FOR file +DATA/orcl/datafile/index_ts1.ora stopped due TO errors: Tue May 8 02:18:42 2012 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl2_ora_3758.trc: ORA-00600: internal error code, arguments: [krboReadBitmap_badbitmap], [272945930], [+DATA/orcl/datafile/index_ts1.ora], [6], [30], [33554432], [1024], [19808273] Tue … Continue reading →

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