ORA-600 [4194] Description

I.Description

A friend's library cannot be opened. The error message is as follows:

Errors in filef: \ app \ administrator \ diag \ rdbms \ orcl \ trace \ orcl_ora_assist.trc (incident = 89062 ):

ORA-00600: Internal error code, parameter: [4194], [78], [8], [], [], [], [], [], [], [], [], [], []

ORA-00600: Internal error code, parameter: [4194], [78], [8], [], [], [], [], [], [], [], [], [], []

Incident details in: f: \ app \ administrator \ diag \ rdbms \ orcl \ incident \ incdir_89062 \ orcl_ora_1__i89062.trc

Trace dumping is required mingid = [cdmp_20120730184640]

Errors in file f: \ app \ administrator \ diag \ rdbms \ orcl \ trace \ orcl_ora_assist.trc:

ORA-00600: Internal error code, parameter: [4194], [78], [8], [], [], [], [], [], [], [], [], [], []

ORA-00600: Internal error code, parameter: [4194], [78], [8], [], [], [], [], [], [], [], [], [], []

Mon Jul 30 18:46:41 2012

Errors in filef: \ app \ administrator \ diag \ rdbms \ orcl \ trace \ orcl_ora_assist.trc (incident = 90109 ):

ORA-00603: Oracle server session terminatedby fatal error

ORA-00600: internal error code, arguments: [4194], [78], [8], [], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [78], [8], [], [], [], [], [], [], [], [], [], []

Incident details in: f: \ app \ administrator \ diag \ rdbms \ orcl \ incident \ incdir_90109 \ orcl_ora_1__i90109.trc

Errors in filef: \ app \ administrator \ diag \ rdbms \ orcl \ incident \ incdir_90109 \ orcl_ora_pai_i90109.trc:

ORA-00603: ORACLE server session terminatedby fatal error

ORA-00600: internal error code, arguments: [4194], [78], [8], [], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [78], [8], [], [], [], [], [], [], [], [], [], []

The ORA-600 in [41XX] format is related to UNDO.

II. MOS About ORA-600 [4194] Description

ORA-600 [4194] "Undo Record NumberMismatch While Adding Undo Record" [ID 39283.1]

ERROR:

Format: ORA-600 [4194] [a] [B]

 

VERSIONS:

Versions 6.0 to 10.1

 

DESCRIPTION:

 

Amismatch has been detected between Redo records and rollback (Undo) records.

--This error is detected.Redo recordsAndRollback(Undo)RecordsInconsistent.

 

Weare validating the Undo record number relating to the change being appliedagainst the maximum undo record number recorded in the undo block.

 

Thiserror is reported when the validation fails.

 

ARGUMENTS:

Arg [a] Maximum Undo record number in Undo block

--Parameters here[A]YesUndo blockThe largestUndo recordNumber.

Arg [B] Undo record number from Redo block

--Parameters[B]YesRedo blockInUndo records.

 

FUNCTIONALITY:

Kernel Transaction Undo called from Cache layer

 

IMPACT:

PROCESSFAILURE

Possible rollback segment failed uption

SUGGESTIONS:

This error may indicate a rollback segment failed uption.

This may require a recovery from a database backup depending on thesituation.

III. Solution

Recreate the UNDO tablespace. For more information, see:

How to deal with Currentonline Redo and Undo corruption

Related links:
Oracle undo tablespace Management
OracleORA-600 [4193] solution description