My Oracle Support Banner

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: to
Microsoft Windows


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.



SQL*Plus hangs showing banner:

C:\sqlplus scott/tiger

SQL*Plus: Release 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.


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



To view full details, 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 a vibrant support community of peers and Oracle experts.