My Oracle Support Banner

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

Last updated on OCTOBER 17, 2014

Applies to:

Oracle Database Gateway for Teradata - Version and later
Microsoft Windows x64 (64-bit)



This note describes the setup of Oracle Database Gateway for TeraData (DG4TERA) on Windows 64bit operating systems.

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 13.0
Teradata Cliv2 13.0
Teradata GSS client nt-i386 13.0

SIDe NOTE: In newer Teradata releases these three packages can be bundled also in the Teradata CLIV2 Suite.


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

The database 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.

This database fix is automatically included in the patchset.


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
 How to Setup DG4Tera (Oracle Database Gateway for Teradata) on 64bit Windows operating systems
1) The gateway 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.