Category Archives: BUG

Oracle bugs

V$SESSION记录的BLOCKING_SESSION错误

Posted on 2012/11/26 by yangtingkun

记录一个很诡异的问题，在进行一个测试时碰到的，V$SESSION中记录的BLOCKING_SESSION信息是错误的，可惜这个问题当时没有注意，后续也无法再重现出来，只好作为一个现象记录一下，Oracle给出的一些信息看来也是不完全可信的。 在会话1执行： [tingkun.yang@node1 ~]$ sqlplus test/test SQL*Plus: Release 10.2.0.5.0 – Production ON Sun Nov 25 04:04:00 2012 Copyright (c) 1982, 2010, Oracle. ALL Rights Reserved. Connected TO: Oracle DATABASE 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production WITH the Partitioning, … Continue reading →

Posted in BUG | Tagged , | Leave a comment

ORA-600(kfioTranslateIO03)和ORA-600(17090)错误

Posted on 2012/11/23 by yangtingkun

客户的11.2 RAC环境出现这两个ORA-600错误。 详细的错误信息为： Mon Nov 19 19:32:56 2012 ALTER SYSTEM SET local_listener=’ (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.135.128.17)(PORT=1521))))’ SCOPE=MEMORY SID=’orcl1′; NOTE: Loaded library: System ORA-15025: could NOT OPEN disk "/dev/rhdisk10" ORA-27041: unable TO OPEN file IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: … Continue reading →

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

ORA-600(2901)错误

Posted on 2012/11/22 by yangtingkun

客户在创建表空间时，出现这个错误。 详细错误信息为： SQL> CREATE TABLESPACE T_DATA DATAFILE ‘/dev/tdat01’ SIZE 13369336K 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE HS_ARCH_DATA DATAFILE ‘/dev/tdat01’ SIZE 13369336K * ERROR at line 1: ORA-00600: internal error code, arguments: [2901], [1671166], [1671167], [], … Continue reading →

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

ORA-600(k2qgil:gtx)错误

Posted on 2012/11/21 by yangtingkun

客户11.2.0.3 RAC出现了ORA-600[k21gil:gtx]错误。 错误信息为： Sat Sep 22 18:45:52 2012 Auto-tuning: Shutting down background process GTX1 Sat Sep 22 19:00:20 2012 Auto-tuning: Starting background process GTX1 Starting background process GTX1 Sat Sep 22 19:00:20 2012 GTX1 started WITH pid=584, OS id=21107 Sat … Continue reading →

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

ORA-7445(kclfusion_1)错误

Posted on 2012/11/20 by yangtingkun

客户10.2.0.4 RAC环境在启动时出现ORA-7445错误。 错误信息为： Wed Jun 27 05:10:51 2012 Starting ORACLE instance (normal) Wed Jun 27 05:11:24 2012 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 aggr1 192.168.168.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

关闭数据库出现PMON failed to acquire latch信息

Posted on 2012/11/19 by yangtingkun

很常见的一个信息，以前并没有太在意，不过即使是这种异常信息，Oracle也认为是bug。 关闭数据库时，信息如下： Tue Aug 16 15:38:06 2011 Shutting down archive processes Tue Aug 16 15:38:11 2011 ARCH shutting down ARC2: Archival stopped Tue Aug 16 15:43:41 2011 Starting background process EMN0 EMN0 started WITH pid=28, OS id=1294500 Tue Aug 16 … Continue reading →

Posted in BUG | Tagged , | Leave a comment

ORA-600(kocgor077)错误

Posted on 2012/11/18 by yangtingkun

客户数据库出现ORA-600[kocgor077]错误。 数据库版本为10.2.0.1，详细错误信息为： Thu Oct 22 22:00:36 2009 ORA-0 encountered WHEN generating server alert SMG-3503 Thu Oct 22 22:10:40 2009 ORA-0 encountered WHEN generating server alert SMG-3503 Thu Oct 22 22:20:44 2009 ORA-0 encountered WHEN generating server alert SMG-3503 Thu Oct … Continue reading →

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

ORA-21780、ORA-4030、ORA-600(keltenq)、SMG-3000、SMG-3503错误

Posted on 2012/11/17 by yangtingkun

客户Oracle 10.2.0.1数据库告警日志出现大量的ORA-21780错误，并包含SMG-3000和SMG-3503信息，紧接着出现了ORA-4030和ORA-600(keltenq)错误。 错误信息如下： Mon Aug 17 10:37:48 2009 ORA-21780 encountered WHEN generating server alert SMG-3000 Mon Aug 17 10:38:27 2009 ORA-21780 encountered WHEN generating server alert SMG-3503 Mon Aug 17 10:47:48 2009 ORA-21780 encountered WHEN generating server alert SMG-3000 Mon … Continue reading →

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

控制文件自动备份报错并产生TRACE文件

Posted on 2012/11/16 by yangtingkun

客户10.2.0.1数据库在控制文件自动备份过程中出现错误信息。 错误信息为： Thu Jun 30 02:15:46 2011 Starting control autobackup Thu Jun 30 02:15:47 2011 Errors IN file /u01/app/oracle/admin/orcl/udump/orcl_ora_1167402.trc: Thu Jun 30 02:15:47 2011 Errors IN file /u01/app/oracle/admin/orcl/udump/orcl_ora_1167402.trc: Thu Jun 30 02:15:47 2011 Errors IN file /u01/app/oracle/admin/orcl/udump/orcl_ora_1167402.trc: Control autobackup written … Continue reading →

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

ORA-600(ktspfnsb-1)错误

Posted on 2012/11/15 by yangtingkun

Exadata环境在收集统计信息时出现这个错误。 客户数据库11.2.0.2 RAC on Exadata在收集统计信息是出现的错误： Sun Feb 05 22:22:44 2012 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_j002_21084.trc (incident=255085): ORA-00600: internal error code, arguments: [ktspfnsb-1], [1], [1], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_255085/orcl2_j002_21084_i255085.trc Sun Feb 05 22:22:56 … Continue reading →

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