ORA-07445[PC:0x5D6EE30A] [ACCESS_VIOLATION] [ADDR:0x3BCB0000] [PC:0x5D6EE30A] [UNABLE_TO_WRITE] Errors when trying to update a corrupt table (Doc ID 2091787.1)

Last updated on DECEMBER 24, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

The alert log reports the following errors:

Tue Sep 29 07:10:19 2015
Exception [type: ACCESS_VIOLATION, UNABLE_TO_WRITE] [ADDR:0x3BCB0000] [PC:0x5D6EE30A, 000000005D6EE30A]
ERROR: Unable to normalize symbol name for the following short stack (at offset 213):
dbgexProcessError()+200<-dbgeExecuteForError()+65<-dbgePostErrorKGE()+2269<-dbkePostKGE_kgsf()+77<-kgeade()+562<-kgerelv()+151<-kgerev()+45<-kgerec5()+60<-sss_xcpt_EvalFilterEx()+1862<-sss_xcpt_EvalFilter()+174<-.1.6_8+59<-00007FF8E03C28A6<-00007FF8E03D3F1D<-00007FF8E0394897<-00007FF8E03D30AA<-000000005D6EE30A<-kdrrcps()+90<-kdumrp()+734<-kduurp()+2553<-kdusru()+1060<-kauupd()+534<-updrow()+2900<-qerupFetch()+1060<-updaul()+1724<-updThreePhaseExe()+412<-updexe()+430<-opiexe()+20517<-kpoal8()+2397<-opiodr()+1631<-ttcpip()+1462<-opitsk()+2201<-opiino()+1246<-opiodr()+1631<-opidrv()+861<-sou2o()+98<-opimai_real()+158<-opimai()+191<-OracleThreadStart()+724<-00007FF8E00813D2<-00007FF8E0355454
Errors in file D:\ORACLE\diag\rdbms\cisprod\cisprod\trace\cisprod_ora_4228.trc (incident=41731):
ORA-07445: exception encountered: core dump [PC:0x5D6EE30A] [ACCESS_VIOLATION] [ADDR:0x3BCB0000] [PC:0x5D6EE30A] [UNABLE_TO_WRITE] []
Incident details in: D:\ORACLE\diag\rdbms\cisprod\cisprod\incident\incdir_41731\cisprod_ora_4228_i41731.trc

The current SQL from the trace file is similar to:

UPDATE ADVANCED.COL024 SET L_PROCESSED=1 WHERE I_COL024PK = 4877705;

The call stack from the incident trace file shows functions like:

kdrrcps  kdumrp  kduurp  kdusru  kauupd  updrow qerupFetch updaul  updThreePhaseExe  updexe  opiexe  kpoal8  opiodr  ttcpip opitsk  opiino  opiodr  opidrv  sou2o  opimai_real  opimai  OracleThreadStart  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms