This discussion is archived
4 Replies Latest reply: Oct 1, 2012 12:40 PM by 221362 RSS

ORA-00600 [xspggepGenErase04: No AW generations]

221362 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points