ORA-00607:ORA-00600:

今天过程跑数的时候报：

ORA-06512: at "HBKF_CRM.PROC_LINK_INSERT", line 182
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [5], [427936], [18038], [], [], [], []
ORA-06512: at line 1

感谢：http://www.linuxidc.com/Linux/2012-10/71987.htm 给提供的解决方法。

原文如下：

前些天Oracle数据库服务器出现了一下错误：

SQL*Loader-961:  对表 table1 调用一次/加载完成时出错 
ORA-00607: Internal error occurred while making a change to a data block 
ORA-00600: internal error code, arguments: [kddummy_blkchk], [8], [565129], [18021], [], [], [], []

SQL*Loader-2026:  加载因 SQL 加载程序无法继续而被终止

关于ORA-00600错误描述：

引用
ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string], [string], [string], [string], [string] 
Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. The first argument is the internal message number. This argument and the database version number are critical in identifying the root cause and the potential impact to your system. 
Action: Visit My Oracle Support to access the ORA-00600 Lookup tool (reference Note 600.1) for more information regarding the specific ORA-00600 error encountered. An Incident has been created for this error in the Automatic Diagnostic Repository (ADR). When logging a service request, use the Incident Packaging Service (IPS) from the Support Workbench or the ADR Command Interpreter (ADRCI) to automatically package the relevant trace information (reference My Oracle Support Note 411.1). The following information should also be gathered to help determine the root cause: 
- changes leading up to the error

- events or unusual circumstances leading up to the error

- operations attempted prior to the error

- conditions of the operating system and databases at the time of the error Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.

关于ORA-00607错误描述：

引用
ORA-00607: Internal error occurred while making a change to a data block 
Cause: An internal error or memory exception occurred while Oracle was applying redo to a data block.
Action: call Oracle Support

参考了网上的一些资料,通过以下操作解决ORA-00600和ORA-00607错误： 
Ora-00600解决步骤--代码

sqlplus /nolog
conn / as sysdba;
#查看undo的表空间管理方式应该是auto
show parameter undo;
#修改undo的表空间管理方式为manual
alter system set undo_management=manual scope=spfile;
shutdown immediate;
startup;
#创建undo临时表空间
create undo tablespace undo2 datafile '/opt/oradata/tgt/undo2.dbf' size 200M;
#修改undo表空间为undo2
alter system set undo_tablespace=undo2 scope=spfile;
#将undo表空间管理模式修改为auto
alter system set undo_management=auto scope=spfile;
shutdown immediate;
startup;

执行完以上操作后为发现ORA-00600错误，说明重建表空间问题解决，接下来将undo表空间改回undotbs1

drop tablespace undotbs1 including contents and datafiles;
create undo tablespace undotbs1 datafile '/opt/oradata/tgt/undotbs1.dbf' size 500M;
alter system set undo_management=manual scope=spfile;
shutdown immediate;
startup;
alter system set undo_tablespace=undotbs1 scope=spfile;
alter system set undo_management=auto scope=spfile;
shutdown immediate;
startup;
#删除刚刚临时重建的undo2表空间
drop tablespace undo2 including contents and datafiles;

Ora-00607解决步骤--代码

------------------------------------------------------

自己的一点见解：

SELECT tablespace_name,segment_type,owner,segment_name
FROM dba_extents
WHERE file_id = 5
AND 427936 between block_id AND block_id+blocks-1;

 

显示结果：

1 USERS TABLE HBKF_CRM OD_V_PROD_INFO_MON

备份表：OD_V_PROD_INFO_MON

drop 掉OD_V_PROD_INFO_MON，

create 表OD_V_PROD_INFO_MON as 备份表。

重新跑过程，顺利通过。没有重启数据库？！