重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 105|回复: 0

ORA-12608 TNS: odp.net

[复制链接]
发表于 2022-8-2 10:14:43 | 显示全部楼层 |阅读模式
本帖最后由 郑全 于 2022-9-29 09:35 编辑

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

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2022-10-2 00:57 , Processed in 0.095775 second(s), 20 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表