Topics:
Parent topic: Installing the Oracle GoldenGate Classic Architecture
In a Teradata environment, you install Oracle GoldenGate on a server that is separate from the one where the Teradata target databases are installed. This machine will be the replication server and must be a platform that is supported by Oracle GoldenGate for the Teradata database.
Some notes about choosing a replication server or servers:
The replication server can exist in the same location as the source or target server, or it can be remote from one or both.
If possible, install Oracle GoldenGate on a multi-node cluster server to minimize the impact of any Oracle GoldenGate outages that are caused by server failure.
For additional configuration considerations, see Teradata Replication Services Using Oracle GoldenGate at https://www.info.teradata.com/download.cfm?ItemID=1005496 before installing Oracle GoldenGate.
Parent topic: Installing with Teradata Databases
The recommended hardware configuration for the Oracle GoldenGate replication server is:
Four 300-GB disks
4 dual-core CPUs
8 GB of RAM
Assign the following free disk space:
To determine the size of the Oracle GoldenGate download file, view the Size column before downloading your selected build from Oracle Software Delivery Cloud. The value shown is the size of the files in compressed form. The size of the expanded Oracle GoldenGate installation directory will be significantly larger on disk.
Allow at least an additional 1 GB of disk space on any system that hosts Oracle GoldenGate trails, which are files that contain the working data. You may need more or less than this amount, because the space that is consumed by the trails depends on the volume of data that is processed. See Creating a Trail in Administering Oracle GoldenGate for the guidelines about sizing trails.
To install Oracle GoldenGate into a cluster environment, install the Oracle GoldenGate binaries and files on a shared file system that is available to all cluster nodes.
Parent topic: Installing with Teradata Databases
The Manager process requires an operating system user that has privileges to control Oracle GoldenGate processes and to read, write, and purge files and subdirectories in the Oracle GoldenGate directory. The Replicat processes require privileges to access the database.
Parent topic: Installing with Teradata Databases
This section contains Oracle GoldenGate requirements that are specific to the Teradata database.
Parent topic: Installing with Teradata Databases
Follow these requirements for database configuration:
Install an appropriate ODBC (Open Database Connectivity) driver for the database version that you are using, see What is Required?.
Configure ODBC on each target system including the creation of a data source name (DSN). A DSN stores information about how to connect to the database, see the ODBC Driver for Teradata User Guide at:
Parent topic: Database Requirements for Teradata
Follow these requirements for the database user for Oracle GoldenGate processes:
Create a database user that is dedicated to Oracle GoldenGate. It can be the same user for all of the Oracle GoldenGate processes that must connect to a database:
Replicat (target database)
The DEFGEN
utility (source or target database)
To preserve the security of your data, and to monitor Oracle GoldenGate processing accurately, do not permit other users, applications, or processes to log on as, or operate as, the Oracle GoldenGate database user.
For Oracle GoldenGate to replicate to a target Teradata database, grant SELECT
, INSERT
, UPDATE
, and DELETE
on all of the target tables to the Replicat database user.
Parent topic: Database Requirements for Teradata
Install Oracle GoldenGate on the Teradata database server, see Installing on all Platforms.
Parent topic: Installing with Teradata Databases