Core Dump Getting Generated Frequently With ORA-7445 [QERSOPROCESSULS] Error (Doc ID 1457903.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

1. An INSERT statement fails with:
   
   ORA-07445: exception encountered: core dump [qersoProcessULS()+104] [SIGSEGV] [ADDR:0x1B1] [PC:0x10637D2C8] [Invalid permissions for mapped object] []
   
   
   
2. Review of the generated tracefiles reveals a call stack similar to:
   
   ... <- 47b8 <- qerjoFetch <- qerstFetch <- qersqFetch <- qerstFetch <- rwsfcd <- qerstFetch <- qerltcFetch <- qerstFetch <- insexe <- opiexe <- opipls <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_EXECC <- pfrinstr_EXECC <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- opipls <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2 < ...
   
   
   
3. SQL Trace (event 10046) is enabled for the failing session.

Cause

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