viernes, 1 de agosto de 2008

ORA-00600: internal error code, arguments: [kteuPropTime-2]

Error :


On July 18th we had the bug #2431450 in one of our database. This were the symptoms and solution :

In the alert.log this errors showed :

Initial error :

Errors in file /u01/app/oracle/admin/dbpa/udump/dbpa_ora_10047.trc:

ORA-00600: internal error code, arguments: [kteuPropTime-2], [], [], [], [], [], [], []

Next errors :

ORA-00600: internal error code, arguments: [25012], [1], [289], [], [], [], [], []


Workaround :


Set UNDO_MANAGEMENT to MANUAL

Drop UNDO tablespace

Recreate UNDO tablespace

Set UNDO_MANAGEMENT to AUTO

Execute a log switch to verify the problem is solved