Last updated on OCTOBER 08, 2009
Applies to:Oracle Net Services - Version: 10.2.0.1 to 10.2.0.4
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.OUTBOUND_CONNECT_TIMEOUT = 3
SQL*Plus hangs showing banner:
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:
SQL>connect sys as sysdba
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms