使用 Oracle 客户端 11 部署 .NET 应用程序所需的最少设置是什么?

2021-12-05 00:00:00 oracle odp.net

部署与 Oracle 数据库通信的 .NET 应用程序所需的最少设置是什么?

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

推荐答案

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.

对于那些和我一样的人

  1. 不希望他们的用户必须安装 ODAC 或全尺寸 Oracle 客户端
  2. 不关心特定客户端安装的可重用性
  3. 需要一个clickOnce"兼容解决方案

我找到了一种方法来做到这一点.

I found a way to do that.

一个.下载Oracle Instant Client 11.1.0.6 - Basic Lite".湾解压到任何文件夹并将以下文件复制到您的 Visual Studio 项目根目录:

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(不是必需的，大多数 Windows 版本都应该提供)

  • oci.dll
  • ociw32.dll
  • orannzsbb11.dll
  • oraocci11.dll
  • oraociicus11.dll

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

(前五个是 Oracle Instant Client 所需的最低要求，最后一个是他们使用的 microsoft 公共运行时.)

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

c.下载 ODAC 11 XCopy(当前版本为 11.1.0.6)并解压.

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

  • OraOps11w.dll - 在 odp.net20 文件夹中，进入您的项目根目录.

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

(此文件是 Oracle.DataAccess.dll 与之对话并用于处理 Instant Client 文件的文件).

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

d.为了与 ClickOnce 部署兼容，请在您的项目中选择这些文件，并确保它们在您的项目中是Content"和Copy Local".然后清单将正确部署它们.

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.

结果...添加到您的项目中的有效负载为 30mb，这有点糟糕，但比 100+ 或 400+ 好得多，支持西方字符，但在那个地方踢屁股

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. 它不需要路径，
  2. 不需要注册表项，
  3. 在部署中是隔离的，不会影响其他 Oracle 客户端安装，
  4. 将所有数据库恢复到 9.2.

相关文章