Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 About Oracle GoldenGate Veridata

• 1.1 Oracle GoldenGate Veridata Architecture
• 1.2 Comparing Data with Oracle GoldenGate Veridata
  • 1.2.1 Oracle GoldenGate Veridata Comparison Objects
  • 1.2.2 Satisfying Uniqueness Requirements
  • 1.2.3 How Oracle GoldenGate Veridata Compares Data
• 1.3 Viewing Comparison Results
  • 1.3.1 Out-of-Sync Report
  • 1.3.2 Comparison Report

2 Oracle GoldenGate Veridata System Requirements

• 2.1 General Information
• 2.2 Supported Databases
• 2.3 Oracle GoldenGate Veridata Agent System Requirements
  • 2.3.1 Oracle GoldenGate Veridata Java agent
  • 2.3.2 Oracle GoldenGate Veridata C-Agent
  • 2.3.3 Disk and Memory Requirements for the Agent Component
  • 2.3.4 Database Privileges for the Agent Component
• 2.4 Oracle GoldenGate Veridata Server System Requirements
  • 2.4.1 Location for the Server Component
  • 2.4.2 Disk and Memory Requirements for the Server Component
  • 2.4.3 Repository Requirements for the Server Component
• 2.5 Oracle GoldenGate Veridata Web User Interface Requirements
  • 2.5.1 Location for the Web Component
  • 2.5.2 Java Environment for the Web User Interface
  • 2.5.3 Supported Browsers for the Web User Interface
  • 2.5.4 Recommended Screen Resolution for the Web User Interface
  • 2.5.5 Port Numbers for the Web User Interface
  • 2.5.6 Security for the Web User Interface
• 2.6 SQL/MP Data Exclusions

3 Installing Oracle GoldenGate Veridata Java Agent

• 3.1 Installation Overview
• 3.2 Installing the Java Agent on a UNIX or Linux System
• 3.3 Installing the Java Agent on a Windows System

4 Installing Oracle GoldenGate Veridata C-Agent

• 4.1 Installation Overview
• 4.2 Installing the C-agent on a UNIX or Linux System
• 4.3 Installing the C-Agent on a Windows System
  • 4.3.1 Installing the Oracle GoldenGate Veridata Agent Files
  • 4.3.2 Specifying a Custom Manager Name
  • 4.3.3 Installing Manager as a Windows service
  • 4.3.4 Configuring Manager
• 4.4 Installing the C-Agent on a NonStop System
  • 4.4.1 Installing the Oracle GoldenGate Veridata Agent Files
  • 4.4.2 Copying VSNSERV to Remote Nodes
  • 4.4.3 Creating a GLOBALS File
  • 4.4.4 Configuring Manager

5 Installing Using a MySQL Repository

• 5.1 Installation Prerequisites
  • 5.1.1 Verify the Installed MySQL Database
  • 5.1.2 Verify the Database Character Encoding
• 5.2 Installing the Oracle GoldenGate Veridata Software

6 Installing Using an Oracle Repository

• 6.1 Preinstallation System Check
• 6.2 Installing the Oracle GoldenGate Veridata Software

7 Installing Using a SQL Server Repository

• 7.1 Installing the Oracle GoldenGate Veridata Software

8 Configuring Oracle GoldenGate Veridata Security

• 8.1 Oracle GoldenGate Veridata Security Overview
• 8.2 Securing the Oracle GoldenGate Veridata Files
  • 8.2.1 Controlling Access to the Installation Directories
  • 8.2.2 Securing files that Contain Business Data
• 8.3 Securing access to Oracle GoldenGate Veridata Web
• 8.4 Maintaining Passwords
  • 8.4.1 Changing User Passwords
  • 8.4.2 Changing the Repository Password

9 Running the Oracle GoldenGate Veridata Programs

• 9.1 Starting and Stopping the C-agent and Manager
• 9.2 Starting and Stopping the Java-Based Components
  • 9.2.1 Controlling the Java-Based Components from the Command Line
  • 9.2.2 Controlling the Java-Based Components as Windows Services
• 9.3 Reloading Log Information
• 9.4 Connecting to Oracle GoldenGate Veridata Web

10 Running Comparisons from the Command Line

• 10.1 Overview of the Command Line Interface
• 10.2 Running vericom
• 10.3 Vericom exit statuses
• 10.4 Vericom Output Examples

11 Oracle GoldenGate Veridata Server Configuration Parameters

• 11.1 Overview of the Server Memory
• 11.2 Estimating Memory Usage
• 11.3 How to Set a Parameter
• 11.4 Parameter Descriptions
  • 11.4.1 server.max_sort_memory
  • 11.4.2 server.max_concurrent_comparison_threads
  • 11.4.3 server.max_comparison_sort_memory
  • 11.4.4 server.sort_waiting_threshold

12 Upgrading Oracle GoldenGate Veridata

• 12.1 Upgrading the Server and Web User Interface
  • 12.1.1 Upgrade Support Overview
  • 12.1.2 Server and Web Upgrade Instructions for All Platforms
• 12.2 Upgrading to a New Release of the Agent
  • 12.2.1 Upgrading a Java Agent to a Newer Release
  • 12.2.2 Upgrading from a C-Agent to a Java Agent
  • 12.2.3 Upgrading a C-Agent to a Newer Release

13 Uninstalling Oracle GoldenGate Veridata

• 13.1 Uninstalling the Server and Web Components (all platforms)
• 13.2 Uninstalling the Java Agent from a Windows System
• 13.3 Uninstalling the Java Agent from a UNIX or Linux System
• 13.4 Uninstalling the C-agent (all platforms)

A Downloading Oracle GoldenGate Veridata

B Changing Oracle GoldenGate Veridata Web Port Numbers

C Configuring an ODBC connection for a SQL Server Repository

Glossary

Index