Alert Log Shows ORA-00600 [13011] and ORA-00600[kewrose_1] (Doc ID 2678071.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• Alert log reports errors following errors from delete statement:
  
  DELETE statement shown in the trace log is causing the ORA-600s:

  delete from <table_name> tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and
  not exists (select 1 from <table1> b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id))
  
  ORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600: internal error code, arguments: [13011], [57824], [12769512], [26], [12699054], [0], [], [], [], [], [], []

  Main Stack:
  OCIKSIN <- kewrose_oci_stmt_exec <- kewrgwxf1_gwrsql_exft_1
  <- kewrgwxf_gwrsql_exft <- kewrpsn_purge_snapshot <- kewrpdc_periodic_cleanup
  <- kewrsnrm_snapshot_removal <- kewrpsr_purge_snapshot_range
  <- kewrapad_auto_purge_all_dbids <- kewraps_auto_purge_slave <- kebm_slave_main
  <- ksvrdp <- opirip <- opidrv <- sou2o <- opimai_real <- opimai <- BackgroundThreadStart

  ...

  ORA-00600: internal error code, arguments: [13011], [57824], [12769512], [26], [12699054], [0], [], [], [], [], [], []

  Main Stack:
  delexe <- opiexe <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr <- xupirtrc <- upirtrc
  <- kpurcsc <- kpuexec <- OCIStmtExecute <- kewrose_oci_stmt_exec
  <- kewrgwxf1_gwrsql_exft_1 <- kewrgwxf_gwrsql_exft <- kewrpsn_purge_snapshot
  <- kewrpdc_periodic_cleanup <- kewrsnrm_snapshot_removal
  <- kewrpsr_purge_snapshot_range <- kewrapad_auto_purge_all_dbids
  <- kewraps_auto_purge_slave <- kebm_slave_main <- ksvrdp <- opirip <- opidrv <- sou2o
  <- opimai_real <- opimai <- BackgroundThreadStart

   

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.