Table of Contents
- Title and Copyright Information
- Preface
- 1 Overview
-
2
Prepare
- 2.1 Supported Databases for Compare
- 2.2 Supported/Unsupported Databases for Repair
- 2.3 Supported/Unsupported Databases for Download Repair SQL
-
2.4
Supported Datatypes
- 2.4.1 Supported Datatypes - Oracle
- 2.4.2 Supported Datatypes - Oracle 23ai
- 2.4.3 Supported Datatypes - SQL Server
- 2.4.4 Supported Datatypes - PostgreSQL
- 2.4.5 Supported Datatypes - MySQL, MariaDB
- 2.4.6 Supported Datatypes - DB2 LUW
- 2.4.7 Supported Datatypes - DB2 for i
- 2.4.8 Supported Datatypes - DB2 z/OS
- 2.4.9 Supported Datatypes - Sybase
- 2.4.10 Supported Datatypes - Teradata
- 2.4.11 Generic Limitations and Clarifications
- 2.5 Oracle GoldenGate Veridata Agent System Requirements
- 2.6 Oracle GoldenGate Veridata Server System Requirements
- 2.7 Oracle GoldenGate Veridata Distribution
-
3
Install
- 3.1 Installing and Running Oracle GoldenGate Veridata
- 3.2 Running the Configuration Assistant
-
3.3
Installing and Configuring Source and
Target Agents
- 3.3.1 About Oracle GoldenGate Veridata Agent Deployment Scripts
- 3.3.2 Configuring Oracle GoldenGate Veridata Agent
- 3.3.3 Starting the Oracle GoldenGate Veridata Agent
- 3.3.4 Using the Oracle GoldenGate Veridata Agent Deployment Script in Debug Mode
- 3.3.5 Reloading the Logging Properties of the Veridata Agent
- 3.4 Silent Installation
- 3.5 Uninstalling Oracle GoldenGate Veridata
- 4 Get Started
-
5
Manage
- 5.1 Connections
- 5.2 Groups and Compare Pairs
- 5.3 Profiles
- 5.4 Jobs
- 5.5 Users
- 5.6 Utilities
-
6
Administer
- 6.1 Managing C-Agent and Java Components
- 6.2 Vericom
-
6.3
Veridata Export and Import Utilities
- 6.3.1 Introduction to the Export and Import Utilities
- 6.3.2 Running the Export and Import Utilities
-
6.3.3
Configuration File Element Reference
- 6.3.3.1 configuration
- 6.3.3.2 column
- 6.3.3.3 colfilter
- 6.3.3.4 colfiltercol
- 6.3.3.5 compare-pair
- 6.3.3.6 connection
- 6.3.3.7 conn-properties
- 6.3.3.8 delta-config
- 6.3.3.9 description
- 6.3.3.10 enscribe-info
- 6.3.3.11 enscribe-key
- 6.3.3.12 excluded-column
- 6.3.3.13 expandddl
- 6.3.3.14 filter
- 6.3.3.15 group
- 6.3.3.16 job
- 6.3.3.17 profile
- 6.3.3.18 key-column
- 6.3.3.19 profile-general
- 6.3.3.20 sorting-method
- 6.3.3.21 initial-compare
- 6.3.3.22 confirm-out-of-sync
- 6.3.3.23 param
- 6.3.3.24 repair
- 6.3.3.25 sql-partition
- 6.3.3.26 table partition
-
6.4
Server Parameters
- 6.4.1 Overview of the Server Memory
- 6.4.2 Estimating Memory Usage
- 6.4.3 How to Set a Parameter
-
6.4.4
Parameter Descriptions
-
6.4.4.1
Server Parameters
- 6.4.4.1.1 database.hash
- 6.4.4.1.2 max_lob_key_len
- 6.4.4.1.3 server.convert_empty_to_null
- 6.4.4.1.4 server.mapped_sort_buffers
- 6.4.4.1.5 server.max_concurrent_comparison_threads
- 6.4.4.1.6 server.max_sort_memory
- 6.4.4.1.7 server.memory_mapped_sort_directory
- 6.4.4.1.8 server.meta_session_handle_timeout
- 6.4.4.1.9 server.number_sort_threads
- 6.4.4.1.10 server.veridata_data
- 6.4.4.1.11 socket.timeout.mins
- 6.4.4.1.12 server.useSsl
- 6.4.4.1.13 truncate_spaces_len
- 6.4.4.2 Parameters for Report File Encryption
- 6.4.4.3 Parameters for Email Notifications and Alerts
- 6.4.4.4 Server Parameters for Oracle Streams Tagging
- 6.4.4.5 Server Parameters for Confirm Out-of-Sync Fetch Strategy
-
6.4.4.1
Server Parameters
- 6.5 Agent Parameters - General
- 6.6 Agent Parameters - Connections
-
7
Secure
-
7.1
Configuring Workflow for Two-Way SSL in Oracle
GoldenGate Veridata 23c
- 7.1.1 Enabling SSL in the Agent Properties File
- 7.1.2 Generating Agent Keystore and Certificate
- 7.1.3 Generating Server Keystore and Certificate
- 7.1.4 Importing Agent Certificate to Server Truststore
- 7.1.5 Saving Server Keystore/Truststore Passwords to Server Wallet
- 7.1.6 Importing Server Certificate to Agent Truststore
- 7.1.7 Saving Agent Keystore/Truststore Passwords to Agent Wallet
- 7.1.8 Creating an Agent Connection in UI
- 7.2 Configuring One-Way SSL for the NSK C-Agent on the Veridata Server
- 7.3 Configuring Oracle GoldenGate Veridata Agent Using Kerberos to Connect to Oracle Database
- 7.4 Configuring Oracle GoldenGate Veridata Agent Using Kerberos to Connect to Hive
- 7.5 Connecting Oracle GoldenGate Veridata to SSL-Enabled Oracle Database
- 7.6 Connecting Oracle GoldenGate Veridata to SSL-Enabled MySQL Database
- 7.7 Connecting Oracle GoldenGate Veridata to SSL-Enabled SQL Server Database
- 7.8 Connecting Oracle GoldenGate Veridata to SSL-Enabled PostgreSQL Database
-
7.1
Configuring Workflow for Two-Way SSL in Oracle
GoldenGate Veridata 23c
- 8 Migrate
- 9 Performance
- 10 Accessibility