启动数据库,数据进行实例恢复完成后,能成功open,但数据库在几分钟后自动宕掉,通过alert日志,可以看到宕库前报错是ORA-00600 arguments: [4194]。2. 问题分析 参考MOS文档:Step by step to resolve ORA-600 4194 4193 4197 on database crash (Doc ID 1428786.1),有该错误的介绍和处理方法。通过文档介绍...
ORA-00600: internal error code, arguments: [4194], [19], [23], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [19], [23], [], [], [], [], [] Thu Mar 25 17:37:09 2010 Errors in file /u01/app/oracle/admin/rcms/bdump/rcms_j000_2233.trc:...
ORA-00600: internal error code, arguments: [4194], [19], [23], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [19], [23], [], [], [], [], [] Thu Mar 25 17:37:09 2010 Errors in file /u01/app/oracle/admin/rcms/bdump/rcms_j000_2233.trc:...
客户有一套测试库主机宕机,主机启动后,数据库启动报ORA-00600 [4194],本文介绍处理过程。 1. 问题现象 启动数据库,数据进行实例恢复完成后,能成功open,但数据库在几分钟后自动宕掉,通过alert日志,可以看到宕库前报错是ORA-00600 arguments: [4194]。 alter database open Beginning crash recovery of 1 threads ...
如果数据库启动不了,在 alert log 中发现了 ORA-00600[4194] 错误,表明 UNDO 和 REDO 中记录的 undo 记录不一致。此时,需要尝试重新建立新的 UNDO,我们需要找到老的 UNDO,把它 变成 offline, 然后建立新的 UNDO,再重新启动。 具体作法是: 创建PFILE, 例如: ...
oracle断电重启之ORA-00600[4194] 1.问题描述 Oracle服务器断电重启以后无法数据库无法正常连接,使用sqlplus envision/envision连接报错。常见的错误有以下这些: ORA-12518: TNS:listener could not hand off client connection ORA-12560: TNS:protocol adapter error...
简介:ORA-00600: internal error code, arguments: [4194] 4193:表示undo和redo不一致(Arg [a] Undo record seq number,Arg [b] Redo record s... ORA-00600: internal error code, arguments: [4194] 4193:表示undo和redo不一致(Arg [a] Undo record seq number,Arg [b] Redo record seq number );...
ORA-00600[4194]错误的根本原因是 redo记录与回滚段(rollback/undo)记录之间的不一致。当ORACLE在验证undo记录时相对应的变化需要应用到undo数据块的最大undo记录上,此时若检验出错则会报ORA-00600[4194]此错误不像ORA-600[2662]或ORA-600[4000]错误那样必然导致数据库无法打开,因为它很少出现在前滚...
ORA-00600: internal error code, arguments: [4194] ,ORA-00607,今天有个童鞋说自己的client连接不上server端了通过口头指导实在无法弄好,当时心里还愤愤一个oraclenet问题搞这么长时间让对方发远程给我童鞋的服务端是windows端的,进来的第一件事就是sqlplus/assysdba直
ORA-600 [4194] "Undo Record Number Mismatch While Adding Undo Record" 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 record number relating to the change being applied against the maximum un...