Tag Archives: rebuild

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

在线索引重建被取消导致大量ORA-600(kghstack_underflow_internal_3)错误

Posted on 2012/05/11 by yangtingkun

客户在比较繁忙的时刻执行了索引的REBUILD操作，导致大量会话被锁，最终对ONLINE REBUILD操作执行了取消操作，引发了一系列更严重的ORA-600错误。 登录数据库后，发现两个节点上ORACLE_BASE所在目录都已经100%占用。数据库无法正常通过/ AS SYSDBA方式登录。 查询告警日志发现大量的ORA-600和ORA-7445错误： Tue May 08 21:20:26 EAT 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_1555.trc: ORA-07445: exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalid permissions FOR mapped object] [0x000000000] [] [] Tue May 08 21:20:27 EAT 2012 Errors IN file … Continue reading →

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

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