Create Oracle Linked Server to Query data from Oracle to SQL Server

This SQL Server tutorial shows how to create SQL Server linked server to Oracle database, for SQL Server administrators and t-sql developers to execute sql statements over the target Oracle database tables. By creating a linked server, SQL Server database administrators or T-SQL developers can connect Oracle database from SQL Server Management Studio (SSMS) and query data stored in Oracle database tables.

I install Oracle 10g Express edition on my laptop where a default instance of Microsoft SQL Server 2008 R2 instance is also running. I sometimes require to read data from Oracle database application and display on SQL Server application. So I tried to create linked server from SQL Server to Oracle database. Actually it is somehow tricky if you are new to Oracle database configuration. So I think it will be useful for some sql developers like me trying to create linked server for Oracle in SQL Server 2008 database.

T-SQL developers can also use SQL Server linked server created from SQL Server to Oracle database to query data from SQL Server to Oracle. Developers can read data from Oracle to SQL Server instances using this Oracle linked server.

In order to create linked server for Oracle 10g Express database in Microsoft SQL Server 2008 R2 database server, open SQL Server Management Studio first.
Then connect to target SQL Server database instance.
Drill down to Server Objects in Object Explorer windows.
Right-click on Linked Servers folder and choose New Linked Server... from context menu.

https://s1.wcy.wat.edu.pl/ed/elms_fgvtr/logintoelms.php?action=signin