Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Yesterday @ 11:07 AM
Points: 126, Visits: 532
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: Tuesday, July 29, 2014 12:44 AM
Points: 77, Visits: 568
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


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
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: Yesterday @ 11:07 AM
Points: 126, Visits: 532
Thanks
Post #1458212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse