ODP.NET OraOps error

user10374756

Hi,

I have a .NET 4 solution that is generating a really strange error of not founding OraOpsXX.dll

Background:

The solution is .NET 4 using ODAC 11.2.0.3 (all x64) and connecting to a 11g DB

Server is Windows 2012 R2 with ODAC 11.2.0.3 installed

All the installations (and uninstall) have been made using the CMD (with Admin privilege)

install.bat odp.net4 c:\oracle odac true

install.bat asp.net4 c:\oracle odac false

uninstall.bat all odac (when uninstalling)

We upgraded the DB to 19c

I upgraded the ODAC to 18.3, changed the references in the solution, run the solution in local -> all OK. Connects fine and I can work with the DB

I then upgraded the server to 18.3 and then loaded the new solution -> error saying cannot find OraOps18.dll

made the same with 12.2.0.1.0. Works on dev machine localhost, the server triggers error saying cannot find OraOps12.dll

I then installed 11.2.0.4 (not the original 11.2.0.3) and everything works both on local dev machine and server and I'm able to connect to the 19c DB.

Everything is x64 (I've read this could cause the error).

Any hints?

Thanks

Andrea

user10374756

HI Alex,

thanks for the kind support. I opened the topic after struggling for two weeks on this.

Finally I think I made it :)

I used Microsoft Process Monitor to dig through the error and discovered that the application server was trying to load a c++ 2013 dll which was not installed on the server. This dll was instead on the Dev machine because installed by the dev environment.

Was really tricky ..

Hope it helps other users.

Thanks!

Andrea

Alex Keh-Oracle

Unmanaged ODP.NET uses unmanaged DLLs. The error means that ODP.NET can't find the right version of its unmanaged DLLs beginning with the OraOpsX.dll.

To ensure each ODP.NET deployment can find its correct version of Oracle Client, use the DllPath setting in ODP.NET. There's a number of places you can set DllPath with the local locations used first ahead of more global options. More info here: https://docs.oracle.com/en/database/oracle/oracle-data-access-components/19.3.2/odpnt/InstallODP.html#GUID-5487F4DD-69BB-4FF2-9FD6-5512EDA14F31

user10374756

HI Alex,

thanks for the kind support. I opened the topic after struggling for two weeks on this.

Finally I think I made it :)

I used Microsoft Process Monitor to dig through the error and discovered that the application server was trying to load a c++ 2013 dll which was not installed on the server. This dll was instead on the Dev machine because installed by the dev environment.

Was really tricky ..

Hope it helps other users.

Thanks!

Andrea