Hello all,
I had faced some occourrences of this error in a 11.2.0.1 database recently.
ORA-07445: exception encountered: core dump [nstimexp()+45] [SIGSEGV] [ADDR:0x58] [PC:0x7F42ABB] [Address not mapped to object] []
After some investigation I found a match to Bug 3934729.
This issue is originally to matched to Bug 6918493, that is a reintroduction of Bug 2752985 but it’s fixed in 11.2.0.1.
However, on upgrading to 11.2.0.1 it’s a hit on Bug 3934729 which is fixed in 11.2.0.2.
Recommended actions are:
– Upgrade databases do 11.2.0.2 or higher. (best solution, but may require more efforts to validate the upgrade).
– Apply Patch 3934729: RANDOM ORA-07445 CORE DUMPS FROM DATABASE AND ORA-3113 FROM APPLICATION
– Set sqlnet.expire_time=0 (workaround)
– Ignore error.
After some research I decided to apply workaround, based on recommended usage of sqlnet.expire_time (Next weeks post is about this parameter :)).
This might be the root cause for the ORA-03135: connection lost contact and the actual value of this parameter on environment was 1, which is a very low value.
So, check which action is more suitable for your environment!
Hope it helps 🙂
Below some additional informations on my situation:
# Alert Log:
Mon Jun 05 08:01:47 2017 Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x58] [PC:0x7F42ABB, nstimexp()+45] [flags: 0x0, count: 1] Errors in file /opt/oracle/app/diag/rdbms/GREPORADB/GREPORADB/trace/GREPORADB_ora_7805.trc (incident=90473): ORA-07445: exception encountered: core dump [nstimexp()+45] [SIGSEGV] [ADDR:0x58] [PC:0x7F42ABB] [Address not mapped to object] [] Errors in file /opt/oracle/app/diag/rdbms/GREPORADB/GREPORADB/trace/GREPORADB_ora_7779.trc (incident=90369): ORA-07445: exception encountered: core dump [nstimexp()+45] [SIGSEGV] [ADDR:0x58] [PC:0x7F42ABB] [Address not mapped to object] [] ORA-03135: connection lost contact Incident details in: /opt/oracle/app/diag/rdbms/GREPORADB/GREPORADB/incident/incdir_90369/GREPORADB_ora_7779_i90369.trc Incident details in: /opt/oracle/app/diag/rdbms/GREPORADB/GREPORADB/incident/incdir_90473/GREPORADB_ora_7805_i90473.trc
# Trace File:
Trace file /opt/oracle/app/diag/rdbms/GREPORADB/GREPORADB/trace/GREPORADB_ora_7805.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /opt/oracle/app/product/11.2.0/GREPORADB System name: Linux Node name: SERVER01.grepora.com Release: 2.6.32-431.el6.x86_64 Version: #1 SMP Sun Nov 10 22:19:54 EST 2013 Machine: x86_64 Instance name: GREPORADB Redo thread mounted by this instance: 1 Oracle process number: 399 Unix process pid: 7805, image: oracle@SERVER01.grepora.com *** 2017-06-05 08:01:47.679 *** SESSION ID:(2015.8118) 2017-06-05 08:01:47.679 *** CLIENT ID:() 2017-06-05 08:01:47.679 *** SERVICE NAME:(SYS$USERS) 2017-06-05 08:01:47.679 *** MODULE NAME:() 2017-06-05 08:01:47.679 *** ACTION NAME:() 2017-06-05 08:01:47.679 Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x58] [PC:0x7F42ABB, nstimexp()+45] [flags: 0x0, count: 1] Incident 90473 created, dump file: /opt/oracle/app/diag/rdbms/GREPORADB/GREPORADB/incident/incdir_90473/GREPORADB_ora_7805_i90473.trc ORA-07445: exception encountered: core dump [nstimexp()+45] [SIGSEGV] [ADDR:0x58] [PC:0x7F42ABB] [Address not mapped to object] [] ssexhd: crashing the process... Shadow_Core_Dump = partial [...]
# Dump File:
Dump file /opt/oracle/app/diag/rdbms/GREPORADB/GREPORADB/incident/incdir_90473/GREPORADB_ora_7805_i90473.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /opt/oracle/app/product/11.2.0/GREPORADB System name: Linux Node name: SERVER01.grepora.com Release: 2.6.32-431.el6.x86_64 Version: #1 SMP Sun Nov 10 22:19:54 EST 2013 Machine: x86_64 Instance name: GREPORADB Redo thread mounted by this instance: 1 Oracle process number: 399 Unix process pid: 7805, image: oracle@SERVER01.grepora.com *** 2017-06-05 08:01:47.793 *** SESSION ID:(2015.8118) 2017-06-05 08:01:47.793 *** CLIENT ID:() 2017-06-05 08:01:47.793 *** SERVICE NAME:(SYS$USERS) 2017-06-05 08:01:47.793 *** MODULE NAME:() 2017-06-05 08:01:47.793 *** ACTION NAME:() 2017-06-05 08:01:47.793 Dump continued from file: /opt/oracle/app/diag/rdbms/GREPORADB/GREPORADB/trace/GREPORADB_ora_7805.trc ORA-07445: exception encountered: core dump [nstimexp()+45] [SIGSEGV] [ADDR:0x58] [PC:0x7F42ABB] [Address not mapped to object] [] ========= Dump for incident 90473 (ORA 7445 [nstimexp()+45]) ======== ----- Beginning of Customized Incident Dump(s) ----- Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x58] [PC:0x7F42ABB, nstimexp()+45] [flags: 0x0, count: 1] Registers: %rax: 0x0000000000000000 %rbx: 0x0000000000000000 %rcx: 0x000000000357b0ee %rdx: 0x000000000c91de68 %rdi: 0x000000000c9221e0 %rsi: 0x000000000c921a00 %rsp: 0x00007fff8e58d350 %rbp: 0x00007fff8e58d4d0 %r8: 0x0000000000000001 %r9: 0x0000000000000000 %r10: 0x0000000000000008 %r11: 0x0000000000000202 %r12: 0x000000000c922230 %r13: 0x000000000357b0ee %r14: 0x000000000c911ed0 %r15: 0x000000000c921a00 %rip: 0x0000000007f42abb %efl: 0x0000000000010206 > (0x7f42abb) mov 0x58(%rax),%r13 (0x7f42abf) movzbl 0x9(%r13),%edx (0x7f42ac4) xor %r9d,%r9d (0x7f42ac7) mov %r9d,-0x48(%rbp) (0x7f42acb) test $0x1,%dl *** 2017-06-05 08:01:47.798 dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0) ----- SQL Statement (None) ----- Current SQL information unavailable - no cursor. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- skdstdst()+36 call kgdsdst() 000000000 ? 000000000 ? 7F8B27330F98 ? 000000001 ? 7F8B27335498 ? 000000000 ? ksedst1()+98 call skdstdst() 000000000 ? 000000000 ? 7F8B27330F98 ? 000000001 ? 000000000 ? 000000000 ? ksedst()+34 call ksedst1() 000000001 ? 000000001 ? 7F8B27330F98 ? 000000001 ? 000000000 ? 000000000 ? dbkedDefDump()+2736 call ksedst() 000000001 ? 000000001 ? 7F8B27330F98 ? 000000001 ? 000000000 ? 000000000 ? ksedmp()+36 call dbkedDefDump() 000000003 ? 000000003 ? 7F8B27330F98 ? 000000001 ? 000000000 ? 000000000 ? ssexhd()+2326 call ksedmp() 000000003 ? 000000003 ? 7F8B27330F98 ? 000000001 ? 000000000 ? 000000000 ? __restore_rt() call ssexhd() 00000000B ? 7F8B27339BF0 ? 7F8B27339AE8 ? 000000001 ? 000000000 ? 000000000 ? nstimexp()+45 signal __restore_rt() 00C4A51E0 ? 00C4A4A00 ? 00C4A0E68 ? 00357B0F1 ? 000000001 ? 000000000 ? ltmdvp()+182 call nstimexp() 00C4A51E0 ? 00C4A4A00 ? 00C4A0E68 ? 00357B0F1 ? 000000001 ? 000000000 ? ltmdrv()+86 call ltmdvp() 00C4A51E0 ? 00C4A5230 ? 00357B0F1 ? 000000000 ? 000000001 ? 000000000 ? sltmdf()+11 call ltmdrv() 00C4A51E0 ? 000000000 ? 000000000 ? 000000000 ? 000000001 ? 000000000 ? sslsstehdlr()+329 call sltmdf() 00C4A51E0 ? 00C4A51E0 ? 000000000 ? 000000000 ? 000000001 ? 000000000 ? sslsshandler()+189 call sslsstehdlr() 00000000E ? 7FFF914C1DF0 ? 7FFF914C1CC0 ? 000000000 ? 000000001 ? 000000000 ? __restore_rt() call sslsshandler() 00000000E ? 7FFF914C1DF0 ? 7FFF914C1CC0 ? 000000000 ? 000000001 ? 000000000 ? open64()+16 signal __restore_rt() 7FFF914C22B0 ? 0000000C2 ? 0000001B0 ? FFFFFFFFFFFFFFFF ? 000000004 ? 000000000 ? [...]
# SQLNET.ORA:
[oracle@SERVER01 ~]$ cat $ORACLE_HOME/network/admin/sqlnet.ora SQLNET.EXPIRE_TIME = 1 NAMES.DIRECTORY_PATH=(tnsnames, ldap, ezconnect)