Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Information
  • Conventions
• 1 Installation and Configuration Overview
  • 1.1 Understanding Oracle GoldenGate Veridata Components
  • 1.2 Understanding Oracle GoldenGate Veridata Installation Topology
  • 1.3 Installation Roadmap for Oracle GoldenGate Veridata
  • 1.4 Understanding Oracle GoldenGate Veridata Distribution
• 2 Oracle GoldenGate Veridata Prerequisites and System Requirements
  • 2.1 General Information
  • 2.2 Prerequisites for Installing Oracle GoldenGate Veridata
    • 2.2.1 Verifying Certification, System, and Interoparability Requirements
    • 2.2.2 Selecting an Installation User
      • 2.2.2.1 About User Permissions
      • 2.2.2.2 About Non-Default User Permissions on UNIX Operating Systems
      • 2.2.2.3 Verifying that the Installation User has Administrator Privileges on Windows Operating Systems
    • 2.2.3 About the Oracle Home Directory
    • 2.2.4 About JDK Requirements for an Oracle Fusion Middleware Installation
    • 2.2.5 About Database Requirements for an Oracle Fusion Middleware Installation
  • 2.3 Supported Databases for Compare
  • 2.4 Supported/Unsupported Databases for Repair
  • 2.5 Supported/Unsupported Databases for Download Repair SQL
  • 2.6 Oracle GoldenGate Veridata Agent System Requirements
    • 2.6.1 Oracle GoldenGate Veridata Java Agent
      • 2.6.1.1 Environment Requirements to Use a Java Agent
    • 2.6.2 Oracle GoldenGate Veridata C-Agent
    • 2.6.3 Disk and Memory Requirements for the Agent Component
    • 2.6.4 Database Privileges for the Agent Component
  • 2.7 Oracle GoldenGate Veridata Server System Requirements
    • 2.7.1 Location for the Server Component
    • 2.7.2 Disk and Memory Requirements for the Server Component
    • 2.7.3 Repository Requirements for the Server Component
      • 2.7.3.1 Required Database Privileges for Oracle GoldenGate Veridata Server
      • 2.7.3.2 Required Environment Components for Oracle GoldenGate Veridata Server
  • 2.8 Oracle GoldenGate Veridata Web User Interface Requirements
    • 2.8.1 Location for the Web Component
    • 2.8.2 Java Environment for the Web User Interface
    • 2.8.3 Supported Browsers for the Web User Interface
    • 2.8.4 Recommended Screen Resolution for the Web User Interface
    • 2.8.5 Port Numbers for the Web User Interface
    • 2.8.6 Security for the Web User Interface
  • 2.9 SQL/MP Data Exclusions
• 3 Installing Oracle GoldenGate Veridata
  • 3.1 Starting the Installation Program
  • 3.2 Navigating the Installation Screens to Install Oracle GoldenGate Veridata
• 4 Creating the Oracle GoldenGate Veridata Repository Schema
  • 4.1 Configuring a Certified Database
  • 4.2 Starting Repository Creation Utility
  • 4.3 Navigating the RCU Screens to Create the Schema
• 5 Configuring Domain for Oracle GoldenGate Veridata
  • 5.1 Creating the Database Schema
  • 5.2 Configuring a Domain
    • 5.2.1 Starting the Configuration Wizard
    • 5.2.2 Navigating the Configuration Wizard Screens to Configure the Domain
    • 5.2.3 Configuring the WebLogic Server Domain in a Silent Mode
    • 5.2.4 Updating the Oracle WebLogic Server Credentials
  • 5.3 Performing Next Steps
• 6 Deploying and Configuring Oracle GoldenGate Veridata Agent
  • 6.1 About Oracle GoldenGate Veridata Agent Deployment Scripts
  • 6.2 Configuring Oracle GoldenGate Veridata Agent
  • 6.3 Starting the Oracle GoldenGate Veridata Agent
  • 6.4 Using the Oracle GoldenGate Veridata Agent Deployment Script in Debug Mode
  • 6.5 Reload the Logging Properties of the Veridata Agent
• 7 Running Oracle GoldenGate Veridata as a Windows Service
  • 7.1 Running Oracle GoldenGate Veridata as a Windows Service (for Server)
  • 7.2 Running Oracle GoldenGate Veridata as a Windows Service (for Agent)
