Extproc User Session Disconnects at SQLNET.INBOUND_CONNECT_TIMEOUT Value

(Doc ID 1356971.1)

Last updated on NOVEMBER 25, 2017

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:

Network error 1003: NCR-01003: NCRS: Read error
HS: RPC error reported on server, SendExecCallout: ncrowht_what; NCR code 1004

ORA-28579: network error during callback from external procedure agent


ORA-28576: lost RPC connection to external procedure agent
ORA-6512: at "SYS.SHELL", line 1
ORA-6512: at line 1

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 observable behavior that the user session will disconnect at the value of n.


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