1 Reply Latest reply: Oct 20, 2012 10:11 AM by Kgronau-Oracle RSS

    Oracle Gateway Installation

    indytoatl
      I have four systems involved in the setting up the Oracle Gateway services, where does each file come into play on each system. See below

      ** Client_Wrkstn01 (Windows7_01)
      - TNSNAME.ORA
      - SQLNET.ORA

      ** Oracle Database Server (Linux_DB01)
      - TNSNAMES.ORA
      - LISTERNER.ORA <-- Do I need this service working?
      - SQLNET.ORA

      ** Oracle Gateway Server (Linux_GW01)
      - TNSNAMES.ORA
      - LISTERNER.ORA
      - SQLNET.ORA

      ** Microsoft Datawarehouse (SQL2008_01)
      - No files
        • 1. Re: Oracle Gateway Installation
          Kgronau-Oracle
          Nothing needs to be done on the client side, so
          ** Client_Wrkstn01 (Windows7_01)
          - TNSNAME.ORA
          - SQLNET.ORA
          remains unchanged.

          the Orace database connects to the gateway listener, so you need o add the gateway tns alias to the tnsnames.ora:
          ** Oracle Database Server (Linux_DB01)
          - TNSNAMES.ORA =>add gateway address
          - LISTERNER.ORA <-- Do I need this service working? => no
          - SQLNET.ORA

          The Gateway machine needs a listener that spawns the gateway process.
          ** Oracle Gateway Server (Linux_GW01)
          - TNSNAMES.ORA=> nthing to do here
          - LISTERNER.ORA => configure a listener (host/port) and a gateway SID with the matching program (dg4odbc/dg4msql)
          - SQLNET.ORA

          nothing to do at the SQL Server site as long as user/password authentication is set up:
          ** Microsoft Datawarehouse (SQL2008_01)
          - No files