Shared Server Process Hangs while Executing Remote Query with INBOUND_CONNECT_TIMEOUT Parameter Enabled (Doc ID 396196.1)

Last updated on SEPTEMBER 10, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 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.

Symptoms

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.

Changes

The problem would occur after Shared server was configured OR enabling the SQLNET.INBOUND_CONNECT_TIMEOUT parameter to the server side sqlnet.ora file.

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