1/8

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 System Requirements and Preinstallation Instructions

• 1.1 Supported Platforms
• 1.2 Operating System Requirements
  • 1.2.1 Memory Requirements
  • 1.2.2 Disk Requirements
  • 1.2.3 Temporary Disk Requirements
  • 1.2.4 Network Requirements
  • 1.2.5 Operating System Privileges
  • 1.2.6 Console Character Set
  • 1.2.7 Other Programs
• 1.3 Database Requirements
  • 1.3.1 Database Configuration
  • 1.3.2 Database User for Oracle GoldenGate Processes
• 1.4 Supported Sybase Data Types
  • 1.4.1 Integers
  • 1.4.2 Floating-Point Numbers
  • 1.4.3 Character Data
  • 1.4.4 Dates and Timestamps
  • 1.4.5 Large Objects
  • 1.4.6 Money Types
  • 1.4.7 IDENTITY Type
  • 1.4.8 User-Defined Types
• 1.5 Non-Supported Sybase Data Types
• 1.6 Supported Operations and Objects for Sybase
• 1.7 Non-Supported Operations and Objects for Sybase

2 Installing Oracle GoldenGate

• 2.1 Overview
• 2.2 Installation Overview
• 2.3 Downloading Oracle GoldenGate
• 2.4 Setting Library Paths for Dynamic Builds on UNIX
• 2.5 Installing Oracle GoldenGate on Linux and UNIX
• 2.6 Installing Oracle GoldenGate on Windows
  • 2.6.1 Installing the Oracle GoldenGate Files
  • 2.6.2 Specifying a Custom Manager Name
  • 2.6.3 Installing Manager as a Windows Service

3 Preparing the Sybase 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
  • 3.1.3 Limiting Row Changes in Tables that do not Have a Key
  • 3.1.4 Replicating Encrypted Data
• 3.2 Preparing the Transaction Logs
  • 3.2.1 Enabling Transaction Logging
  • 3.2.2 Sizing and Retaining the Logs
  • 3.2.3 Initializing the Secondary Truncation Point

4 Uninstalling Oracle GoldenGate

• 4.1 Uninstalling Oracle GoldenGate from Linux or UNIX
• 4.2 Uninstalling Oracle GoldenGate from Windows

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