InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 23:34:03 GMT20http://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspxI spent quite a bit of time on this. I found BOL to be less than useful (dated information). I never a number of posts that indicated installing both 32-bit and 64-bit Oracle clientsI am listing my steps in the hope that someone might get some benefit from them.Both of my database servers (SQL 2008 R2 and Oracle 11.2.0.1) are Windows 2008 R2 64-bit.1) From the Oracle website download section, I down loaded from under the oracle database section the win64_11gR2_client and installed it on the SQL Server database server. I rebooted here (might have needed to do so). 2) I used Oracle Net Manger to configure the client. When tested I successfully connected to the target Oracle server.3) Added a tnsnames.ora file (point to the Oracle target) in C:\oracle\product\11.2.0\client_1etwork\admin4) Defined the Linked Server - I mapped specific logins; checked the Allow inprocess box under the OraOLEDB.Oracle ProviderQuerying from the SQL Server server to the Oracle server was successfulWed, 03 Apr 2013 08:35:54 GMTJohn Langstonhttp://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspxI have tried this one[url=http://queryingsql.blogspot.in/2012/10/linked-server-setup-with-oracle.html?utm_source=BP_recent]http://queryingsql.blogspot.in/2012/10/linked-server-setup-with-oracle.html?utm_source=BP_recent[/url]Tue, 15 Jan 2013 00:46:14 GMTUmaShankar Patelhttp://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspx32-bit software (SSMS, BIDS, etc) requires 32-bit Oracle Client. 64-bit software (SQL Server Database Engine)requires 64-bit Oracle client.Fri, 05 Oct 2012 00:24:00 GMTSQL Surfer '66http://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspxI'm curious as well, LOL! I installed the 64 bit first, so maybe I only needed the 32 bit client for it to work. I do know for certain, it didn't work with just the 64 bit client. On the next server I set up, I will try the 32 bit client by itself first. I'll post back after I try that, but it might be awhile.Thu, 04 Oct 2012 14:08:01 GMTscogebhttp://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspx[quote][b]scogeb (10/4/2012)[/b][hr]Thanks for the links guys! Wow, what a zoo. I finally got it to work, but it was a chore. I had to install both the 32 and 64 bit clients. I then used Oracle Net Manager to create a service name in both the 32 and 64 bit clients. Then in SSMS, I created the linked server. I was then able to run openquery commands successfully.[/quote]I'm curious about why both the 32 and 64 bits clients had to be installed, after all I expect the connection to be established by a single client as opposed to a colaborative effort between two different ones.Thu, 04 Oct 2012 13:09:00 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspxThanks for the links guys! Wow, what a zoo. I finally got it to work, but it was a chore. I had to install both the 32 and 64 bit clients. I then used Oracle Net Manager to create a service name in both the 32 and 64 bit clients. Then in SSMS, I created the linked server. I was then able to run openquery commands successfully.Thu, 04 Oct 2012 10:45:27 GMTscogebhttp://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspx[url=http://www.sqlservercentral.com/Forums/Topic1077381-1044-1.aspx]Check out the Driver mania thread in this forum[/url]Thu, 04 Oct 2012 00:00:11 GMTJo Pattynhttp://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspxThis may help, it's relevant for 2k8r2 also:http://www.expressnetsolutions.com/sqldch/?p=89Tue, 02 Oct 2012 18:40:09 GMTSQLDCHhttp://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspxI haven't worked with Oracle 11, but this is the procedure I've used with previous Oracle versions. The little I saw of Oracle 11 before I left my previous job tells me that it still works the same way.Tue, 02 Oct 2012 14:46:52 GMTSQL Surfer '66http://www.sqlservercentral.com/Forums/Topic1367248-1044-1.aspxI've been tasked with setting up an Oracle linked server on a new SQL 2008 R2 install. I have installed the Oracle win64 11gr2 client on the windows 2008 r2 server. I then used Oracle Net Manager to create Service Naming for the connection I want. Do I then use that Service Naming for my linked server in SSMS? It looks like that is what was done on the old server I'm replacing but I didn't set that one up. Is this the most effecient way to do it?Tue, 02 Oct 2012 13:05:30 GMTscogeb