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 18.104.22.168 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 10.1.0.5, or 10.2.0.3/4/5. But please be aware Oracle databases releases up to 10.2.0.3 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 10.2.0.4 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|