How to Configure DG4ODBC on Linux x86 32bit or on HP-UX RISC (DG4ODBC 11.1 only) to Connect to Non-Oracle Databases post install (Doc ID 466228.1)

Last updated on APRIL 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Linux x86

Goal

LINUX specific:

Starting with 11g Oracle now provides a Database Gateway for ODBC for 32bit Linux operating systems which can be used to connect to any third party database using a suitable third party ODBC driver.
Please be aware: Installing the 32bit DG4ODBC gateway for Linux on a 64bit platform is not supported.

The 12c DG4ODBC is not ported to Linux 32-bit. The last available version on Linux 32-bit is 11.2.

 

HP UX RISC specific:

The last distributed version of DG4ODBC on HP-UX RISC is 11.1. This 11.1 gateway release is still a 32bit gateway so the steps how to configure Dg4ODBC on this platform will be included here as well.

 

General:

The difference between the older product (Generic Connectivity or sometimes also called HSODBC) is DG4ODBC is now a stand alone product. It is no longer required to have DG4ODBC running on the same machine as the Oracle database.

The gateway is certified also for older Oracle releases like 10.2.0.4, 10.2.0.5 and for a small amount of 9.2 and 10.1 databases where the gateway compatibility patch bug <> has been ported to.

You'll find the gateway compatibility patch on "My Oracle Support" by performing a simple search under the 'Patches & Updates' tab at the top of the page. Choose 'Simple Search' and enter 5965763 in the block for the patch number and select the appropriate platform from the Platform or Language list.

If the patch is not available for your platform and/or release you have to update the Oracle database to a newer version.

 

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