Slow Connections for 11.2 Client from Windows 7 (Doc ID 1297073.1)

Last updated on OCTOBER 30, 2016

Applies to:

Oracle Net Services - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Connections from Windows 7 clients are very slow, taking 20 to 30 seconds to connect.
TNSping is also reporting very high value for round trip time

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 31-JAN-2011 12:37:51

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
c:\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = NodeA) (PORT = 1521))) (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED)))
OK (21240 msec)


Oracle Net level 16 client trace of connection, shows the time is lost on using the socket 2500, with ntt2err: soc 2500 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0

(4808) [31-JAN-2011 13:14:12:704] ntctst: size of NTTEST list is 1 - not calling poll
(4808) [31-JAN-2011 13:14:12:704] sntseltst: Testing for WRITE on socket 2500
(4808) [31-JAN-2011 13:14:33:733] sntseltst: FOUND: write request on socket 2500
(4808) [31-JAN-2011 13:14:33:733] ntt2err: entry
(4808) [31-JAN-2011 13:14:33:733] ntt2err: soc 2500 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
(4808) [31-JAN-2011 13:14:33:733] ntt2err: exit
(4808) [31-JAN-2011 13:14:33:843] nttcni: exit
(4808) [31-JAN-2011 13:14:33:843] nttcon: exit
(4808) [31-JAN-2011 13:14:33:843] nserror: entry
(4808) [31-JAN-2011 13:14:33:843] nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0


This time gap is seen before the connection handshake is started.

Changes

New installation on Windows 7

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