Linked server(Test connection failure)

  • I have created a linkserver between SQL and oracle and the test connection fails with the following messages. I have done some reading and followed few articles but same error, also checked TNS entries. I am lost as to how to troubleshoot.

    If anyone can provide any clue or direction how to resolve this, will be much appreciated.

    "TITLE: Microsoft SQL Server Management Studio

    -----------------------------

    The test connection to the linked server failed.

    ------------------------------

    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServerName". OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServerName" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". (Microsoft SQL Server, Error: 7303)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3000&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476

    ------------------------------

    BUTTONS:

    OK"

    Regards,
    SQLisAwe5oMe.

  • TNS is not resolved correctly, start by checking TNSNAMES.ORA, complete checklist you can find here, search for ORA-12154:

    https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12150.htm

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

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