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

by

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
  • oraociicus11.dll

  • msvcr71.dll (not necessary, should be supplied with most Windows versions)

    (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.

More Related Contents:

  1. Deploying and Configuring ODP.NET to work without installation with Entity Framework
  2. Oracle.ManagedDataAccess.EntityFramework – ORA-01918: user ‘dbo’ does not exist
  3. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  4. Get counts of all tables in a schema
  5. Determining location of relevant tnsnames.ora file
  6. List of foreign keys and the tables they reference in Oracle DB
  7. ORA-28040: No matching authentication protocol exception
  8. Can you use Microsoft Entity Framework with Oracle? [closed]
  9. hibernate oracle sequence produces large gap
  10. How to handle Day Light Saving in Oracle database
  11. Oracle Search all tables all columns for string [duplicate]
  12. Oracle PL/SQL – How to create a simple array variable?
  13. creating parameterized views in oracle11g
  14. Oracle’s default date format is YYYY-MM-DD, WHY?
  15. PL/SQL print out ref cursor returned by a stored procedure
  16. How to use a table type in a SELECT FROM statement?
  17. Default Schema in Oracle Connection URL
  18. how to replace multiple strings together in Oracle
  19. Dynamically pivoting a table Oracle
  20. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  21. URL string format for connecting to Oracle database with JDBC
  22. Convert epoch to date in sqlplus / Oracle
  23. Valid Date Checks in Oracle
  24. Why are Oracle table/column/index names limited to 30 characters?
  25. What is the difference between precision and scale?
  26. Get the number of days between two dates in Oracle, inclusive of the dates
  27. How to output result of SELECT statement which is executed using native dynamic SQL?
  28. Cursor For Loop with dynamic SQL-Statement
  29. automating rollback script oracle
  30. Query to search all packages for table and/or column

Leave a Comment