March 6, 2015 at 4:16 pm
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.
March 7, 2015 at 6:38 am
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