1 Reply Latest reply on Oct 18, 2016 12:32 PM by Shaik

    Oracle DB connection with SQL DB

    3124127

      Hi Experts,

       

      need you help on below scenario.

       

      I have EBS machine with following specs.

      We have following Oracle ERP Machine.

       

      Machine Information :

       

      Operating System

      Oracle Linux

      Operating System Release no

      Oracle Linux Server release 6.5

      Kernel

      1. 3.8.13-16.2.1.el6uek.x86_64

      Database Version

      Oracle Database 11 g Enterprise Edition Release 11.2.0.2.0 64 Bit

      Application Version

      EBS R12 12.1.3

      Enterprise Business Suit

      EBS R12

      Above machine is Virtual Machine on Hyper-V 2012.

      All Virtual Disks are on RAID 1+0

       

      now i had an HRMS based application i want to connect it's database with oracle database (Having Parent Schema)

       

      The Other DB information are as following

       

      Windows Server 2012 R2

      DB : Microsoft SQL Server 2014 Express Edition

       

      I tried ODBC connection but its not successful.

       

      How can i achieve this task ?

       

      Message was edited by: 3124127

        • 1. Re: Oracle DB connection with SQL DB
          Shaik

          Hi

           

           

          1. Oracle Database Gateways 11g Release 2 [dg4odbc] on windows or Linuxmachine

          2. create the DSN in Windows machine for sql server

          Go to Control Panel àAdministrative Tools àData sources (ODBC)àSystem DSN

           

          3.

          Edit the initdg4odbc.ora file

           

          Go to initdg4odbc.ora file location and edit the following parameters

           

               example:

          Location: E:\product\11.2.0\tg_1\hs\admin

           

               Parameters:

           

                        HS_FDS_CONNECT_INFO = mssql     // Give the DSN name which have already created

                        HS_FDS_TRACE_LEVEL = off

           

           

          4.

          Configure the tnsnames in oracle box(Linux OS)

           

          Location:   $ cd $ORACLE_HOME/network/admin

           

          dg4odbc=

                (DESCRIPTION=

          (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.1.1)(PORT=1530))

                 (CONNECT_DATA= (SID=dg4odbc))

                 (HS=OK))

           

          5. Create db link in Oracle

          Sql> create public database link mlink

                    Connect to “sa”

                    Identified by “apps”

                    Using ‘dg4odbc’;       // this is tnsname entry

           

           

          Then you can check the tables you can able to access from SQL server.

           

           

          Regards

          Shaik