Sqlnet connection via TCP Hangs for about 10seconds Before Connection is Established (Doc ID 1071330.1)

Last updated on MARCH 30, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.1.0 - Release: 10.1 to 11.2
Information in this document applies to any platform.

Symptoms

10 nodes RAC cluster, sqlnet connection via TCP consistently takes 10 seconds before the connection with the server is finally established.

$date;sqlplus apps/xxx@dwnodea @time.sql
Tue Feb  2 17:00:39 CST 2010

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Feb  2 17:00:39 2010

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Real Application Testing options

TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI:SS')
------------------------------------------------------------------------------------------------------------------------
2010-02-02 17:00:49

Sqlnet tracing (both server and client) against sqlplus connection with level 16 shows:

Server side trace:
2010-02-02 17:00:39.432277 : nttcnp:exit
2010-02-02 17:00:39.432308 : snlinGetAddrInfo:entry

*** 2010-02-02 17:00:49.440
2010-02-02 17:00:49.440655 : snlinGetAddrInfo:getaddrinfo() failed with error -2
2010-02-02 17:00:49.440736 : snlinGetAddrInfo:exit
2010-02-02 17:00:49.440751 : nttcon:exit
2010-02-02 17:00:49.440767 : nsopen:transport is open
2010-02-02 17:00:49.440785 : nsoptions:entry
2010-02-02 17:00:49.440802 : nsoptions:lcl[0]=0x0, lcl[1]=0x0, gbl[0]=0x0, gbl[1]=0x0, cha=0x0


Client side trace:
2010-02-02 17:00:39.418598 : nscon:recving a packet
2010-02-02 17:00:39.418714 : nsprecv:entry
2010-02-02 17:00:39.418833 : nsprecv:reading from transport...
2010-02-02 17:00:39.418949 : nttrd:entry
2010-02-02 17:00:49.444643 : nttrd:socket 12 had bytes read=8

2010-02-02 17:00:49.444832 : nttrd:exit


Changes

This is a new installation.

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