blocks|key|320328|text|我将从我刚刚在Windows+Server2008+R2上经历的64位操作系统上给出答案。我得到的库的应用程序套件是使用Oracle3.5DLL库和较旧的.net库开发的，我被困住了，因为我安装了来自oracle的较新的x64客户端。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|320329|我发现的结果如下:安装Oracle+for+Windows+Server2008的最新x64客户端。我相信这应该是2.7.0客户端。当您选择安装时，请确保执行自定义并选择.NET库。配置您的tnsnames文件，并根据您的数据源测试您的tnsping。|320330|接下来，如果您运行的是32位应用程序，请为32位安装相同版本的客户端。此外，请遵循相同的安装例程，并选择相同的主目录。|320331|完成后，您将发现您有一个具有两个客户端目录(Client1和Client2)的应用程序/产品。|320332|如果您导航到windows/assemblies目录，您会发现您有一个对Oracle.DataAccess.dll+(x2)的引用，一个用于x86，一个用于AMD64。|320333|现在，取决于你是有开发人员还是自己在机器上开发，你在这里可能是可以的，但是，如果他们使用的是旧的驱动程序，那么你需要执行最后一步。|320334|导航到app\name\product\version\client_1\odp.net\publisher+policy\2.x目录。此处包含两个策略文件。使用gacutil+/i将Policy.2.111.Oracle.DataAccess.dll安装到GAC中。这会将遗留oracle+ODP调用重定向到较新的版本。因此，如果有人使用10g客户端进行开发，它现在将与11客户端一起工作。|320335|仅供参考-某些用户可能正在安装带有2.111.7.20的最新ODP.NET。主oracle客户端本身附带2.111.7.0.我使用7.20没有任何成功，但7.0客户端没有任何问题。|320336|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

I'm going to give you the answers from what I've just went through on Windows Server 2008 R2 which is a 64 bit operating system. The application suite of libraries I was given were developed using .net 3.5 x86 with the older DLL libraries and I was stuck because I had installed the newer x64 clients from oracle.

What I found was the following:
Install the latest x64 client from Oracle for Windows Server 2008. I believe this would be the 2.7.0 client. When you select the installation, make sure you do custom and select the .NET libraries.
Configure your tnsnames files and test your tnsping against your data source.

Next, if you are running a 32 bit application, install the same version of the client for 32 bit. Also, follow the same installation routine, and select the same home.

When your finished, you will find that you have a single app/product with two client directories (Client1 and Client2).

If you navigate to the windows/assemblies directory you will find that you have a reference to the Oracle.DataAccess.dll (x2) with one for x86 and one for AMD64.

Now, depending on if you have developers or are developing on the machine yourself, you may be ok here, however, if they are using older drivers, then you need to perform one last step.

Navigate to the app\name\product\version\client_1\odp.net\publisher policy\2.x directory. Included in here are two policy files. use gacutil /i to install the Policy.2.111.Oracle.DataAccess.dll into the GAC. This will redirect legacy oracle ODP calls to the newer versions. So, if someone developed with the 10g client, it will now work with the 11 client.

FYI -- Some may be installing the latest ODP.NET with the 2.111.7.20. The main oracle client itself comes with 2.111.7.0 .. I've not had any success with the 7.20 but have no issues with the 7.0 client.

blocks|key|3072912|text|我是用x64编译的，用x86就可以解决问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3072913|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I was compiling in x64, just use x86 and it will solve the problem

blocks|key|322804|text|正如在第一个答案中提到的，有32/64位的场景为开发人员引入了构建和运行时陷阱。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|322805|解决方案总是尝试正确的：你安装了什么样的软件和操作系统，。|offset|length|style|BOLD|322806|有关Oracle驱动程序和解决方案的一小部分场景列表，您可以访问此post。|322807|entityMap|0|LINK|mutability|MUTABLE|url|http://rambletech.wordpress.com/2011/09/26/could-not-load-file-or-assembly-oracle-dataaccess-error/^0|0|C|G|0|X|4|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

As referred to in the first answer, there are 32/64 bit scenarios which introduce build and runtime pitfalls for developers.

The solution is always to try to get right: What kind of software and OS you have installed.

For a small list of scenarios with the Oracle driver and the solution, you can visit this <a href="http://rambletech.wordpress.com/2011/09/26/could-not-load-file-or-assembly-oracle-dataaccess-error/" rel="nofollow noreferrer">post</a>.

blocks|key|322813|text|在您的.net项目中，转到reference部分，右键单击Oracle.DataAccess+dll，转到属性。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|322814|将设置更改为"Specific+Version=False“。现在就不会有版本冲突了|offset|length|style|CODE|322815|entityMap^0|0|7|M|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

in your .net project go to reference section, right click on Oracle.DataAccess dll, goto properties.

Change the setting to "<code>Specific Version=False</code>". Now it will be no version conflict

blocks|key|320371|text|我也有同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|320372|解决方案是将我当前解决方案的平台更改为x64。|320373|要在Visual+Studio中执行此操作，请右键单击solution+>+Configuration+Manager+>+Active+Solution+Platform。|320374|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I had the same issue. 

Solution was to change the platform of my current solution to x64. 

To do that in Visual Studio, right click solution > Configuration Manager > Active Solution Platform.

blocks|key|322842|text|我从甲骨文切换到托管ODP.NET程序集。我还必须清除使用旧程序集的IIS+web应用程序中的所有文件。现在，当我在IIS+Express和IIS中进行调试时，我没有得到关于32位和64位版本的任何冲突。请参阅下面的文章。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|322843|An+Easy+Drive+to+.NET|offset|length|322844|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technetwork/issue-archive/2014/14-mar/o24odp-2147205.html^0|0|0|L|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I switched over to the managed ODP.NET assemblies from Oracle. I also had to purge all the files from the IIS web apps that were using the older assemblies. Now I don't get any conflicts regarding 32 vs 64 bit versions when I debug in IIS Express vs IIS. See the following article.

<a href="http://www.oracle.com/technetwork/issue-archive/2014/14-mar/o24odp-2147205.html" rel="nofollow">An Easy Drive to .NET</a>

blocks|key|3286538|text|在我的例子中，错误说明程序集|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3286539|Oracle.DataAccess,+Version=2.112.3.0,+Culture=neutral,+PublicKeyToken=89b483f429c47342|code-block|syntax|javascript|3286540|都不见了。|3286541|当我运行gacutil.exe+/l+'Oracle.DataAccess'时，结果是：|offset|length|style|CODE|3286542|The+Global+Assembly+Cache+contains+the+following+assemblies:
Oracle.DataAccess,+Version=2.112.1.0,+Culture=neutral,+PublicKeyToken=89b483f429c47342,+processorArchitecture=x86

Number+of+items+=+1|3286543|此时，我刚刚安装了oracle客户端：win32_11gR2_client|3286544|然后，我安装了oracle+developer+tools+ODTwithODAC112030_deleloper_tool。|3286545|现在gacutil说：|3286546|The+Global+Assembly+Cache+contains+the+following+assemblies:
Oracle.DataAccess,+Version=2.112.1.0,+Culture=neutral,+PublicKeyToken=89b483f429c47342,+processorArchitecture=x86
Oracle.DataAccess,+Version=2.112.3.0,+Culture=neutral,+PublicKeyToken=89b483f429c47342,+processorArchitecture=x86

Number+of+items+=+2|3286547|修复了一个完全缺失的装配箱|3286548|entityMap^0|0|0|0|4|Y|0|0|J|I|0|U|W|0|2|7|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|15|8|@$K|16|L|17|M|N]]|9|@]|A|$]]|$1|O|3|P|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|19|8|@$K|1A|L|1B|M|N]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1C|8|@$K|1D|L|1E|M|N]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1F|8|@$K|1G|L|1H|M|N]]|9|@]|A|$]]|$1|W|3|X|5|D|7|1I|8|@]|9|@]|A|$E|F]]|$1|Y|3|Z|5|6|7|1J|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|11|$]]

In my case the error states that the assemly 

<pre><code>Oracle.DataAccess, Version=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342
</code></pre>

is missing.

