在 Microsoft Windows 2008 Server 64 位上安装 Oracle 10 ODP.NET

Installing Oracle 10 ODP.NET on Microsoft Windows 2008 Server 64bit(在 Microsoft Windows 2008 Server 64 位上安装 Oracle 10 ODP.NET)

问题描述

我尝试从以下位置安装Oracle10g Release 2 ODAC(64 位)10.2.0.3 for Windows x64":http://www.oracle.com/技术/软件/技术/windows/odpnet/64-bit/index.html

I've tried to install "Oracle10g Release 2 ODAC (64-bit) 10.2.0.3 for Windows x64" from: http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html

在 Windows 2008 服务器 64 位 上，但在我运行 setup.exe 后立即崩溃并出现以下错误:

on Windows 2008 server 64bit, but it crushes right after i run the setup.exe with the following error:

问题签名:问题事件名称: APPCRASH应用名称:javaw.exe 应用程序版本:5.0.40.5 应用时间戳:42a019e4 故障模块名称:StackHash_5c81 故障模块版本:6.0.6001.18000 故障模块时间戳:4791adec 异常代码:c0000374 异常偏移量:00000000000a6e97 操作系统版本:6.0.6001.2.1.0.272.7 语言环境编号:1037 附加信息1: 5c81 附加信息2:fa1981fc0da3377cbbec45e762388188
附加信息 3:7698
附加信息4:7defb6f15001721d919a359fb7888c17

Problem signature: Problem Event Name: APPCRASH Application Name: javaw.exe Application Version: 5.0.40.5 Application Timestamp: 42a019e4 Fault Module Name: StackHash_5c81 Fault Module Version: 6.0.6001.18000 Fault Module Timestamp: 4791adec Exception Code: c0000374 Exception Offset: 00000000000a6e97 OS Version: 6.0.6001.2.1.0.272.7 Locale ID: 1037 Additional Information 1: 5c81 Additional Information 2: fa1981fc0da3377cbbec45e762388188
Additional Information 3: 7698
Additional Information 4: 7defb6f15001721d919a359fb7888c17

阅读我们的隐私声明:
http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409

谁能指导我安装适用于 Windows 2008 服务器 64 位的 ODP.NET 的最新版本?

最好的问候，盖·贝坦塔尔

Best regards, Guy Bertental

推荐答案

这真的很棘手.在安装 ODP.NET 之前，您需要已经有到 oracle 数据库的工作连接设置.这意味着:

It's a really tricky. Before installing ODP.NET you need to already have working connection setup to oracle database. That means:

第 1 步:Oracle 安装客户端(从未成功过，不推荐)或 Oracle 客户端(在 Win7 Ultimate 64 位上成功，文件 win64_11gR1_client.zip，安装时选择了运行时"选项).客户端安装后确保您可以连接.从命令行尝试tnsping yourtnanamesentry"以检查tnsnames是否正常，然后尝试sqlplus username/pwd@yourtnsnamesentry"以检查您是否知道有效的用户名和密码并且真的可以连接.记住或记下您在安装过程中选择的 oracle 主目录名称和路径.

Step 1: Oracle install client (never succeeded with that, not recommended) or Oracle client (succeeded on Win7 ultimate 64bit, file win64_11gR1_client.zip, installed with "Runtime" option selected). After client install make sure you can connect. From command line try "tnsping yourtnanamesentry" to check if tnsnames is ok, and after that "sqlplus username/pwd@yourtnsnamesentry" to check if you know valid user and password and really can connect. Memorize or write down oracle home name and path you choosed during install.

第 2 步:安装 ODP.NET(我使用文件 ODAC1110720.zip).使用完全相同的 oracle home 名称，但在安装过程中使用不同的路径.

Step 2: Install ODP.NET (I did with file ODAC1110720.zip). Use exactly the same oracle home name, but different path during installation.

第 3 步:尝试连接 Visual Studio.对于服务器名称"，我使用了这个:oraclex:1521/xe".这意味着我有一台名为oraclex"的机器，它在端口 1521 上具有 oracle 侦听器，以及实例名称为xe"的数据库.这就是所谓的EZCONNECT"名称.

Step 3: try connecting with visual studio. For "server name" I used this: "oraclexe:1521/xe". That means I have machine called "oraclexe" which has oracle listener on port 1521, and database with instance name "xe". It's so-called "EZCONNECT" name.

我不确定是否真的需要第 1 步，因为也许第 3 步真的只使用 oracle 即时客户端.我知道，这是真正的痛苦，但这是有效的.连接oracle花了我2天的时间，我不得不安装将近1GB的下载的oracle软件.他们可以而且应该让这一切变得更加容易.就像一键安装一样有效.这是多么复杂的客户端安装是耻辱.

I'm not sure if Step 1 is really needed or not, because maybe step3 really uses just oracle instant client. I know, it is real pain, but this works. It took me 2 days to connect to oracle, and I had to install almost 1GB of downloaded oracle software. They could and should make that much, much, much, much easier. Like one-click install that just works. This is shame how complicated client install is.

这篇关于在 Microsoft Windows 2008 Server 64 位上安装 Oracle 10 ODP.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！