ORA-00600: internal error code如何解决？请高手帮忙了！！

显示全部楼层 · 2007-9-26 18:42:10

最近不知道怎么搞的，ALTER文件里经常有这样的东西出来！！
而且确实在实际应用中发现，有异常发生，报6000错误，这个问题如何解决？？？
很头疼！！
Fri Nov 24 13:26:03 2006
Errors in file e:\oracle\admin\zlincs\bdump\zlincs_smon_1992.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [1849], [2072], [], [], [], [], []
zlincs_smon_1992.trc文件显示的对应信息为：
*** 2006-11-24 13:26:03.000
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [1849], [2072], [], [], [], [], []

此外ALTER文件里，还有如下的信息：
Fri Nov 24 13:23:10 2006
Errors in file e:\oracle\admin\zlincs\bdump\zlincs_qmn0_3260.trc:
ORA-00600: internal error code, arguments: [4193], [1824], [2098], [], [], [], [], []
zlincs_qmn0_3260.trc文件显示的对应信息为：
Fri Nov 24 13:23:10 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Instance name: zlincs
Redo thread mounted by this instance: 1
Oracle process number: 9
Windows thread id: 3260, image: ORACLE.EXE

*** SESSION ID

8.33) 2006-11-24 13:23:10.000
*** 2006-11-24 13:23:10.000
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4193], [1824], [2098], [], [], [], [], []
Current SQL statement for this session:
select t.schema, t.name, t.flags, q.name from system.aq$_queue_tables t, sys.aq$_queue_table_affinities aft,system.aq$_queues q where aft.table_objno = t.objno and aft.owner_instance = :1 andq.table_objno = t.objno and q.usage = 0 and bitand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name, aft.table_objno skip locked

千问 · 2007-9-26 18:42:10

ORA-600 [4193] "seq# mismatch while adding undo record"
Doc ID:Note:39282.1 Type:REFERENCE
Last Revision Date:25-MAR-2004 Status:PUBLISHED

Note: For additional ORA-600 related information please read Note 146580.1
PURPOSE:

This article discusses the internal error "ORA-600 [4193]", what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.
ERROR:

ORA-600 [4193] [a]
VERSIONS:
versions 6.0 to 10.1
DESCRIPTION:
A mismatch has been detected between Redo records and Rollback (Undo)
records.
We are validating the Undo block sequence number in the undo block against
the Redo block sequence number relating to the change being applied.
This error is reported when this validation fails.
ARGUMENTS:
Arg [a] Undo record seq number
ArgRedo record seq number
FUNCTIONALITY:
KERNEL TRANSACTION UNDO
IMPACT:
PROCESS FAILURE
POSSIBLE ROLLBACK SEGMENT CORRUPTION
SUGGESTIONS:
This error may indicate a rollback segment corruption.
This may require a recovery from a database backup depending on
the situation.
For further analysis, please submit the trace files and alert.log to
Oracle Support Services.
Known Issues:

千问 · 2007-9-26 18:42:10

This error may indicate a rollback segment corruption.
This may require a recovery from a database backup depending on
the situation.
汗，没办法了～～·

千问 · 2007-9-26 18:42:10

我重建了undo tablespace ,eygle上说的，只能试试了，，，另metalink确实说的很详细！！！

千问 · 2007-9-26 18:42:10

如果持续出这样的问题。或许需要考虑磁盘状况。