Link Server:-A linked server allows joining several SQL Server instances using a single T-SQL statement when data exists on multiple databases on different SQL instances.Using a linked server to retrieve data from several SQL instances, the only thing that should be done is to connect to one SQL instance.
Here we will learn how to create Link Server from SQL To Oracle Server Below are the points are need to follow..............
Download the files for the Oracle database server
After the installation process completes, reboot your computer. If your installation went like mine, then your Services listing will include go to services.msc and check it services .
Steps to install and configurations:-
Step1
Step2
Step3
Step4
Step5
After Install Oracle Client go to services .MSc and check it install oracle client status:-
Tns.ora file client look like this
Step6
Entery in tns.ora file as provide by oracle team
Step7
Save it and go to cmd.exe and chk using below steps as per snapshot
Step8
Step9
Step 10
Step10
Step 11
Go to Provider Folder and change the below settings
Thanks You..............
