What is the minimal setup required to deploy a .NET application with Oracle client 11?

Question

What is the minimal setup required to be able to deploy a .NET application that talks to an Oracle database?

Answer 1

1. Download the ODAC 11 XCopy deployment.

2. Extract the zip file and run the following:

   install.bat odp.net20 c:\oracle\11.1\odac myoraclehome true

3. Copy the files from the 11.1 directory and place them in a subdirectory of your application's executable (e.g. debug\bin\oracle)

4. Add the following statements to your Main() method. They will change the path such that your application executable will use the oracle client exclusive of any other oracle home's. The environment change is exclusive to your process and has no lasting effects when the application terminates:

   Environment.SetEnvironmentVariable("PATH", Environment.CurrentDirectory + "\oracle\11.1\odac;" + Environment.CurrentDirectory + "\oracle\11.1\odac\bin;", EnvironmentVariableTarget.Process); Environment.SetEnvironmentVariable("ORACLE_HOME", Environment.CurrentDirectory + "\oracle\11.1\odac", EnvironmentVariableTarget.Process);

Answer 2

Josh-

Thank you very much for taking the time to answer. Your instructions helped a whole lot, and are very close to what I have found on my own.

Interestingly enough, I found it can be slimmed a little more.

For those in my situation who 1. Do not want their users to have to install ODAC or the full-size Oracle Client 2. Do not care about the re-usability of the particular client installtion 3. Need a "clickOnce" compatible solution

I found a way to do that.

a. Download the "Oracle Instant Client 11.1.0.6 - Basic Lite". b. unzip to any folder and copy the following files to your Visual Studio project root:

• oci.dll
• ociw32.dll
• orannzsbb11.dll
• oraocci11.dll
• oraociicus.dll

• msvcr71.dll

  (the first five are the minimum needed for the Oracle Instant Client, the last is the microsoft common runtime they use.)

c. Download the ODAC 11 XCopy (the current version is 11.1.0.6) and unzip.

• OraOps11w.dll - in the odp.net20 folder, goes in your project root.

  (this file is what the Oracle.DataAccess.dll talks to and uses to work with the Instant Client files).

d. For compatibility with ClickOnce deployment, select these files in your project and make sure they are "Content" and "Copy Local" in your project. The manifest will then deploy them properly.

Result... the payload added to your project is 30mb, which kinda sucks, but much better than 100+ or 400+, supports western characters, but kicks butt in that 1) it requires no path, 2) requires no registry entries, 3) is isolated in deployment and does not hose other Oracle Client installations, 4) works will all DBs back through 9.2.