My Oracle Support Banner

How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX Itanium) to Connect to Non-Oracle Databases Post Install (Doc ID 561033.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 12.2.0.1 [Release 10.2 to 12.2]
Oracle Solaris on SPARC (64-bit)
IBM AIX on POWER Systems (64-bit)
HP-UX Itanium
Linux x86-64
***Checked for relevance on 15-MAR-2011***




Goal

Starting with 11g Oracle now provides a Database Gateway for ODBC for the 64bit Unix operating systems on the following platforms: Linux 64bit, AIX 64bit, Solaris 64bit and HP-UX Itanium 64bit. 

It can be used to connect to any 3rd party database using a suitable 3rd party ODBC driver.
Please be aware: Installing the 32bit DG4ODBC gateway on a 64bit platform is not supported.

Differences between the older product (Generic Connectivity or sometimes also called HSODBC) and DG4ODBC (Database Gateway for ODBC):
- DG4ODBC is now a stand alone product. It is no longer required to have DG4ODBC running on the
   same machine and within the same ORACLE_HOME as the Oracle database.
- DG4ODBC is now a 64bit application for 64bit platforms and requires a 64bit ODBC driver manager as
  well as a 64bit ODBC driver EXCEPTION: DG4ODBC on HP-UX RSIC 11.1 is still 32bit and needs a 32bit ODBC driver and a 32bit ODBC DRIVER MANAGER - se also DG4ODBC on HP-UX RISC configuration covered in <<466228.1>>.
- DG4ODBC requires now a ODBC LEVEL 3 COMPLIANT ODBC driver.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
 How to Setup DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Unix platforms
 0) The ODBC driver
 1) The listener needs a new SID entry like:
 
2) The tnsnames.ora needs an entry for the DG4ODBC alias:
 
3) init.ora of the gateway:
 4) Configuring the Oracle database
 Ask Questions, Get Help, And Share Your Experiences With This Article
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.