My Oracle Support Banner

Extproc User Session Disconnects at SQLNET.INBOUND_CONNECT_TIMEOUT Value (Doc ID 1356971.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Net Services - Version to [Release 10.2 to 12.1]
PL/SQL - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.
This issue occurs in environments where external procedure calls or extproc is running and the sqlnet.ora file contains a non-zero


11g Specific Symptoms
Using legacy configuration for external procedure calls  and a non-zero setting for SQLNET.INBOUND_CONNECT_TIMEOUT in the same environment , you may experience the following errors when the user session is idle for the value of the timeout:

10gR2 Specific Symptoms
Using typical configuration for external procedure calls and running a procedure at intervals that exceed the value for SQLNET.INBOUND_CONNECT_TIMEOUT and the procedure will crash intermittently with ORA-28576 error. 


The following parameter may have been added recently to the sqlnet.ora file in the extproc environment:

SQLNET.INBOUND_CONNECT_TIMEOUT=n  Where n is a non-zero value.

It is reproducible behavior that the user session will disconnect at the value of n.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.