• 8 Configuring Oracle GoldenGate Veridata Agent Using Kerberos to Connect to Oracle Database
• 9 Configuring Oracle GoldenGate Veridata Agent Using Kerberos to Connect to Hive
• 10 Connecting Oracle GoldenGate Veridata to SSL-Enabled Oracle Database
• 11 Connecting Oracle GoldenGate Veridata to SSL-Enabled MySQL Database
• 12 Connecting Oracle GoldenGate Veridata to SSL-Enabled SQL Server Database
• 13 Connecting Oracle GoldenGate Veridata to SSL-Enabled PostgreSQL Database
• 14 Next Steps After Configuring an Oracle GoldenGate Veridata Domain
  • 14.1 Verifying the Oracle GoldenGate Veridata Installation
    • 14.1.1 Reviewing Installation Log Files
    • 14.1.2 Verifying the Directory Structure
  • 14.2 Starting the Servers
    • 14.2.1 Starting the Administration Server
    • 14.2.2 Starting the Managed Server using Veridata Scripts
  • 14.3 Creating Oracle GoldenGate Oracle GoldenGate Veridata Users and Assigning Privileges
  • 14.4 Launching Oracle GoldenGate Veridata Web User Interface
• 15 Deinstalling Oracle GoldenGate Veridata
  • 15.1 Understanding Product Deinstallation
  • 15.2 Stopping Oracle Fusion Middleware
    • 15.2.1 Stopping Your Oracle GoldenGate Veridata Agent
    • 15.2.2 Stopping the Oracle Fusion Middleware Environment
  • 15.3 Removing Your Database Schemas
  • 15.4 Deinstalling the Software
    • 15.4.1 Starting the Deinstaller
    • 15.4.2 Navigating the Deinstallation Screens
  • 15.5 Removing the Oracle Home Directory Manually
  • 15.6 Removing Your Domain and Application Data
  • 15.7 Deinstalling Oracle Fusion Middleware Infrastructure
  • 15.8 Reinstalling the Software
• A Installing Oracle GoldenGate Veridata C-Agent
  • A.1 Installation Overview
  • A.2 Installing the C-Agent on a NonStop System
    • A.2.1 Installing the Oracle GoldenGate Veridata Agent Files
    • A.2.2 Copying VSNSERV to Remote Nodes
    • A.2.3 Creating a GLOBALS File
    • A.2.4 Configuring Manager
• B Understanding the Oracle GoldenGate Veridata Directory Structure
  • B.1 Oracle Home Directory Structure
  • B.2 Veridata Domain Home Directory Structure
• C Oracle GoldenGate Veridata Distribution
  • C.1 Downloading Oracle GoldenGate Veridata
  • C.2 Downloading Oracle GoldenGate Veridata C-Agent and Java Agent for DB2 for i or DB2 z/OS
  • C.3 Downloading the Product
• D Oracle GoldenGate Veridata Silent Installation
• E Best Practices
  • E.1 Veridata Components Proximity
    • E.1.1 How to Check Connection between 2 Nodes
  • E.2 Veridata Server and Agent Memory
    • E.2.1 Server Memory
      • E.2.1.1 How to Check Current Memory of Server?
      • E.2.1.2 What Should be the Optimum Memory for Server?
      • E.2.1.3 How to Modify Memory for Server?
      • E.2.1.4 What is the Maximum Memory % of my Server Node that I can allocate to Veridata Server?
    • E.2.2 Agent Memory
      • E.2.2.1 How to Check Current Memory of Agent?
      • E.2.2.2 What Should be the Optimum Memory for Agent?
      • E.2.2.3 How to Modify the Memory for Agent?
    • E.2.3 Memory for Sorting and Sort Directory
  • E.3 SSL Certificate Validation
  • E.4 Database Permissions
  • E.5 Data for Comparison
    • E.5.1 Specifying Primary Key (PK) Columns
    • E.5.2 Partitioning
    • E.5.3 Exclude Columns
    • E.5.4 Delta Comparison
      • E.5.4.1 Delta Column Selection
      • E.5.4.2 ROWDEPENDENCIES
  • E.6 Profile Configurations
    • E.6.1 Connection Configurations
    • E.6.2 Sorting Configuration
    • E.6.3 Initial Compare Configuration
    • E.6.4 Out-of-Sync Configuration
    • E.6.5 Repair Configuration
    • E.6.6 Possible Configurations from the veridata.cfg File
    • E.6.7 Possible Configurations from the agent.properties File
      • E.6.7.1 Coos Batch Fetch
      • E.6.7.2 ROWSCN
    • E.6.8 Frequently Asked Questions (FAQ)
• F Logging
  • F.1 Logs and Setting Log Levels
  • F.2 Agent
    • F.2.1 Agent Logs Location
    • F.2.2 Updating Agent Log Settings
    • F.2.3 Enabling Performance Logs
    • F.2.4 Enabling Trace Logs
    • F.2.5 Enabling Query Logs
    • F.2.6 Modifying Log Size
  • F.3 Server
    • F.3.1 Server Log Location
    • F.3.2 Updating Server Log Settings
    • F.3.3 Enabling Trace Logging
    • F.3.4 Changing Log Size