Oracle errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle errors

  1. #1
    Join Date
    Oct 2000
    Posts
    57

    Angry

    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.

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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

  3. #3
    Join Date
    Jul 2000
    Posts
    243
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width