Linked server issues

  • newbieuser

    SSCrazy Eights

    Points: 9413

    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

  • Jo Pattyn

    SSC-Dedicated

    Points: 31255

    Have a look at

    Your way is much clearer than mine using the full oracleinstall.

  • cpacenka 34603

    SSC Journeyman

    Points: 79

    Were you able to resolve this issue? I am facing the same problem with sql server 2012.

    Cheryl

  • newbieuser

    SSCrazy Eights

    Points: 9413

    Yes.. it was some network related problem. After reboot of the server, it worked

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply