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 APRIL 17, 2023

Applies to:

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


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:



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


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.