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 184.108.40.206 to 220.127.116.11 [Release 12.2]
Oracle Data Provider for .NET - Version 18.104.22.168 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:
- Set SQLNET.RECV_TIMEOUT to 60 in sqlnet.ora in advance
- Open connection from ODP.NET
- Sleep 70 seconds
- Issue a database activity such as SQL
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