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

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 Tuesday, July 28, 2015 2:43 AM

Is the Oracle client setup correctly, especially the Tnsnames.ora file?

Hi Ione,

In addition to other post, you can perform the following steps to troubleshoot this issue. For more details, please review this blog: ORA-12541: TNS: no listener.

1. Check the tnsnames.ora file and ensure that it points to the correct server and port.
2. Test the TNS resolve with tnsping from the command prompt.
3. Make sure that your listener service is running.

There is also a similar thread for your reference.
http://serverfault.com/questions/249677/unable-to-access-oracle-db-from-sql-server-with-odac

Thanks,
Lydia Zhang