ORA-12608 TNS: odp.net

郑全

Net Application Getting ORA-12608: TNS: Send timeout occurred With Unmanaged ODP.NET Provider (Doc ID 2773511.1)        

In this Document
Symptoms
Changes
Cause
Solution
References

APPLIES TO:
Oracle Data Provider for .NET - Version 19.1.0.0.0 and later
Information in this document applies to any platform.
SYMPTOMS
.Net Application using Unmanaged ODP.NET Provider and has a setting SQLNET.SEND_TIMEOUT in client side sqlnet.ora.
Then application started receiving TNS: Send timeout errors after migrated to 19c version ODP.NET provider.


Below error stack trace can be observed in odp.net traces.

Unhandled Exception: Oracle.DataAccess.Client.OracleException: ORA-12608: TNS: Send timeout occurred
  at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)
  at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck, OracleLogicalTransaction m_OracleLogicalTransaction)
  at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
  at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()



CHANGES
Application change to use ODP.NET version from 12.2 to 19.3.

CAUSE
The issue reported by the Bug 30926173 - ORA-12608: TNS: SEND TIMEOUT OCCURRED WITH ODPU 19C


SOLUTION
Issue was fixed in 21.1 version. However, the fix can be back-porting feasible only to 19 and above. To get back-port patch fix raise request to Oracle support.

Otherwise as a workaround either remove or set SQLNET.SEND_TIMEOUT to zero in 19c client sqlnet.ora.

ex: SQLNET.SEND_TIMEOUT=0