Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Oracle 32 bit client on 64 SQL Server 2008 Expand / Collapse
Posted Wednesday, October 27, 2010 12:19 AM


Group: General Forum Members
Last Login: Monday, July 15, 2013 8:26 AM
Points: 162, Visits: 69
Dirt McStain (10/26/2010)
i don't have it in front of me, but there is a 64-bit ADO.NET driver. I don't remember what it comes up as in the menu, but it's there and it works in 64 bit without any problems for me. When I was testing out different versions of Oracle client, I remember that I ran into some problems. Installing Client 11g R1 32-bit alongside the 11g R2 64-bit driver cleared up all of the issues. The biggest problem is that you need the 32 bit driver while developing in BIDS but the jobs run in 64-bit mode. Installing the R2 32-bit driver caused a lot of problems, so I ended up using R1 instead.

Now i have a hope that 64 bit (Ado.Net) drivers exist for 11g Oracle.. I did an exhaustive search and downloaded all that i found with x64 from the oracle site. If you can leak out your installation procedure and post installation steps it could help me to find where i went wrong.
Post #1011290
Posted Tuesday, June 11, 2013 10:11 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, February 10, 2016 9:16 AM
Points: 550, Visits: 184
This is an old thread, but I'm sure many guys still suffer the dual Oracle client installation.

I managed to install both R2 versions of the Oracle Client without one installation messing the "client1" groups on the start menu and registry keys created by the other installation.

The trick is edit the oraparam.ini file found in your installation files at winXX_11gR2_client\client\install\. There all you need to edit is the key DEFAULT_HOME_NAME. Note the installer will weirdly add a "1" at the end, whatever you put there, so that's why I left the underscore at the end of each. This is how I left mine:

For 64 bit install:
For 32 bit install:

After the installation this will create two folders at the Start menu:
Oracle - Ora11Home64_1
Oracle - Ora11Home32_1

And in the registry you'll end with:
HKLM / Software / Oracle / KEY_Ora11Home64_1
HKLM / Software / Wow6432Node / Oracle / KEY_Ora11Home32_1

When you create ODBC or similar objects you'll get then the proper naming referring if it's using the 32 or the 64 bit driver.

Supposedly you can feed the ORACLE_HOME name trough the command line parameters when running setup.exe, but got sick of trying to find the way to make it work and the installer never liking it so editing the INI just makes the trick.

BTW - If anyone is going trough the dual install I highly recommend downloading the separate uninstaller so you can get rid of everything easily without going trough that annoying installer.

Good luck!
Post #1462261
Posted Friday, June 21, 2013 6:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 21, 2013 6:22 AM
Points: 1, Visits: 1
very useful information. thanks you for sharing it.

Post #1466153
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse