Category Archives: BUG

Oracle bugs

ACTIVE DATAGUARD上的ORA-1555错误

Posted on 2011/12/20 by yangtingkun

11g的ACTIVE DATAGUARD极大的增强了物理STANDBY的功能，可惜任何新特性都很难避免bug的产生，ACTIVE DATAGUARD同样也不例外。 已经有多个客户反应ACTIVE DATAGUARD上执行报表查询出现ORA-1555错误，错误和初始化参数UNDO_RETENTION的设置没有直接关系。而且如果打开了USING CURRENT LOG选项，不但可能导致SNAPSHOT TOO OLD错误，还可能导致整个STANDBY数据库性能越来越慢，以至于完全不可用，最终不得不重启。 查询了一下MOS，发现Oracle确认了这个bug：ORA-01555 on Active Data Guard Standby Database [ID 1273808.1]。 解决这个问题，出了应用对应的补丁10018789之外，也可以考虑将数据库升级到11.2.0.2.2以上。如果是Windows环境，那么比较升级到11.2.0.2.3以上。

Posted in BUG | Tagged , , | Leave a comment

ORA-600(kcbshlc_1)和ORA-7445(kggchk)错误

Posted on 2011/12/18 by yangtingkun

以前同时记录两个ORA-600错误，多半是由于这个两个错误在同时，是同一次故障的不同表现，而这次两个错误则是分别出现。 客户的10.2.0.4的逻辑STANDBY备库上前后几次出现了这两个错误： Thu Jun 16 13:45:05 2011 Errors IN file /u01/app/oracle/admin/db/bdump/db_pmon_27660.trc: ORA-07445: exception encountered: core dump [kggchk()+77] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Thu Jun 16 13:45:13 2011 CKPT: terminating instance due TO error 472 Instance TERMINATED … Continue reading →

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

ORA-7445(_ssbev_env)错误

Posted on 2011/12/17 by yangtingkun

客户的Oracle 10201 for Windows环境频繁出现这个错误。 详细的错误信息为： Fri DEC 16 16:27:02 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7D611D87] [ADDR:0x55909090] [UNABLE_TO_READ] [] Fri DEC 16 16:27:03 2011 Errors IN file d:\oracle\product\10.2.0\db_1\rdbms\trace\px_ora_5360.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] … Continue reading →

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

同一个SQL引发多个ORA-7445错误

Posted on 2011/12/14 by yangtingkun

在客户的Oracle 9204 RAC for Linux x86环境中，发现同一SQL引发了多个ORA-7445错误。 节点1上错误信息为： Wed Nov 30 14:19:38 2011 Errors IN file /u01/oracle/admin/oric/udump/oric1_ora_8519.trc: ORA-07445: exception encountered: core dump [kghalf()+743] [SIGSEGV] [Address NOT mapped TO object] [0x1FE0] [] [] . . . Thu DEC 1 16:09:03 2011 Errors … Continue reading →

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

ORA-7445(kglLockIterator)错误

Posted on 2011/12/09 by yangtingkun

在客户的10.2.0.3环境中发现这个错误。 告警日志中错误为： Mon Sep 20 10:21:04 2010 Errors IN file /home/oracle/admin/ARIC/udump/aric_ora_3776.trc: ORA-07445: exception encountered: core dump [SIGSEGV] [Address NOT mapped TO object] [4294967377] [] [] []Mon Sep 20 10:21:04 2010 Errors in file /home/oracle/admin/ARIC/udump/aric_ora_3776.trc: ORA-07445: exception encountered: core dump [SIGSEGV] … Continue reading →

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

AWR中出现严重kksfbc child completion等待

Posted on 2011/12/08 by yangtingkun

一个客户压力测试的AWR报告中出现了严重的kksfbc child completion等待。 数据库版本为10.2.0.5，其TOP 5等待事件为： Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class kksfbc child completion 174,808 8,678 50 27.2 Other db file scattered read 106,665 6,807 64 21.3 User I/O log file sync 130,582 6,592 50 … Continue reading →

Posted in BUG | Tagged , | Leave a comment

ORA-600(17271)错误

Posted on 2011/12/07 by yangtingkun

告警日志中发现了ORA-600(17271)错误。 详细错误信息为： Fri Mar 6 17:15:37 2009 Errors IN file /home/oracle/admin/ARIC/udump/aric_ora_28118.trc: ORA-00600: internal error code, arguments: [17271], [instantiation SPACE leak], [], [], [], [], [], [] ORA-03135: connection lost contactFri Mar 6 17:15:37 2009 Errors in file /home/oracle/admin/ARIC/udump/aric_ora_28118.trc: ORA-00600: internal … Continue reading →

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

ORA-7445(qerixGetKey)错误

Posted on 2011/12/06 by yangtingkun

执行并行查询时碰到的问题。 错误信息如下： Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p001_8093.trc: ORA-07445: exception encountered: core dump [SIGSEGV] [Address NOT mapped TO object] [21] [] [] [] Wed Sep 28 18:03:47 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_p000_8091.trc: ORA-07445: exception encountered: core dump … Continue reading →

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

ORA-600(qerfxFetch_01)错误

Posted on 2011/12/03 by yangtingkun

在客户的9201数据库中，发现这个错误。 错误信息为： Wed Jul 29 09:23:32 2009 Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_20242.trc: ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []Wed Jul 29 09:23:32 2009 Errors in file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_20242.trc: ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

11g收集统计信息引发wri$_optstat_histhead_history表的删除

Posted on 2011/12/02 by yangtingkun

在查看一个客户11.2.0.2的AWR报告时，发现了这个问题。 在SQL ORDER BY ELASPED TIME表中，前两项的结果如下： Elapsed Time (s) Executions %Total %CPU %IO SQL Id SQL Module SQL Text 10,752.79 0 25.86 98.20 7.49 4sff1qphjvbwn SQL*Plus BEGIN dbms_stats.gather_table_… 10,752.75 13 25.86 98.20 7.49 bqn2h1xrmhmht delete from sys.wri$_optstat_h… 可以看到，这2两个语句在花费时间，占用CPU以及IO的百分比上惊人的一致，这绝对不是一个偶然的事件。 第一个SQL是收集表的统计信息，显然这是在SQLPLUS里面执行的操作，其执行次数是0，说明在采样时间内，这个操作还没有完成。根据Elspsed Time估算，这个SQL已经运行了3个小时。 … Continue reading →

Posted in BUG | Tagged , , | Leave a comment