This will allow us to configure « routes » in a file called tnsnames.ora Oracle Net is the network layer of Oracle Database. Let’s now select the appropriate components.ĭatabase Utilities, SQL*Plus and Oracle Call Interface are selected in cases where one would add an external development for any reason.
I personally prefer separate it from operating system partition, and I follow the conventional path in Oracle as stated on the documentation page about Oracle Flexible Architecture (OFA). Then choose the destination folder for your installation. Choose « Custom »Ĭhoose the appropriate languages that your client may use. Download it, extract it and open the extracted folder. Source files can be downloaded on Oracle’s website. So I will install an Oracle Database 11g client, but you can also try installing the latest version. In my case, I want to connect an Oracle Database 11g instance. The installation won’t fail if instances are running, but at the first call of the Linked Server Provider, the instance will hang and won’t respond! We will see how to install the mandatory libraries and tools then we will configure the network layer of the Oracle database (which is called the Oracle Net) to finally be able to create a linked server and query the target database instance.įirst of all, stop the SQL Server instances running on the computer on which you will install. This is the subject that will be treated here.
That’s why Microsoft provides the « linked server » feature.īut linked servers are, by default, unable to connect to an Oracle Database. There are some cases in the wild where we want to get back data from an external database without additional coding in an application and just write a T-SQL query that will do all the job for us.
0 kommentar(er)
