Oracle 客户端和 ODP.NET 版本兼容性 [英] Oracle Client and ODP.NET version compatibility
问题描述
我们已将 Oracle 升级到 19C，还将 Oracle.ManagedDataAccess 包升级到 19.6.但是，当我们尝试在 Oracle 数据库 12 上打开我们的应用程序时，它显示错误，因为某些机器仍然具有 Oracle 12(旧)数据库.有人可以与 Oracle 客户端分享 Oracle 数据提供程序 (ODP.Net) 兼容性详细信息吗?
We have upgraded Oracle to 19C and also upgraded the Oracle.ManagedDataAccess package to 19.6. However, when we try to open our application on Oracle database 12 then it is showing error, as some machines still has Oracle 12 (Old) database. can someone please share the Oracle Data Provider (ODP.Net) compatibility details with Oracle Clients?
推荐答案
该错误消息并不表示任何不兼容.看起来 Oracle.ManagedDataAccess 驱动程序没有找到您的 tnsnames.ora 文件
The error message does not indicate any incompatibility. Looks like the Oracle.ManagedDataAccess driver does not find your tnsnames.ora file
看看适用于 .NET 的 Oracle 数据提供程序，托管驱动程序配置
您是否定义了
TNS_ADMIN环境变量?
您是否在注册表中的 HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\OraClient19Home1 和注册表中定义了 TNS_ADMIN ?HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Oracle\OraClient19Home1_32bit?
Did you define TNS_ADMIN in your Registry at HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\OraClient19Home1 resp. HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Oracle\OraClient19Home1_32bit?
文档指出未读取注册表，但对于版本 19 我不确定
Documentation states that Registry is not read but for verion 19 I am not sure about that
您是否在 .NET 配置文件中定义了 TNS_ADMIN?
Did you define the TNS_ADMIN in .NET config file?
设置它的最简单方法是 OraProvCfg.exe 工具.与此类似:
The easiest way to set it there would be the OraProvCfg.exe tool. Would be similar to this:
对于 64 位:
c:\oracle\product\12.1\Client_x64\ODP.NET\bin\4\OraProvCfg.exe /action:config /product:odpm /frameworkversion:v4.0.30319 /providerpath:C:\oracle\product\12.1\Client_x64\odp.net\managed\common\Oracle.ManagedDataAccess.dll /set:settings\TNS_ADMIN:C:\oracle\network\admin
对于 32 位:
c:\oracle\product\12.1\Client_x86\ODP.NET\bin\4\OraProvCfg.exe /action:config /product:odpm /frameworkversion:v4.0.30319 /providerpath:C:\oracle\product\12.1\Client_x86\odp.net\managed\common\Oracle.ManagedDataAccess.dll /set:settings\TNS_ADMIN:C:\oracle\network\admin
这篇关于Oracle 客户端和 ODP.NET 版本兼容性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
