Shared Server Process Hangs while Executing Remote Query with INBOUND_CONNECT_TIMEOUT Parameter Enabled
Last updated on SEPTEMBER 10, 2010
Applies to:Oracle Server - Enterprise Edition - Version: 184.108.40.206 to 10.1.0.5 - Release: 9.2 to 10.1
Information in this document applies to any platform.
The problem documented here is limited to databases where shared server is configured. It is also limited in scope to versions 9.2.0.x and early releases of 10gR1.
The session is connected to the local database using a Shared Server process.
The hang does not occur if the session is connected to a Dedicated server.
The parameter SQLNET.INBOUND_CONNECT_TIMEOUT has been set at the server side sqlnet.ora file.
The problem does not occur when this parameter is NOT present.
The hang occurs for remote SQL that runs for longer than the timeout value.
The remote session is dropped when the timeout is exceeded.
The local session remains waiting for ever on 'virtual circuit status.
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