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

Installing Oracle 11g Client in a sql server 2008R2 active/passive Clustered Environment Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 5:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 19, 2015 11:10 AM
Points: 128, Visits: 561
I'm trying to get a step-by-step approach to installing Oracle 11g Client in a sql server 2008r2 Active/Passive Clustered Environment. I have found some articles stating that you have to intall both the Oracle 11g 32 and 64 bit.
Any help would be greatly appreciated.

Thanks in advance.
Post #1453012
Posted Thursday, May 16, 2013 12:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, November 23, 2015 3:48 PM
Points: 77, Visits: 574
You do not need 32-bit client, unless some 32-bit apps are running on your server and trying to connect Oracle databases.

Oracle Client should be installed on all the nodes of your SQL cluster.
Post #1453334
Posted Thursday, May 30, 2013 1:24 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 19, 2015 6:21 AM
Points: 700, Visits: 328
If you're only running 64-bit SQL Server (or other 64-bit software) on the servers all you need is the 64-bit Oracle Client.

If you're using Business Intelligence Development Studio (BIDS) or other 32-bit software on the server you also need the 32-bit Oracle Client.
Post #1458073
Posted Thursday, May 30, 2013 7:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 19, 2015 11:10 AM
Points: 128, Visits: 561
Thanks
Post #1458212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse