Upgrading Oracle 12.1 to 12.2 Oracle Dependency Error

Question

We recently tried to upgrade our C # applications with new Oracle dlls. We create our software for several platforms. Thus, our software solution is a winform desktop application and an ASP.NET MVC web application.

Both applications work fine with Oracle 12.1. We add all the necessary Oracle DLLs with the redistribution of our software. Thus, the desktop application has all the DLL files in MSI, and publishing a website has all the DLL files in ~ \ Bin. Making sure the web application is running when I host the website in IIS. Therefore, our customers do not need to install Oracle Client.

Now a problem arises, since upgrading to Oracle 12.2 prevents us from launching the web application anymore. The desktop application is still working fine, though, since Oracle 12.2 we get a firewall exception message if we want to allow our desktop application to connect to the Internet. We did not receive this message in Oracle 12.1 or lower.

We published our web application with all the new Oracle dll servers (the same DLL files as on the desktop, and the same as when using the Oracle 12.1 web application), and since then we can no longer connect to our Oracle databases. We get the error below:

Unable to load DLL 'OraOps12.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'OraOps12.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
   at Oracle.DataAccess.Client.OpsInit.CheckVersionCompatibility(String version)
   at Oracle.DataAccess.Client.OracleInit.Initialize()
   at Oracle.DataAccess.Client.OracleConnection..cctor()
   --- End of inner exception stack trace ---

We checked, but YES there is a DLL. We also place it in different places to find out if this will work, but not.

This is the dll we use:

, , ! DLL, -! DLL, , web-, - XCopy Oracle: http://download.oracle.com/otn/other/ole-oo4o/ODAC122010Xcopy_32bit.zip x86 http://download.oracle.com/otn/other/ole-oo4o/ODAC122010Xcopy_x64.zip x64

, :

• Oracle 12.2 .NET Framework 4.5.2, 4,6
• DLL IIS
• 32- , x86,
• , , DLL
• , : , true
• x86 x64 NOT anyCPU.
• Regedit, Machine.config GAC Oracle.
• xcopy zip
• DISABLED ()

Oracle.DataAccess.Client Dependencies !

:

• Windows Server 2012R2 DataCenter ()
• x64
• IIS 8.5

, , - .

Answer 1

Oracle Client.

, , .

• Oracle Client ( ODP.NET) , Oracle

• ODP.NET, . Oracle.ManagedDataAccess.dll .

, :

• DLL → , Oracle
• PATH. → , %ORACLE_HOME% %ORACLE_HOME%\bin
• GAC? gacutil.exe 4.0? 3.5 4.0 ( ).
• 32- 64- Oracle. , : BadImageFormatException. 64- 32- Oracle
• ODP.NET Oracle. (, 11.1, 11.2, 12.1, 12.2) .

Process Monitor, , DLL / .