Shared Server Process Hangs while Executing Remote Query with INBOUND_CONNECT_TIMEOUT Parameter Enabled
(Doc ID 396196.1)
Last updated on FEBRUARY 27, 2019
Applies to:Oracle Database - 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.
A session hangs forever while running a query over a database link.
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.
The problem would occur after Shared server was configured OR enabling the SQLNET.INBOUND_CONNECT_TIMEOUT parameter to the server side sqlnet.ora file.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document