SQL> Create public database link MSTEST connect to MSTEST identified by mstest124 using 'dg4msql' Lets create the database link and test it. Used TNSNAMES adapter to resolve the aliasĪttempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=13.129.101.40)(PORT=1521)) (CONNECT_DATA=(SID=dg4msql)) (HS=OK)) Now add the tns entry in tnsnames.ora file dg4msql admin]$ tnsping dg4msql ( HOST=13.129.101.40)(PORT=1521) - This is the oracle database server ip LISTENER_dg4mssql= Now add the below entry in listener.ora file and start the listener So select that sql server gateway option.Įnter the sql server details to which we are creating the database link. Here we are connecting to microsoft sql server. Select the oracle_home same as that of the oracle database. rw-r-r- 1 oracle oinstall 500 welcome.html rw-r-r- 1 oracle oinstall 30016 readme.html rwxr-xr-x 1 oracle oinstall 3267 runInstallerĭrwxr-xr-x 2 oracle oinstall 4096 response Unzip the file in oracle database server and execute runInstaller HouseKeeping]$ HouseKeeping]$ unzip HouseKeeping]$ cd gateways]$ ls -ltrĭrwxr-xr-x 4 oracle oinstall 4096 install Here in this article i will show how to create db_link using oracle gateway. We can achive this either by using third party odbc drivers or using oracle provided gateways utility. But setting up db_link from oracle to mssql server isn’t straight forward.

Creating a database link from oracle to oracle database is easy.

Create database in sql server