Linked server connection to oracle

Hi, I am creating a linked server connection to oracle 11g from SQL Server 2014 and get ORA-12541 tns no listener error. Could you please guide me in the right direction.

Thanks in advanc

July 27th, 2015 10:13pm

Had to edit my original reply as i misread the error number...

Generally No-Listener means you cant get to the oracle database from SQL Server side. When you installed Oracle client did you do a full install? If so, can you connect to Oracle from your SQL Server using SQL Plus?

Let me know


  • Edited by SQLGru 4 hours 24 minutes ago
Free Windows Admin Tool Kit Click here and download it now
July 27th, 2015 10:37pm
Is the Oracle client setup correctly, especially the Tnsnames.ora file?
July 28th, 2015 2:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics