Intermittent Connection Failure Reporting ORA-3113 / ORA-12170 (Doc ID 1154143.1)

Last updated on JUNE 11, 2016

Applies to:

Oracle Net Services - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 12-JUL-2013***


Symptoms

Intermittent connection failure for all clients and application, reporting :

ORA-03114 not connected to ORACLE when connection is established
ORA-12170 TNS:Connect timeout occurred when making a new connection

Oracle Net client trace of the failure shows the following errors after delay on nttrd (basic tcpip read)

(976) [000002 07-JUL-2010 08:41:08:752] nttrd: entry
(976) [000002 07-JUL-2010 08:41:27:628] ntt2err: entry
(976) [000002 07-JUL-2010 08:41:27:628] ntt2err: soc 984 error - operation=5, ntresnt[0]=517, ntresnt[1]=54, ntresnt[2]=0
(976) [000002 07-JUL-2010 08:41:27:628] ntt2err: exit
(976) [000002 07-JUL-2010 08:41:27:628] nttrd: exit
(976) [000002 07-JUL-2010 08:41:27:628] nsprecv: error exit
(976) [000002 07-JUL-2010 08:41:27:628] nserror: entry
(976) [000002 07-JUL-2010 08:41:27:628] nserror: nsres: id=0, op=68, ns=12547, ns2=12560; nt[0]=517, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
(976) [000002 07-JUL-2010 08:41:27:628] nsrdr: error exit
(976) [000002 07-JUL-2010 08:41:27:628] snsbitts_ts: entry
(976) [000002 07-JUL-2010 08:41:27:628] snsbitts_ts: acquired the bit
(976) [000002 07-JUL-2010 08:41:27:628] snsbitts_ts: normal exit
(976) [000002 07-JUL-2010 08:41:27:628] snsbitcl_ts: entry
(976) [000002 07-JUL-2010 08:41:27:628] snsbitcl_ts: normal exit
(976) [000002 07-JUL-2010 08:41:27:628] snsbitts_ts: entry
(976) [000002 07-JUL-2010 08:41:27:628] snsbitts_ts: acquired the bit
(976) [000002 07-JUL-2010 08:41:27:628] snsbitts_ts: normal exit
(976) [000002 07-JUL-2010 08:41:27:628] nsdo: nsctxrnk=0
(976) [000002 07-JUL-2010 08:41:27:628] snsbitcl_ts: entry
(976) [000002 07-JUL-2010 08:41:27:628] snsbitcl_ts: normal exit
(976) [000002 07-JUL-2010 08:41:27:628] nsdo: error exit
(976) [000002 07-JUL-2010 08:41:27:628] nioqrc: wanted 1 got 0, type 0
(976) [000002 07-JUL-2010 08:41:27:628] nioqper: error from nioqrc
(976) [000002 07-JUL-2010 08:41:27:628] nioqper: ns main err code: 12547
(976) [000002 07-JUL-2010 08:41:27:628] nioqper: ns (2) err code: 12560
(976) [000002 07-JUL-2010 08:41:27:628] nioqper: nt main err code: 517
(976) [000002 07-JUL-2010 08:41:27:628] nioqper: nt (2) err code: 54
(976) [000002 07-JUL-2010 08:41:27:628] nioqper: nt OS err code: 0
(976) [000002 07-JUL-2010 08:41:27:628] nioqer: entry
(976) [000002 07-JUL-2010 08:41:27:628] nioqer: incoming err = 12151

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