4 Replies Latest reply on Oct 1, 2012 7:40 PM by 221362

    ORA-00600 [xspggepGenErase04: No AW generations]

    221362
      Hi all.

      Have had an odd error a couple of time over the last 2 months on upd/commit.

      Looks like the error stack is:

      DBMS_AW.EXECUTE
      |-->upd/commit
      |--> !Something goes wrong!
      |--->ORA-00600: internal error code, arguments: [xspggepGenErase04: No AW generations],
      |---> ERROR: (ORA-34738) A severe problem has been detected. Analytic workspace operations have been disabled.
      |----> OLAP OOPS encountered, disabling UPDATEs to AWs

      All is okay again after session restart even if i re-run the entire dml redo including the commit.

      Can't find anything similar on metalink and its annoying as I can't replicate on demand. Anyone encountered this before?

      DB 11.2.0.3, Redhat 5.6

      Thanks

      nf