My Oracle Support Banner

How to Setup DG4TERA (Oracle Database Gateway for TeraData) on Windows 32bit (Doc ID 554402.1)

Last updated on OCTOBER 17, 2019

Applies to:

Oracle Database Gateway for Teradata - Version 11.1.0.6.0 to 11.2.0.4
Microsoft Windows (32-bit)
Microsoft Windows 2000Microsoft Windows XPMicrosoft Windows Server 2003


Goal

This note describes the setup of DG4TERA for Windows 32bit operating systems. Since 11.2 there's also a DG4TERA version available for 64bit Windows. There's a separate note describing the setup on 64bit Windows. 

Prerequsites for DG4TERA are:
- Teradata CLIENT
- Teradata GSS
- Teradata TDICU

You can check the prerequisites by opening the Add/Remove programs tab of the control panel. All components should be listed there like:
Shared ICU libraries for Teradata 12.0
Teradata Cliv2 12.0
Teradata GSS client nt-i386 12.0

The Teradata ODBC driver is NOT longer needed as DG4TERA is now coming with all required components.

This gateway is certified also with older Oracle releases 9.2.0.8, 10.1.0.5, or 10.2.0.3/4. But please be aware Oracle databases releases up to 10.2.0.3 require a patch to work properly with V11 Gateways.

The patch can be found on My Oracle Support by performing a simple search using 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 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 fix is automatically included in the 10.2.0.4 patchset.

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 DG4Tera (Oracle Database Gateway for Teradata) on 32bit Windows operating systems
 
1) The listener needs a new SID entry like:
 
2) The tnsnames.ora (of the Oracle database that wants to use the gateway) needs an entry for the DG4TERA alias:
 3) init.ora of the gateway:
 4) Configuring the Oracle database

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