SQL*Plus Connection Slow and May Yield ORA-03135: Connection Lost Contact (Doc ID 1639354.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Net Services - Version 11.2.0.3 and later
IBM AIX on POWER Systems (64-bit)
The problem documented here arose after a change to DNS. It describes a performance issue limited to connect time and does not address any other kinds of performance problems.

Symptoms

The following issue arose on an AIX server running 11gR2.

Following a change to the DNS configuration on this Unix host, the client can no longer establish a connection via the listener.  Additionally, connections that are attempted using the local or  BEQUEATH protocol are considerably slower.   

Here are the tests conducted and a description of the results:

1. Connect to the local instance via the BEQ protocol (without listener).
   
$ set ORACLE_SID=mysid
$ sqlplus / as sysdba 

Very slow to establish a connection but eventually successful


2. Attempt to connect to the local instance via the TCP listener and it will fail:

$ sqlplus myuser@TNS_Alias
password:


SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 26 14:24:46 2014

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

ERROR:
ORA-03135: connection lost contact<=====Fails to connect with 'lost contact'
Process ID: 0
Session ID: 0 Serial number: 0

3. Oracle*Net Trace reveals the following:

 

 

4.   Nslookup run against the server's hostname yielded the correct results.

5.   Ifconfig -a command shows IPv6 was set on loopback interface lo0:

$ ifconfig -a
en0: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
        inet 10.11.12.13 netmask 0xffffff00 broadcast 10.11.12.255
         tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
        inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255

         inet6 ::1%1/0    <<===== Note the loopback interface configured with IPv6
 

Changes

The customer recently changed the DNS settings in /etc/netsvc.conf to:


hosts=local,bind


This change would enable both IPv4 and IPv6 DNS searches. 

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