The sqlnet.ora file is the profile configuration file. Let’s just connect to the SQL Server instance and check that it sees the newly installed provider :Ĭonfigure the Oracle Net (add reference to a target Oracle instance)Īs we installed the Oracle software in I:\app\oracle, the network configuration files will be located in I:\app\oracle\product\11.2.0\client_1\network\admin.Įdit the configuration of Oracle Net (sqlnet.ora) Once they succeed, you will see the following recap :Ĭlick on « End » and the installation begins… NET are selected to allow SQL Server to contact the Oracle Database by different means.īy clicking on the « Next » button, you will have to wait a little bit for verifications. Oracle ODBC Driver, Oracle Provider for OLE DB and Oracle Provider for. 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)
