Bequeath Connections Hang When SQLNET.OUTBOUND_CONNECT_TIMEOUT > 0 (Doc ID 946503.1)

Last updated on OCTOBER 08, 2009

Applies to:

Oracle Net Services - Version: 10.2.0.1 to 10.2.0.4
Microsoft Windows

Symptoms

Bequeath or local connections to the database hang when the SQLNET.ORA file has the parameter SQLNET.OUTBOUND_CONNECT_TIMEOUT set to a value greater than 0.

SQLNET.ORA

SQLNET.OUTBOUND_CONNECT_TIMEOUT = 3

SQL*Plus hangs showing banner:

C:\sqlplus scott/tiger

SQL*Plus: Release 10.2.0.4.0 Production on Fri Jun 12 17:58:06 2009
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connections using sysdba will also hang:

C:\sqlplus /nolog
SQL>connect sys as sysdba
Password: <your_pw>

No banner.  Just hangs indefinitely.


Oracle Net client trace ends showing following:

[12-JUN-2009 17:58:06:825] nsevwait: entry
[12-JUN-2009 17:58:06:825] nsevwait: 1 registered connection(s)
[12-JUN-2009 17:58:06:825] nsevwait: 0 pre-posted event(s)
[12-JUN-2009 17:58:06:825]nsevwait: waiting for transport event (0 thru 0)...

Connection handshake has not been started.

Changes

The sqlnet.ora file may  have been changed recently.  The following parameter added:

SQLNET.OUTBOUND_CONNECT_TIMEOUT=n

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