Return
-
Title
Post stopped due to ORA-1578, or ORA-600, or ORA-1502 or ORA-08102 -
Description
Post gets Oracle errors ORA-01578, ORA-00600, ORA-01502, or ORA-08102.
These errors indicate that Oracle has found data block corruption either on the table or related indexes.
Notice: ORA-01502: index 'xxx.xxx_x' or partition of such index is in unusable state.
06/17/07 04:33 Process exited sp_opst (for o.ep01-o.rp02 queue ProbQ) [pid = 27733] - exit(1)
06/17/07 04:33 Error: Unexpected Oracle error: ORA-08102: index key not found, obj# 1099412, dba 92342200 (2). (object name: "BOM"."CST_ITEM_COSTS") [sp_opst (for o.ep01-o.rp02 queue ProbQ)/27733]
06/17/07 04:33 Notice: ORA-08102: index key not found, obj# 1099412, dba 92342200 (2). [sp_opst(osp)/27733]
Warning: 15022 - Error posting ODR_UPDATE1 to table LINEAD6.LINE_AD. [sp_opst (for o.SERV-o.SERV queue post_line_a)/15294]
Notice: Oracle error: ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], []. rowid:AAEeTjACSAAAI1lAAs [sp_opst (for o.SERV-o.SERV queue post_line_a)/15294]
Error: 15033 - Failed to execute SQL on table LINEAD6.LINE_AD: ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], []. [sp_opst (for o.SERV-o.SERV queue post_line_a)/15294]"
ORA-01578: ORACLE data block corrupted (file # 55, block # 108192).ORA-01110: data file 55: '/oracle/data04/oradata/test1.dbf'.ORA-26040: Data block was loaded using the NOLOGGING option. (object name: "TEST"."TAB1") [sp_opst (for o.xxx-o.yyyy queue QUEUE1)/15565]
Notice: ORA-01578: ORACLE data block corrupted (file # 55, block # 108192).ORA-01110: data file 55: '/oracle/data04/oradata/test1.dbf'.ORA-26040
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.