SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Oracle 32 bit client on 64 SQL Server 2008


Oracle 32 bit client on 64 SQL Server 2008

Author
Message
Yuvaraj Sampath
Yuvaraj Sampath
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
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.
Mithrandir
Mithrandir
SSChasing Mays
SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)

Group: General Forum Members
Points: 622 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:
DEFAULT_HOME_NAME=Ora11Home64_
For 32 bit install:
DEFAULT_HOME_NAME=Ora11Home32_

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!

http://docs.oracle.com/cd/E11882_01/em.112/e12255/oui2_manage_oracle_homes.htm#CJAGCIAC
http://docs.oracle.com/cd/E11882_01/em.112/e12255/c_oui_appendix.htm#OUICG378
99th.in
99th.in
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
very useful information. thanks you for sharing it.

thanks
99th
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search