1.1 Release Notes

This document describes the new features, major changes, and the known issues in Oracle GoldenGate Veridata Release 23c (23.1.0.0.0). This release was certified with English only, other languages may work but not fully tested.

1.1.1 New Features and Changes in Oracle GoldenGate Veridata 23c (23.1.0.0.0)

This section summarizes the new features and significant product changes for Oracle GoldenGate Veridata in 23c (23.1.0.0.0) release.

1.1.1.1 New Features and Changes in Oracle GoldenGate Veridata 23c (23.2.0.0.0) - January 2025

Oracle GoldenGate Veridata Release 23c (23.2.0.0.0) includes the following new and changed features:

Extend support to display approximate total row number to non-Oracle databases

Support has been extended to display approximate total row numbers to non-Oracle databases, such as SQL Server, MySQL, PostgreSQL, DB2 LUW, and DB2 I.

Support for Oracle Database 23ai

Oracle GoldenGate Veridata now supports Oracle database 23ai.

Rest API now retrieves available logs

REST APIs for retrieving logs based on log level, log type (api, perf, or both) and last lines from logs have been added.

1.1.1.2 New Features and Changes in Oracle GoldenGate Veridata 23c (23.1.0.0.0)

Oracle GoldenGate Veridata Release 23c (23.1.0.0.0) includes the following new and changed features.

New Modernized User Interface

Oracle GoldenGate Veridata 23c comes with a newly designed modernized user interface which is more intuitive. See the Oracle GoldenGate Home page in Oracle GoldenGate Veridata Documentation.

New Built-In Repository Database

You do not have to maintain a separate repository database for Oracle GoldenGate Veridata. Oracle GoldenGate Veridata 23c comes with built-in repository database which is MySQL. For more information, see Oracle GoldenGate Veridata Architecture in Oracle GoldenGate Veridata Documentation.

No more dependency on Oracle Fusion Middleware

Oracle WebLogic was the application server used in Oracle GoldenGate Veridata. Starting from Oracle GoldenGate Veridata 23c, there is no more dependency on Fusion Middleware, as Oracle WebLogic has been replaced with a light-weight Helidon application server. For more information, see Oracle GoldenGate Veridata Architecture in Oracle GoldenGate Veridata Documentation.

Simplified Installation

The installation of Oracle GoldenGate Veridata 23c has been made simple, which is now a two-step process:
  1. Install Oracle GoldenGate Veridata.
  2. Run the vdtca.sh to configure Oracle GoldenGate Veridata.
For more information, see Installing and Running Oracle GoldenGate Veridata in Oracle GoldenGate Veridata Documentation.

Export/Import Utility

Starting from Oracle GoldenGate Veridata 23c, the Export and Import utilities are also available in Oracle GoldenGate Veridata UI. For more information, see Utilities in Oracle GoldenGate Veridata Documentation.

REST API

Oracle GoldenGate Veridata 23c is supported with REST APIs. For more information, see REST API for GoldenGate Veridata.

User Management

There are various roles in Oracle GoldenGate Veridata and these roles are categorized into various User Groups. The users can be assigned to these User Groups accordingly. For more information, see User Management in Oracle GoldenGate Veridata Documentation.

Single command to start Oracle GoldenGate Veridata

Start from Oracle GoldenGate Veridata 23c, you need just a single command to start Oracle GoldenGate Veridata. You do not have to start the Application server and Veridata Server separately.

Enhanced Report

Oracle GoldenGate Veridata 23c comes up with new enhanced way of displaying the Job reports.

Behavioral Changes

VGPP Utility

Starting from Oracle GoldenGate Veridata 23c, the GoldenGate Parameter Processing for Veridata (VGPP) has been deprecated. It has been integrated with the Import utility. The Import utility can accept both the file formats .xml and .prm as inputs to perform the Oracle GoldenGate Veridata configurations.

User Management

Oracle GoldenGate Veridata 23c comes with enhanced User Management. You can now create, delete, edit, users, and user groups from the Oracle GoldenGate Veridata User Interface itself. For more information, see User Management in Oracle GoldenGate Veridata Documentation.

1.1.2 Corrected Problems

This section contains information about bugs that have been corrected in 23c release. For questions on specific bugs or ticket numbers, consult Oracle Customer Support. SR is the Oracle Support SR number, and BugDB is the bug identification number.

1.1.2.1 Release 23.2.0.0.0 — January 2025

Bug 37163212 - User provided Group and Job names are not honored during parameter file import

This issue has been fixed. User Provided Group name and Job name are now considered during the import of the parameter file.

Bug 37160801 - Monitoring repair job filter by date requires timestamp

This issue has been fixed. The timestamp has been included now during the monitoring of repair job filter by date. The supported format now is yyyy-MM-dd'T'HH:mm:ss'Z'. For example, 2024-03-13T18:30:00Z.

Bug 37094623 - Compare Pair table is not fully shown if one of the CPs is failed to repair

This issue has been fixed. The Compare Pair table is being shown as expected.

1.1.3 Known Issues and Workarounds

This section details the known issues and any workarounds for the Oracle GoldenGate Veridata Release 23c (23.1.0.0.0) release.

1.1.3.1 Release 23.2.0.0.0 — January 2025

Bug 37507723 - Postgres Array to Vector Comparison and repair does not work.

Array To Vector Comparison shows same data as different. Even though the values are identical, the underlying format is different. Therefore, it is always be shown as out-of-sync. Repair doesn't work as well from Array to Vector Data Type.

Bug 37466943 - Oracle to Postgres- Hetero Vector Comparison shows incorrect result

Comparison of Oracle Vector with Postgres Vector does not show appropriate results.

Bug 37502398 - Oracle Vector : Float Values are not repaired correctly ( precision issue)

For a few float values in Oracle 23ai Vector datatype, the row value does not get repaired as expected because of precision issue(s).

Bug 37515829 - Unable to edit Row Partitions

In the Groups and Compare Pairs page, the Row Partitioning is disabled by default, though it is enabled.

Workaround: Disable the Row Partitioning toggle switch and enable it again.

Bug 37507078 - Postgres: 42.7.4 (default) connector shows schemas as catalog

When you use postgresql-42.7.4.jar (the default jar in veridata Server) for postgres agent and then create a connection, schemas are shown as catalogs while creating Groups and Compare Pairs.

Bug 37084214 - Warning message is displayed while repairing Binary Double datatype

The Binary double datatype when found out-of-sync, does not get repaired because of the limitation in ojdbc11-23.2.0.0 driver.

1.1.3.2 Release 23.1.0.0.0 — October 2024

Bug 37165991 - Repair monitoring API does not have all the repair row counts in the response

When a repair job is running, the API services has row counts for rows with different repair status (Pending, Successful, Failed, Skipped, and Running) and the repair types (insert, update, and delete) are set to zero.

This gets updated to correct values only when the entire job with all the compare pairs gets completed.

Bug 36813621 - First Login doesn't work at times

If you try to login for the first time after a long gap, then the login is not successful, at times. This can happen when VPN is disconnected and then reconnected.

Workaround: Click the Login button again.

1.1.4 Getting Help with My Oracle Support

Use My Oracle Support to find knowledge solutions, workaround, and other information that is reported by customers, partners, and Oracle employees. My Oracle Support also enables you to open a Service Request. If a patch is required to resolve a service request, you will receive instructions on how to download it from My Oracle Support.

Note:

If you purchased Oracle GoldenGate Veridata and support through a distributor, contact your distributor instead of attempting to create a service request through My Oracle Support.

1.1.4.1 Creating an Oracle GoldenGate Support Case

If you cannot find an answer to your question or problem in the Knowledge Base, you can open a support case with Oracle Support by following these steps:

  1. Go to http://support.oracle.com.

  2. Select your language and then log in with your email and Oracle password.

  3. Click the Service Requests tab.

  4. Click Create SR.

  5. Complete the form, referring to the Help at the top of the application window if necessary.

1.1.5 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.