My Oracle Support Banner

ODP.NET 12.2 Unmanaged Driver Can Get ORA-12609 When Setting SQLNET.RECV_TIMEOUT (Doc ID 2524260.1)

Last updated on JANUARY 21, 2020

Applies to:

Oracle Net Services - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Data Provider for .NET - Version 12.1.0.2 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms

When setting SQLNET.RECV_TIMEOUT in client side 'sqlnet.ora', ODP.NET unmanaged driver can gets ORA-12609 (TNS: Receive timeout occurred) when issuing a SQL after passing more than seconds of timeout value of SQLNET.RECV_TIMEOUT in the idle state.
This problem can occur with only 12.2 version.
It doesn't occur either with lower than 12.1 version or with higher than 18.0 version.

Example steps to reproduce this issue:

  1. Set SQLNET.RECV_TIMEOUT to 60 in sqlnet.ora in advance
  2. Open connection from ODP.NET
  3. Sleep 70 seconds
  4. Issue a database activity such as SQL

Example Code:

 

Changes

Upgraded Oracle Client to 12.2 or newly installed Oracle Client 12.2. 

Cause

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
Symptoms
Changes
Cause
Solution
References


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