• 15. Re: MS SQL Server to Oracle
      518415
      I had a few questions in this regard

      1. I don't find any Gateway service being created in the services panel. What is the purpose of this inittg4msql.ora?
      Is there any utility to create gateway service in oracle10g as it used to be in 8 like

      CMD> Set GTW_EXE=TGMSQL80.exe
      CMD> GTWSRV80 sid -create | more

      2. As Gateway installation and database server is on the same machine with one Listener which reads from
      oracle_home\network\admin\listener.ora
      Then what is the function of listener.ora under
      oracle_home\tg4msql\admin
      Same with Tnsnames.ora file.

      Please help me as I have been trying with this for many days and its going nowhere.
      • 16. Re: MS SQL Server to Oracle
        46197
        In response to those that are getting poor performance... Try setting HS_FDS_TRACE_LEVEL=OFF. All the examples here have it set to DEBUG. It was slow until I turned it off.

        Message was edited by:
        spcjak
        • 17. Re: MS SQL Server to Oracle
          jan.matusiewicz
          Hi
          I used the gateway version from the page:
          http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html (file 10201_gateways_win32.zip)

          The oracle home was a bit different: C:\oracle\product\10.2.0\tg_1 instead of c:\oracle\product\10.1.0\db_1

          In addition I found that most configuration files are located in $ORACLE_HOME\NETWORK\ADMIN instead of $ORACLE_HOME\tg4msql\admin
          Some setting were correctly filled during the instalaction of the gateway, but I had to adjust some of them, for example I had to set SID to tg4msql

          BTW, there is a good article about accessing Sql Server from Oracle at http://oracle-apps-dba.blogspot.com/2008/04/oracle-transparent-gateways-general.html

          Regards,
          1 2 上一个 下一个