Category Archives: BUG

Oracle bugs

ORA-600(729)错误

Posted on 2011/10/19 by yangtingkun

客户数据库出现ORA-600[729]错误。 详细信息如下： Sun Oct 16 04:31:31 2011 Errors IN file /u01/app/oracle/admin/db1/udump/db1_ora_6459722.trc: ORA-00600: internal error code, arguments: [729], [360], [SPACE leak], [], [], [], [], []Sun Oct 16 04:31:31 2011 Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_6459722.trc: ORA-00600: internal error code, arguments: [729], [360], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(krfg_first_barrier1)错误

Posted on 2011/10/18 by yangtingkun

客户在打开FLASHBACK的时候碰到了这个错误。 详细的错误如下： Tue Oct 18 10:55:02 2011 ALTER DATABASE MOUNT Tue Oct 18 10:55:06 2011 Setting recovery target incarnation TO 1 Tue Oct 18 10:55:06 2011 Successful mount OF redo thread 1, WITH mount id 830459142 Tue Oct 18 10:55:06 … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(krd_check_slaves_1)错误

Posted on 2011/10/16 by yangtingkun

物理STANDBY环境在进行恢复时碰到这个错误。 详细错误信息为： <pre lang=’SQL’>Sun Sep 11 06:59:47 2011 alter database recover datafile list clear Sun Sep 11 06:59:47 2011 Completed: alter database recover datafile list clear Sun Sep 11 06:59:47 2011 alter database recover datafile list 1 , 2 , … Continue reading →

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

ORA-600(kmgs_pre_process_request_6)错误

Posted on 2011/10/15 by yangtingkun

这个bug比较神奇，如果SGA设置为4G的整数倍，就会导致系统CRASH。以前听说过这个bug，这次还是第一次碰到。 详细的错误如下： <pre lang=’SQL’>Tue Oct 11 10:44:34 2011 Starting ORACLE instance (normal) Tue Oct 11 10:44:34 2011 Specified value of sga_max_size is too small, bumping to 12884901888 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Autotune of … Continue reading →

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

OEM模块审计查询语句占用较大资源

Posted on 2011/10/14 by yangtingkun

发现一个导致Oracle自己的低效SQL，在AWR报告中占用较大的资源。 这个SQL在Elapsed Time、CPU Time、User I/O Wait Time、Buffer Gets、Physical Reads都会出现，其SQL模块是Oracle Enterprise Manager.Metric Engine。显然这是一个OEM自己的SQL，检查完整SQL语句： <pre lang=’SQL’>SELECT TO_CHAR(current_timestamp AT TIME ZONE ‘GMT’, ‘YYYY-MM-DD HH24:MI:SS TZD’) AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, ‘YYYY-MM-DD HH24:MI:SS’) >= TO_CHAR(current_timestamp – … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

数据库出现很高的enq: DX – contention 等待

Posted on 2011/10/13 by yangtingkun

检查客户AWR报告时，发现数据库经历严重的enq: DX – contention等待。 这个数据库的版本是11.1.0.6 for Windows 64bits for AMD，在AWR报告中，TOP 5等待事件为： Event Waits Time(s) Avg wait (ms) % DB time Wait Class enq: DX – contention 22,627 135,751 6000 126.41 Other inactive transaction branch 22,625 22,626 1000 21.07 Other db … Continue reading →

Posted in BUG | Tagged , | Leave a comment

LMD出现kjxocdr: drop duplicate open信息

Posted on 2011/10/12 by yangtingkun

在LMD进程对应的TRACE文件lmd0中，发现了这个信息。 这是一个10.2.0.4 RAC环境，详细的信息如下： *** 2011-10-11 16:49:35.171 kjxocdr: DROP duplicate OPEN [0x1a][0x0],[US].148 0x0xdba899230 [held 5][req 5] kjxocdr: DROP duplicate OPEN [0x1a][0x0],[US].148 0x0xdba899230 [held 5][req 5] kjxocdr: DROP duplicate OPEN [0x1a][0x0],[US].148 0x0xdba899230 [held 5][req 5] kjxocdr: DROP duplicate OPEN [0x1a][0x0],[US].148 0x0xdba899230 [held … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(2103)错误

Posted on 2011/10/11 by yangtingkun

检查客户数据库告警日志时，发现ORA-600(2103)错误。 这是一个9208 RAC for Linux 32bit环境，当出现这个错误时，LGWR进程CRASH，导致数据库实例DOWN掉： Sun DEC 7 18:15:02 2008 Errors IN file /u01/product/admin/RAC/bdump/rac2_lgwr_491766.trc: ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], [] Sun DEC 7 18:15:03 2008 Errors IN file /u01/product/admin/RAC/bdump/rac2_lgwr_491766.trc: ORA-00600: internal error … Continue reading →

Posted in BUG | Tagged , | Leave a comment

ORA-600(ksxprqfre3)错误

Posted on 2011/10/10 by yangtingkun

客户的9208环境下的RAC出现这个错误。 详细错误信息为： Errors IN file /u01/product/admin/RAC/bdump/rac1_ora_708706.trc: ORA-00600: internal error code, arguments: [ksxprqfre3], [0x110320F28], [], [], [], [], [], [] ORA-10382: parallel query server interrupt (reset) . . . Errors IN file /u01/product/admin/RAC/bdump/rac1_p002_1212438.trc: ORA-00600: internal error code, arguments: [ksxprqfre3], [0x110319308], [], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

ORA-600(kdsgrp1)错误

Posted on 2011/10/08 by yangtingkun

在一个客户的数据库告警日志中，频繁出现ORA-600(kdsgrp1)错误。 详细错误信息为： /oracle/admin/tjsb/udump/tjsb1_ora_1701138.trc Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production WITH the Partitioning, REAL Application Clusters, DATA Mining AND REAL Application Testing options ORACLE_HOME = /oracle/product/10.2.0/db_1 System name: AIX Node name: p570c Release: 3 Version: 5 Machine: … Continue reading →

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