Tag Archives: index

ORA-600(6033)错误

Posted on 2012/10/22 by yangtingkun

客户10.2.0.4 RAC for Linux X64环境，告警日志出现ORA-600(6033)错误。 详细错误信息为： /opt/app/oracle/admin/orcl/udump/orcl1_ora_25075.trc Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production WITH the Partitioning, REAL Application Clusters, OLAP, DATA Mining AND REAL Application Testing options ORACLE_HOME = /opt/app/oracle/product/10.2.0/db_1 System name: Linux Node name: hb1 … Continue reading →

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

ORA-600(kauxs_do_jou:3)错误

Posted on 2012/09/28 by yangtingkun

客户9.2.0.6数据库出现ORA-600(kauxs_do_jou:3)错误。 错误信息为： Wed Mar 28 22:44:48 2012 Errors IN file /DATA/oracle/admin/orcl/udump/orcl_ora_19724.trc: ORA-00600: 内部错误代码，参数: [kauxs_do_jou:3], [68], [], [], [], [], [], [] Wed Mar 28 22:46:38 2012 Errors IN file /DATA/oracle/admin/orcl/udump/orcl_ora_19856.trc: ORA-00600: 内部错误代码，参数: [kauxs_do_jou:3], [68], [], [], [], [], [], [] … Continue reading →

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

单个分区索引失效导致绑定变量查询无法使用索引

Posted on 2012/06/27 by yangtingkun

一个客户碰到的问题，由于分区维护操作，导致个别分区对应的索引处于UNUSABLE状态，最终导致基于绑定变量的查询无法利用索引。 通过一个具体的例子来说明这个问题： SQL> CREATE TABLE t_part 2 (id NUMBER, 3 name varchar2(30)) 4 partition BY range (id) 5 (partition p1 VALUES less than (10), 6 partition p2 VALUES less than (20), 7 partition pmax VALUES less than (maxvalue)); TABLE created. … Continue reading →

Posted in ORACLE | 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(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

ORA-600(6002)错误

Posted on 2012/04/19 by yangtingkun

客户数据库出现ORA-600(6002)错误。 在告警文件中出现大量的错误： Sun Apr 1 16:15:41 2012 Errors IN file /oracle/orcl/udump/orcl_ora_16555.trc: ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], [] Sun Apr 1 16:16:43 2012 Errors IN file /oracle/orcl/udump/orcl_ora_16555.trc: ORA-00600: internal error code, arguments: [6002], [0], … Continue reading →

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

ORA-600(20084)错误

Posted on 2012/01/19 by yangtingkun

数据库告警日志中出现错误ORA-600(20084)。 错误信息如下： Mon Aug 31 14:56:51 2009 Errors IN file /oracle/admin/oasisdb/udump/oasisdb1_ora_4787.trc: ORA-00600: 内部错误代码, 参数: [20084], [18125507], [60], [18125507], [60], [], [], []Mon Aug 31 14:56:51 2009 Errors in file /oracle/admin/oasisdb/udump/oasisdb1_ora_4787.trc: ORA-00600: 内部错误代码, 参数: [20084], [18125507], [60], [18125507], [60], [], [], … Continue reading →

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

ORA-600(16608)错误

Posted on 2012/01/08 by yangtingkun

客户10.2.0.4环境出现ORA-600(16608)错误。 详细错误信息如下： Sun DEC 19 11:17:41 2010 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_j005_5937.trc: ORA-00600: internal error code, arguments: [16608], [2], [3], [0x8000002C4FA00DC0], [], [], [], []Sun Dec 19 11:17:41 2010 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_j005_5937.trc: ORA-00600: internal error code, arguments: [16608], [2], [3], … Continue reading →

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

10g新增初始化参数SKIP_UNUSABLE_INDEXES

Posted on 2012/01/02 by yangtingkun

这个10.1就增加的新特性，是最近才发现的。 公司中的新人问起索引失效对表影响，于是随手做了个例子，才发现10g中已经改变了9i中的默认方式： SQL> CREATE TABLE t_index (id NUMBER, name varchar2(30)); TABLE created. SQL> CREATE INDEX ind_t_id ON t_index(id); INDEX created. SQL> CREATE INDEX ind_t_name ON t_index(name); INDEX created. SQL> INSERT INTO t_index VALUES (1, ‘a’); 1 ROW created. SQL> commit; … Continue reading →

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

外键缺少索引引发的死锁

Posted on 2011/11/04 by yangtingkun

客户的10.2.0.4 RAC for AIX环境频繁出现ORA-60死锁问题，导致应用程序无法顺利执行。 经过一系列的诊断，发现最终问题是由于外键上没有建立索引所致，由于程序在主子表上删除数据，缺少索引导致行级锁升级为表级锁，最终导致大量的锁等待和死锁。 下面通过一个例子简单模拟一下问题： SQL> CREATE TABLE t_p (id NUMBER PRIMARY KEY, name varchar2(30)); TABLE created. SQL> CREATE TABLE t_f (fid NUMBER, f_name varchar2(30), FOREIGN KEY (fid) REFERENCES t_p); TABLE created. SQL> INSERT INTO t_p VALUES (1, ‘a’); … Continue reading →

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