When I run <code>gacutil.exe /l 'Oracle.DataAccess'</code> the result was:

<pre><code>The Global Assembly Cache contains the following assemblies:
Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=x86

Number of items = 1
</code></pre>

At this moment I have just installed the oracle client: <code>win32_11gR2_client</code>

Then I installed oracle developer tools <code>ODTwithODAC112030_deleloper_tool</code>

Now <code>gacutil</code> is saying:

<pre><code>The Global Assembly Cache contains the following assemblies:
Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=x86
Oracle.DataAccess, Version=2.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=x86

Number of items = 2
</code></pre>

Fixed, one totally missing assembly case

blocks|key|322293|text|解决方案非常简单，这完全取决于您如何在服务器/工作站上定义与您的visual+studio项目相关的内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|322294|首先检查您正在使用的Oracle库的版本，在本例中为2.111.7.20。接下来，转到位于Windows主页->程序集文件夹中的windows+GAC。|322295|向下滚动到Oracle+dll，它通常称为Oracle.DataAccess或Oracle.Web。找到它的正确版本，并记下它是否显示为x86或AMD64。|322296|在visual+studio中，确保目标平台与GAC中的dll相同，因此，如果GAC文件夹中的dll显示为x86，请确保目标平台为x64和其他x64。您可以在Visual+Studio项目属性中的build/platform目标下设置此设置。|322297|还要确保项目中“引用”下的引用指向开发计算机上的此完全相同的版本。|322298|有了这个，一切都应该工作得很好。|322299|我通常做的是首先检查服务器，因为在企业环境中更改本地依赖项的版本通常更容易，然后要求服务器管理员安装不同的dll。|322300|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

The solution is quite simple, it is all a matter of how you define things on the server / workstation in relation to your visual studio project.

First check the version of the Oracle library that you are using, in your case 2.111.7.20. Next go to the Windows GAC located in your windows home->assembly folder.

Scroll down to the Oracle dll, it is normally called Oracle.DataAccess or Oracle.Web. Find the right version of it and note down if it says x86 or AMD64.

In visual studio ensure that your target platform is the same as the dll in the GAC, so if it says x86 in the GAC folder ensure that the target platform is x64 and other x64. You can set this in Visual Studio project properties, under build/platform target.

Also ensure that your reference, under references in your project points to this exact same version on your development computer.

With this everything should work fine.

What I normally do is to check the server first as it is often easier in an enterprise environment to change the version of your local dependencies, then to ask a server administrator to do an installation of a different dll.

blocks|key|322905|text|尝试以下操作:在Visual+Studio中，转到工具/选项...项目和Solutions...Web项目...确保已选中64位版本的IIS+Express复选框。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|322906|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Try the following: In Visual Studio, go to Tools/Options....Projects and Solutions...Web Projects... Make sure that 64 bit version of IIS Express checkbox is checked off.

blocks|key|3286637|text|我遇到同样的问题有几天了，然后我发现这个Oracle.DataAccess在项目的references列表中是可用的，但在bin文件夹中却不见了。因此，我将其从引用列表中删除并重新读取。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3286638|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I was facing the same issue for a couple of days then I figure out that the Oracle.DataAccess is available in the references list of the project, but in the bin folder is missing. So I removed it from the references list and readded again.

blocks|key|3073203|text|请向广交会注册您的Oracle.DataAccess|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3073204|raProvCfg.exe+/action:gac+/providerpath:C:\oracle\product\11.2.0\x32\ODP.NET\bin\4\Oracle.DataAccess.dll

OraProvCfg.exe+/action:gac+/providerpath:C:\oracle\product\11.2.0\x64\ODP.NET\bin\4\Oracle.DataAccess.dll|code-block|syntax|javascript|3073205|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

please register your Oracle.DataAccess to GAC 

<pre><code>raProvCfg.exe /action:gac /providerpath:C:\oracle\product\11.2.0\x32\ODP.NET\bin\4\Oracle.DataAccess.dll

OraProvCfg.exe /action:gac /providerpath:C:\oracle\product\11.2.0\x64\ODP.NET\bin\4\Oracle.DataAccess.dll
</code></pre>

