Category Archives: BUG

Oracle bugs

ORA-600(qkaffsindex5)错误

Posted on 2012/05/14 by yangtingkun

客户11.2.0.2 RAC for Solaris10上的错误。 错误信息为： 2012-05-04 22:00:04.768000 +08:00 BEGIN automatic SQL Tuning Advisor run FOR special tuning task "SYS_AUTO_SQL_TUNING_TASK" 2012-05-04 22:00:17.279000 +08:00 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j002_5730.trc (incident=231810): ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], … Continue reading →

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

ORA-7445(dbgrlWriteAlertDetail_int)和ORA-4030导致实例崩溃

Posted on 2012/05/13 by yangtingkun

客户11.2.0.2 RAC for Solaris 10 sparc单实例出现ORA-7445和ORA-4030操作，导致实例崩溃。 这个错误比较严重： 2012-05-04 02:02:26.403000 +08:00 Archived Log entry 949 added FOR thread 1 SEQUENCE 518 ID 0x70a64e83 dest 1: Archived Log entry 950 added FOR thread 1 SEQUENCE 519 ID 0x70a64e83 dest 1: Thread 1 … Continue reading →

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

ORA-600(ksnpost:ksnigb)错误

Posted on 2012/05/12 by yangtingkun

客户10.2.0.5 RAC for HP-UX ia64出现ORA-600(ksnpost:ksnigb)的错误。 错误信息如下： Wed Apr 25 16:32:21 UTC 2012 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_ora_17014.trc: ORA-00600: Message 600 NOT found; No message file FOR product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb] Wed Apr 25 16:32:55 UTC 2012 Trace dumping IS performing id=[cdmp_20120425163255] … Continue reading →

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

ORA-600(qertbFetchByRowID)错误

Posted on 2012/05/08 by yangtingkun

以前也碰到过这个错误，不过由于无法直接连接数据库，没有办法深入分析。这次虽然同样没有办法连接数据库，但是获取了更详细的信息，基本确定导致问题的原因。 错误信息如下： Wed May 09 10:41:32 2012 Errors IN file /oracle/admin/orcl/udump/orcl_ora_423466.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []Wed May 09 10:41:32 2012 Errors in file /oracle/admin/orcl/udump/orcl_ora_423466.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], … Continue reading →

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

9i出现内存分配错误

Posted on 2012/05/06 by yangtingkun

在9.2.0.8 RAC环境中，告警日志频繁出现内存分配错误的信息。 错误信息如下： Wed May 2 10:20:43 2012 Trace dumping IS performing id=[cdmp_20120502102043] There are 1444 memory allocation errors FOR object-level stat IN the LAST 15 minutes . . . There are 1605 memory allocation errors FOR object-level stat IN … Continue reading →

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

ORA-600(kgavsd_3)错误

Posted on 2012/05/05 by yangtingkun

客户9208环境出现ORA-600[kgavsd_3]错误。 错误信息为： Thu DEC 15 15:47:57 2011 Errors IN file /oracle/admin/orcl/udump/orcl2_ora_659472.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 2 ORA-03113: end-of-file ON communication channel ORA-03113: end-of-file ON … Continue reading →

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

节点重配置后IPC发送超时问题

Posted on 2012/05/04 by yangtingkun

客户RAC环境在一个节点重启后，另一个节点出现IPC send timeout信息。 详细错误信息为： Wed May 2 22:07:00 2012 IPC Send timeout detected.Sender: ospid 20808 Receiver: inst 1 binc 1718095761 ospid 16263 Wed May 2 22:07:02 2012 IPC Send timeout detected.Sender: ospid 6677 Receiver: inst 1 binc 1718095761 ospid 16263 … Continue reading →

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

ORA-600(ktspfupdst-1)错误

Posted on 2012/05/01 by yangtingkun

客户9208数据库出现ORA-600[ktspfupdst-1]错误。 错误信息为： Sat Mar 31 02:50:48 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl1_ora_1896900.trc: ORA-00600: internal error code, arguments: [ktspfupdst-1], [], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 1 ORA-01013: USER requested cancel OF CURRENT operationSat Mar … Continue reading →

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

ORA-8103错误

Posted on 2012/04/25 by yangtingkun

最近碰到两次ORA-8103错误，简单总结一下。 一次是客户的10.2数据库出现了ORA-600[6002]错误，导致的问题是索引出现了逻辑损坏，本来问题很简单，只需要删除索引并重建，或者通过ONLINE REBUILD方式就可以了。但是索引删除后，扫描这张表出现了ORA-8103错误，这说明错误不仅出现在索引上，在数据块上同样存在逻辑错误，从而导致了前面的ORA-600[6002]错误。 第二个问题是11.2.0.2环境中出现的ORA-8103错误，错误发生在统计信息收集过程中： Fri Mar 30 02:00:00 2012 DBMS_STATS: GATHER_STATS_JOB encountered errors. CHECK the trace file. Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j000_25932.trc: ORA-20011: Approximate NDV failed: ORA-08103: object no longer EXISTSFri Mar 30 02:00:00 2012 DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the … Continue reading →

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

备份导致ORA-245错误

Posted on 2012/04/24 by yangtingkun

客户的11.2 RAC数据库在备份是出现ORA-245错误。 从告警日志中可以看到错误信息为： Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18335.trc: ORA-00245: control file backup operation failedErrors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18335.trc: ORA-00245: control file backup operation failed 详细TRACE信息为： Trace file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18335.trc Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production WITH the Partitioning, REAL … Continue reading →

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