ODP.NET - deployment without installing ORACLE CLIENT - large size oraociei11.dll

Question

I am using ODP.NET in my WPF application to access Oracle 10g db. I don’t want the instacle oracle client on users computers, so I copied these dlls to the real folder:

• oci.dll
• ocijdbc11.dll
• OCIW32.DLL
• Oracle.DataAccess.dll
• orannzsbb11.dll
• orasql11.dll

• OraOps11w.dll

• oraocci11.dll - 706 KB

• oraociei11.dll - 126.55 KB

I think the last two dlls oraocci11.dll and oraociei11.dll have the same functionality, but oraociei11.dll is really big.

I would like to remove oraociei11.dll from my project. I did this, but the application crashes if I do not have the oraociei11.dll file in the realease folder.

Maybe I'm wrong and they don’t have the same functionality

You can remove this DLL.

Answer 1

AFAIK.ll dll is just a kind of wrapper around the native DLL, and you note what is required for distribution. Thus, there is no other way to distribute your application with all the megabytes of your own DLLs.

Moreover, there are licensing restrictions on the distribution of these dlls. I am pretty sure that Oracle client libraries do not have the right to redistribute in any other way than deploying the entire installer package (which, unfortunately, is quite large and quite complicated to configure) and runs it on the client.