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 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:
- 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
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 |