blocks|key|3286661|text|您可以按照以下步骤操作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3286662|https://docs.oracle.com/health-sciences/inform-62/install/index.htm?toc.htm?214691.htm|offset|length|3286663|注册Oracle.DataAccess.dll程序集必须将Oracle.DataAccess.dll程序集注册到.NET版本2和版本4的全局程序集缓存中：|3286664|以Administrator.身份打开命令提示符|3286665|ordered-list-item|3286666|3286667|导航到%25ORACLE_CLIENT_HOME%25\ODP.NET\bin\2.x.的|3286668|3286669|3286670|执行以下命令：：oraprovcfg.exe/action:gac/providerpath:Oracle.DataAccess.dll+|style|CODE|3286671|3286672|3286673|导航到%25ORACLE_CLIENT_HOME%25\ODP.NET\bin\4.x.的|3286674|3286675|3286676|执行以下命令：oraprovcfg.exe/action:gac/providerpath:Oracle.DataAccess.dll+|3286677|3286678|3286679|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2E|0|0|0|0|0|0|0|0|0|8|1O|0|0|0|0|0|0|7|1O|0|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1C|8|@]|9|@$D|1D|E|1E|1|1F]]|A|$]]|$1|F|3|G|5|6|7|1G|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1H|8|@]|9|@]|A|$]]|$1|J|3|-4|5|K|7|1I|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1K|8|@]|9|@]|A|$]]|$1|O|3|-4|5|K|7|1L|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1N|8|@$D|1O|E|1P|S|T]]|9|@]|A|$]]|$1|U|3|-4|5|K|7|1Q|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1S|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|K|7|1T|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1V|8|@$D|1W|E|1X|S|T]]|9|@]|A|$]]|$1|12|3|-4|5|K|7|1Y|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|20|8|@]|9|@]|A|$]]]|15|$16|$5|17|18|19|A|$1A|C]]]]

you can follow this
<a href="https://docs.oracle.com/health-sciences/inform-62/install/index.htm?toc.htm?214691.htm" rel="nofollow noreferrer">https://docs.oracle.com/health-sciences/inform-62/install/index.htm?toc.htm?214691.htm</a>
Register the Oracle.DataAccess.dll assembly
You must register the Oracle.DataAccess.dll assembly to the Global Assembly Cache (GAC) for .NET version 2 and version 4:
<ol>
<li>Open a command prompt as an Administrator.
</li>
<li>Navigate to %ORACLE_CLIENT_HOME%\ODP.NET\bin\2.x.
</li>
<li>Execute the following command:: <code>oraprovcfg.exe/action:gac/providerpath:Oracle.DataAccess.dll</code>
</li>
<li>Navigate to %ORACLE_CLIENT_HOME%\ODP.NET\bin\4.x.
</li>
<li>Execute the following command: <code>oraprovcfg.exe/action:gac/providerpath:Oracle.DataAccess.dll</code>
</li>
</ol>

When I try to run a simple program to access oracle I am getting this message

<blockquote>
 Could not load file or assembly 'Oracle.DataAccess,
 Version=2.111.7.20, Culture=neutral, PublicKeyToken=89b483f429c47342'
 or one of its dependencies. The system cannot find the file specified.
</blockquote>

I checked \windows\assembly and it's in there, but it's not in GAC (<code>gacutil -l</code>). I can't add into GAC (<code>gacutil -i [path]</code>. I get 'unknown error'.

Anyone has the same experiencing?

Could not load file or assembly for Oracle.DataAccess in .NET

Windows Server

Visual Studio

服务器

Windows

当我尝试运行一个简单的程序来访问oracle时，我得到了以下消息无法加载文件或程序集“Oracle.DataAccess，Version=2.111.7.20，Culture=neutral，PublicKeyToken=89b483f429c47342”或其依赖项之一。系统找不到指定的文件。我检查了\windows\...

问无法在.NET中加载Oracle.DataAccess的文件或程序集
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法在.NET中加载Oracle.DataAccess的文件或程序集EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法在.NET中加载Oracle.DataAccess的文件或程序集
EN