How to Configure DG4MSQL (Oracle Database Gateway for MS SQL Server) Release 11.1 or 11.2 on Linux x86 32bit - Post Install (Doc ID 437374.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.0.1.0.1 to 11.2.0.4
Linux x86
***Checked for relevance on 13-Oct-2015***

Goal

Starting with 11g Oracle now provides a  Database Gateway for MS SQL Server on Linux  x86 32bit.  The 12c gateways have not been ported to Linux 32-bit.

The setup in 11g slightly differs from previous releases and this note will explain the steps how to configure DG4MSQL on Linux.

The gateway is certified also for older Oracle releases 9.2.0.8, 10.1.0.5, or 10.2.0.3. But please be aware those pre-11g Oracle databases require a patch to work properly with V11 Gateways.

The patch can be found on My Oracle Support by performing a  search under the 'Patches & Updates' tab at the top of the page. Choose the 'Search'  tab and enter "5965763" in the block 'Patch name or Number' and select the appropriate platform after choosing the 'Platform' tab.

If there is not a patch available for your database version (i.e. 9.2.0.8, 10.1.0.5, or 10.2.0.3) for the platform you selected, please log a Service Request with Oracle Support requesting a backport for unpublished <Bug 5965763> to your platform.

This gateway compatibility patch is included in all Oracle database releases above 10.2.0.4.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms