ORA-07445: Exception Encountered: Core Dump [lnxsni()+114] (Doc ID 2020665.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On Oracle 12c, the alert log reports next error:

CJQ0 started with pid=52, OS id=1010
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0xCD0F102, lnxsni()+114] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_1010.trc  (incident=35473) (PDBNAME=CDB$ROOT):
ORA-07445: exception encountered: core dump [lnxsni()+114] [SIGSEGV] [ADDR:0x0] [PC:0xCD0F102] [Address not mapped to object] []


The trace file with the ORA-7445, shows characteristics like:

...
*** 2015-06-08 10:11:00.422
*** SESSION ID:(254.33941) 2015-06-08 10:11:00.422
*** CLIENT ID:() 2015-06-08 10:11:00.422
*** SERVICE NAME:(SYS$BACKGROUND) 2015-06-08 10:11:00.422
*** MODULE NAME:() 2015-06-08 10:11:00.422
*** CLIENT DRIVER:() 2015-06-08 10:11:00.422
*** ACTION NAME:() 2015-06-08 10:11:00.422
*** CONTAINER ID:(1) 2015-06-08 10:11:00.422

[TOC00000]
Jump to table of contents
Dump continued from file: /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_26546.trc
[TOC00001]
ORA-07445: exception encountered: core dump [lnxsni()+114] [SIGSEGV] [ADDR:0x0] [PC:0xCD0F102] [Address not mapped to object] []

[TOC00001-END]
[TOC00002]
========= Dump for incident 33265 (ORA 7445 [lnxsni]) ========
[TOC00003]
----- Beginning of Customized Incident Dump(s) -----
Dumping swap information
Memory (Avail / Total) = 467.28M / 7727.86M
Swap (Avail / Total) = 4102.89M /  4112.00M
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0xCD0F102, lnxsni()+114] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000000000001 %rbx: 0x0000000000000000 %rcx: 0x0000000000000002
%rdx: 0x0000000000000001 %rdi: 0x0000000000000000 %rsi: 0x0000000000000002
%rsp: 0x00007fffe3ad1260 %rbp: 0x00007fffe3ad1300  %r8: 0x0000000000000002
%r9: 0x0000000000000060 %r10: 0x00007f3487653e30 %r11: 0x0000000000000040
%r12: 0x0000000000000002 %r13: 0x0000000000000008 %r14: 0x00007fffe3ad1348
%r15: 0x0000000000000001 %rip: 0x000000000cd0f102 %efl: 0x0000000000010202
 lnxsni()+99 (0xcd0f0f3) cmove %eax,%edx
 lnxsni()+102 (0xcd0f0f6) mov %edx,-0x58(%rbp)
 lnxsni()+105 (0xcd0f0f9) test %rcx,%rcx
 lnxsni()+108 (0xcd0f0fc) jz 0xcd0fa34
> lnxsni()+114 (0xcd0f102) movzbl (%rbx),%eax
 lnxsni()+117 (0xcd0f105) cmp $1,%rcx
 lnxsni()+121 (0xcd0f109) jz 0xcd0fa20
 lnxsni()+127 (0xcd0f10f) mov %eax,%r15d
 lnxsni()+130 (0xcd0f112) shr $0x7,%r15d

*** 2015-06-08 10:11:00.428
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=3bdrj5zz7f04f) -----
select /*+ no_monitor */ CON_ID, OBJOID, RETRYCNT, FLAGS, STATUS,      ISLW, PARNT, JDESTID, LSTIME FROM (  select nvl(a.con_id,0) CON_ID, a.obj# OBJOID, a.retry_count RETRYCNT,     a.job_status STATUS, a.flags FLAGS, a.running_instance RUNINST,     0 ISLW, 0 PARNT, a.job_dest_id JDESTID, a.last_start_date LSTIME  from sys.scheduler$_cdb_job a  union all  select nvl(b.con_id,0), b.obj#, b.retry_count, b.job_status, b.flags,    b.running_instance, 1,    decode(bitand(b.flags, 137438953472), 0, 0, b.program_oid), b.job_dest_id,    b.last_start_date  from sys.scheduler$_cdb_comb_lw_job b )  where ((bitand(STATUS, 2) = 2 and  LSTIME < :1   and ( (RUNINST = :2  )      or ( RUNINST is not null            and  RUNINST not in (select inst_id from gv$instance)))) )  order by CON_ID, OBJOID
[TOC00004-END]

[TOC00005]
----- Call Stack Trace ---------
... lnxsni evaban evaopn2 evareo expepr evaiand expeal kpdbcvFetchCbkCon kpdbcvFetch qerfxFetch qergiFetch rwsfcd qeruaFetch qervwFetch qerflFetchOutside qersoProcessULS qersoFetchSimple qersoFetch opifch2 opifch opiodr ...

 

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