Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 System Requirements and Preinstallation Instructions

• 1.1 Overview of Oracle GoldenGate for Teradata
• 1.2 Verifying Certification and System Requirements
• 1.3 Supported Platforms for a Replication Server
• 1.4 Operating System Requirements
  • 1.4.1 Memory Requirements
  • 1.4.2 Disk Requirements
  • 1.4.3 Network
  • 1.4.4 Operating System Privileges
  • 1.4.5 Console
  • 1.4.6 Other Programs
• 1.5 Database Requirements
  • 1.5.1 Database Configuration
  • 1.5.2 Database User for Oracle GoldenGate Processes
• 1.6 Supported Teradata Data Types
  • 1.6.1 Limitations of Support for Numeric Data Types
  • 1.6.2 Limitations of Support for Single-byte Character Data Types
  • 1.6.3 Conditions and Limitations of Support for Multi-byte Character Data
  • 1.6.4 Limitations of Support for Binary Data Types
  • 1.6.5 Limitations of Support for Large Object Data Types
  • 1.6.6 Limitations of Support for Date Data Types
  • 1.6.7 Limitations of Support for IDENTITY Data Types
• 1.7 Supported Objects and Operations for Teradata
• 1.8 Non-Supported Operations for Teradata

2 Installing Oracle GoldenGate

• 2.1 Installation Overview
• 2.2 Understanding and Obtaining the Oracle GoldenGate Distribution
• 2.3 Setting Library Paths for Dynamic Builds on UNIX
• 2.4 Preparing to Install Oracle GoldenGate within a Cluster
  • 2.4.1 Deciding Where to Install Oracle GoldenGate Binaries and Files in the Cluster
• 2.5 Installing Oracle GoldenGate on Linux and UNIX
• 2.6 Installing Oracle GoldenGate on Windows
  • 2.6.1 Installing Oracle GoldenGate into a Windows Cluster
  • 2.6.2 Installing the Oracle GoldenGate Files
  • 2.6.3 Specifying a custom Manager name
  • 2.6.4 Installing Manager as a Windows Service
• 2.7 Integrating Oracle GoldenGate into a Cluster
  • 2.7.1 General Requirements in a Cluster
  • 2.7.2 Adding Oracle GoldenGate as a Windows Cluster Resource

3 Preparing the System for Oracle GoldenGate

• 3.1 Preparing Tables for Processing
  • 3.1.1 Disabling Triggers and Cascade Constraints
  • 3.1.2 Assigning Row Identifiers
    • 3.1.2.1 How Oracle GoldenGate Determines the Kind of Row Identifier to Use
    • 3.1.2.2 Using KEYCOLS to Specify a Custom Key

4 Configuring Oracle GoldenGate

• 4.1 Configuring Oracle GoldenGate Replicat
• 4.2 Additional Oracle GoldenGate Configuration Guidelines
  • 4.2.1 Handling Massive Update and Delete Operations
  • 4.2.2 Preventing Multiple Connections
  • 4.2.3 Performing Initial Synchronization

5 Modifying Objects in the Oracle GoldenGate Configuration

• 5.1 Modifying Columns of a Table

6 Uninstalling Oracle GoldenGate

• 6.1 Uninstalling Oracle GoldenGate from Linux or UNIX
• 6.2 Uninstalling Oracle GoldenGate from Windows Cluster
• 6.3 Uninstalling Oracle GoldenGate from Windows (Non-cluster)

A Oracle GoldenGate Installed Components

• A.1 Oracle GoldenGate Programs and Utilities
• A.2 Oracle GoldenGate Subdirectories
• A.3 Other Oracle GoldenGate Files
• A.4 Oracle GoldenGate Checkpoint Table