ORA-7445 With Either Function: [NSTIMEXP] or [SNSTIMSANE] (Doc ID 282453.1)

Last updated on DECEMBER 10, 2016

Applies to:

Oracle Net Services - Version 8.1.7.4.0 to 11.2.0.3 [Release 8.1.7 to 11.2]
Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.3 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
This issue can occur in any version below 12.1 where DCD or SQLNET.EXPIRE_TIME is in place.


Symptoms

The following error messages are found in alert.log:

ORA-07445: exception encountered: core dump [nstimexp()+38] [SIGSEGV]
found dead dispatcher 'D001', pid = (12, 1)


The Dispatcher process core dumps and trace files are generated.

 

The following message might occur for dedicated connections:

ORA-07445: exception encountered: core dump [snstimsane()+43] [SIGSEGV]
[Address not mapped to object] [0x000000000] [] []
ORA-03135: connection lost contact



 

Changes

Dead Connection Detection (DCD) may have been recently enabled in this environment.  Check for the existence of the SQLNET.EXPIRE_TIME  parameter in the sqlnet.ora file that is local to the instance or in the listener's environment.

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