Oracle errors

[Paul H]

hello folks, have been getting the following error messages all over the weekend, called out twice becuase database crashed, although the errors keep spewing out every five minutes (on ALRT file)

ORACLE Instance pmlv (pid = 6) - Error 600 encountered while recovering transaction (5, 12) on object 1480.
Mon May 21 08:01:47 2001
Errors in file C:\ORANT\RDBMS73\trace\pmlvSMON.TRC:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []

Mon May 21 08:06:48 2001
Errors in file C:\ORANT\RDBMS73\trace\pmlvSMON.TRC:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []

Any assistance gratefully received.

[pipo]

Hi. This error indicates index corruption. In one of the trace files, search for 'Block header dump:' Under that, you should see a line that contains 'seg/obj:' followed by a hex number.

Further on that same line, should be the word 'INDEX' The number converted to decimal is the object_id from dba_objects for the index.

I recommend performing an 'analyze index ... validate structure;' on that index. If this fails as well, you will need to recreate the index.

Hope this helps

[shawish_sababa]

Hi

first, what version are you on? if it is 8.0.... then you may have ren into a bug. The bug occurs for a variety of reasons where certain operations (such as TRUNCATE)
may under some timing conditions cause DBWR to crash. this look like it if you take into account the reference to smon that it is performing temporary segment cleanup, or
free space coalescing. normaly smon wakes up every 5 minutes, wich again, looks like your case.

any way, if you look at the metalink it is writen that every occurrence of an ORA-600 should be reported to Oracle Support. the resone is that unlike other errors, you can not find help text for these errors. only Oracle Support should take actions to resolve the problem. in yhis case let them lead the way.