How to resolve the error: Unable to load DLL 'OraOps12.DLL': The specified module could not be found

Question

User237591224 posted

I am getting the error I reference above, Unable to load DLL 'OraOps12.DLL': The specified module could not be found. I have a Visual Studio 2017 project. I have Oracle 11 client installed. The project could get ot the oracle db. I installed Oracle 12 client but encountered some problems. I took 12 out and reinstalled 11. I updated my reference in VS to the correct dll. But I still get this error. I've looked through my Visual Studio but I cannot see where it's trying to reference OraOps12.DLL. Is there any where else I could be looking to try and fix that reference?

Answer 1

User283571144 posted

Hi tbowen01,

According to your description, I suggest you could firstly make sure you have install the right Oracle client.

http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

If reinstall the package doesn't solve your issue.

I suggest you could locate the instantclient_12_1 folder to find the below dll (or you could copy all the dll into bin folder).

oci.dll
ociw32.dll
orannzsbb12.dll
oraociei12.dll
oraons.dll

Locate in the odp.net4 or odp.net20 folder depending on your .NET version this two dlls:

OraOps12.dll
Oracle.DataAccess.dll

Then you could copy the those 32bit dlls or 64bit dlls and put them directly in the Output path of your project.  

At last, you could set the reference copy to local setting to true.

More details, you could refer to below answer.

https://stackoverflow.com/a/33527025/7609093 

Best Regards,

Brando

Answer 2

User237591224 posted

I've uninstalled and re-installed and I'm still getting problems. I also followed the steps with the .dlls. I got it repaired in my development environment and it's using odac12 now. But on my server that I deploy web apps too I still get the oracle error. I've done the uninstall and reinstall there, to. What is the best way to remove ODAC12? I do not see any deinstall option. If I remove it, I want to get it completely removed, including any registry or GAC issues. Thanks.

Answer 3

User283571144 posted

Hi tbowen01,

What is the best way to remove ODAC12? I do not see any deinstall option. If I remove it, I want to get it completely removed, including any registry or GAC issues. Thanks.

According to your description, I suggest you could follow below article to uninstall the ODAC client.

https://docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm#CIHCHHEH

Best Regards,

Brando