Installing Oracle 10 ODP.NET on Microsoft Windows 2008 Server 64bit

Question

Hello,

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

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

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

Read our privacy statement:
http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409

can anyone direct me to a version that i can install the latesr version of ODP.NET for Windows 2008 server 64bit?

Best regards, Guy Bertental

Answer 1

Guy- have a look at this, it may help. Getting Oracle client working is a pain at the best of times, x64 must make it harder.

Answer 2

I had unexpected crashes in my application using Instant Client 10.2.0.3 on Windows Server 2008 x64. After reading a few posts about the lack of support for this platform, I upgraded the client to 11.1.0.7 and it works like a charm !

So I would be surprised if ODP .NET 10.2.0.3 would be stable on Windows Server 2008 x64, if you ever managed to install it. IMHO, your options are :

• use another provider (Microsoft+client v11.1, or DataDirect...).
• go with the 11.1.0.7 beta version if you dare...

Answer 3

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

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.

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

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.

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.