ORA-3136/TNS-12535 or Hang Reported for Connections Across Firewall (Doc ID 974783.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Net Services - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Oracle Net Services - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 1-OCT-2014***
Oracle Net Connection cross firewalls


Symptoms

Remote connections that traverse a firewall report ORA-3136 WARNING inbound connection timed out or hang.
Oracle Net client trace shows the following:

[16-NOV-2009 07:35:59:859] ntt2err: soc 1780 error - operation=5, ntresnt[0]=517, ntresnt[1]=54, ntresnt[2]=0
[16-NOV-2009 07:35:59:859] ntt2err: exit
[16-NOV-2009 07:35:59:859] nttrd: exit
[16-NOV-2009 07:35:59:859] nsprecv: error exit
[16-NOV-2009 07:35:59:859] nserror: entry
[16-NOV-2009 07:35:59:859] 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
[16-NOV-2009 07:35:59:859] nsrdr: error exit
[16-NOV-2009 07:35:59:859] nsdo: nsctxrnk=0
[16-NOV-2009 07:35:59:859] nsdo: error exit
[16-NOV-2009 07:35:59:859] nioqrc: wanted 1 got 0, type 0
[16-NOV-2009 07:35:59:859] nioqper: error from nioqrc
[16-NOV-2009 07:35:59:875] nioqper: ns main err code: 12547
[16-NOV-2009 07:35:59:875] nioqper: ns (2) err code: 12560
[16-NOV-2009 07:35:59:875] nioqper: nt main err code: 517
[16-NOV-2009 07:35:59:875] nioqper: nt (2) err code: 54
[16-NOV-2009 07:35:59:875] nioqper: nt OS err code: 0
[16-NOV-2009 07:35:59:875] nioqer: entry
[16-NOV-2009 07:35:59:875] nioqer: incoming err = 12151
[16-NOV-2009 07:35:59:875] nioqce: entry
[16-NOV-2009 07:35:59:875] nioqce: exit
[16-NOV-2009 07:35:59:875] nioqer: returning err = 3135


And for the hang, Oracle Net Client trace shows following after handshake

[24-SEP-2009 08:31:30:812] nsprecv: reading from transport...
[24-SEP-2009 08:31:30:812] nttrd: entry

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