今天一个网友告诉我修改字段报错及比如
alter table testfu modify table_name varchar2(200);
这种报错
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []
查看TRACE 文件，其环境如下：
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: AIX
Node name: Bbxqga_db1
Release: 1
Version: 6
Machine: 00F7F1E84C00
Instance name: jkdbutf8
Redo thread mounted by this instance: 1
Oracle process number: 50
Unix process pid: 3736630, image: oracle@Bbxqga_db1 (TNS V1-V3)
其报错语句来自于：
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []
Current SQL statement for this session:
select o.owner#, u.name, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property,0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# order by o.obj#
查看MOS如下：
SQL> analyze table dependency$ validate structure cascade ;
analyze table dependency$ validate structure cascade
*
ERROR at line 1:
ORA-1499: table/index cross reference failure - see trace file
SQL> SQL> ALTER INDEX I_DEPENDENCY1 REBUILD ONLINE ;
Index altered.
SQL> SQL> ALTER INDEX I_DEPENDENCY2 REBUILD ONLINE ;
Index altered.
SQL> SQL> SQL>
SQL> analyze table dependency$ validate structure cascade ;
这个BUG信息：
Bug 17804084 : ORA-600 [KDSGRP1]
单击此项可添加到收藏夹 通过电子邮件发送此文档的链接 可打印页 转到底部转到底部
BUG属性：
Bug 17804084 : ORA-600 [KDSGRP1]
类型 B - Defect 已在产品版本中修复
严重性 2 - Severe Loss of Service 产品版本 10.2.0.4
状态 33 - Suspended, Req'd Info not Avail 平台 212 - IBM AIX on POWER Systems (64-bit)
创建时间 2013-11-15 平台版本 NO DATA
更新时间 2014-4-2 基本 Bug N/A
数据库版本 10.2.0.4.0 影响平台 Generic
可以看到这个错误由于dependency$索引损坏，重建索引后正常。
记录于此
alter table testfu modify table_name varchar2(200);
这种报错
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []
查看TRACE 文件，其环境如下：
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System name: AIX
Node name: Bbxqga_db1
Release: 1
Version: 6
Machine: 00F7F1E84C00
Instance name: jkdbutf8
Redo thread mounted by this instance: 1
Oracle process number: 50
Unix process pid: 3736630, image: oracle@Bbxqga_db1 (TNS V1-V3)
其报错语句来自于：
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []
Current SQL statement for this session:
select o.owner#, u.name, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property,0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# order by o.obj#
查看MOS如下：
SQL> analyze table dependency$ validate structure cascade ;
analyze table dependency$ validate structure cascade
*
ERROR at line 1:
ORA-1499: table/index cross reference failure - see trace file
SQL> SQL> ALTER INDEX I_DEPENDENCY1 REBUILD ONLINE ;
Index altered.
SQL> SQL> ALTER INDEX I_DEPENDENCY2 REBUILD ONLINE ;
Index altered.
SQL> SQL> SQL>
SQL> analyze table dependency$ validate structure cascade ;
这个BUG信息：
Bug 17804084 : ORA-600 [KDSGRP1]
单击此项可添加到收藏夹 通过电子邮件发送此文档的链接 可打印页 转到底部转到底部
BUG属性：
Bug 17804084 : ORA-600 [KDSGRP1]
类型 B - Defect 已在产品版本中修复
严重性 2 - Severe Loss of Service 产品版本 10.2.0.4
状态 33 - Suspended, Req'd Info not Avail 平台 212 - IBM AIX on POWER Systems (64-bit)
创建时间 2013-11-15 平台版本 NO DATA
更新时间 2014-4-2 基本 Bug N/A
数据库版本 10.2.0.4.0 影响平台 Generic
可以看到这个错误由于dependency$索引损坏，重建索引后正常。
记录于此
