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

Linked server issues Expand / Collapse
Author
Message
Posted Saturday, March 10, 2012 1:38 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 351, Visits: 842
Hi friends,

I'm trying to create linked server from SQL Server 2005 SP3 on Windows 2003 64-bit to Oracle database 64-bit.

Steps are below:

Installed InstantClient Oracle 11gR2 (11.2.0.1.0) for Microsoft Windows (x64) to C:\Oracle\product\11.2.0\client_1 folder on the SQL Server - database server.

Installed ODAC (11.2.0.2.1) ODAC112021Xcopy_x64 for Windows x64 by executing
install.bat all C:\Oracle\product\11.2.0\client_1 odac

Checked the Allow inprocess of OraOLEDB.Oracle provider in SSMS.

Created ODBC connection to the Oracle database - ORADB. Connection successful via ODBC and sqlplus.

Executed sp_addlinkedserver @server = 'TEST_LINK', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = 'ORADB'

I have executed sp_addlinkedsrvlogin @rmtsrvname = 'TEST_LINK', @useself = 'FALSE', @rmtuser = 'orauser', @rmtpassword = 'pwd'

The orauser is the oracle username and pwd is the password for the oracle user orauser.

When I click Test Connection for the linked server TEST_LINK in SSMS, it just hangs.. When I try to run a query
to ORADB , 'select * from TEST_LINK..ORAUSER.TABLE1 ' - it runs forever and eventually SSMS hangs.

Please help.. Thanks




Post #1264785
Posted Monday, March 12, 2012 5:19 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 1:11 AM
Points: 1,462, Visits: 7,919
Have a look at
Your way is much clearer than mine using the full oracleinstall.
Post #1265067
Posted Wednesday, July 1, 2015 7:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 24, 2015 11:14 AM
Points: 1, Visits: 5
Were you able to resolve this issue? I am facing the same problem with sql server 2012.

Cheryl
Post #1699345
Posted Wednesday, July 1, 2015 7:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 351, Visits: 842
Yes.. it was some network related problem. After reboot of the server, it worked
Post #1699349
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse