Chatee ahora con Soporte
Chat con el soporte

SharePlex 11.4 - Release Notes

Release Notes

SharePlex® 11.4

Release Notes

Revision: 8/13/2024

 

About SharePlex

For over two decades, SharePlex has provided high speed database replication for mission critical database environments.

SharePlex supports a wide variety of configurations to meet different and complex data availability needs. A primary class of use cases revolves around database scaling and availability.

  • SharePlex supports reliable Oracle and PostgreSQL high-availability and disaster recovery configurations where replication maintains a duplicate database in a different location that is ready for fast, seamless fail-over and failback in planned or unplanned mode.

  • SharePlex also supports bi-directional, active/active configurations with conflict resolution for PostgreSQL to PostgreSQL and Oracle to Oracle to support horizontal scaling and strategic placement of databases near regional users.

  • SharePlex can support cross platform (Oracle ← → PostgreSQL) bi-directional, active-active replication with conflict resolution to de-risk Oracle to PostgreSQL migrations in complex Oracle environments.

  • SharePlex can improve scaling by offloading Oracle or PostgreSQL reporting workloads.

Another class of use cases involves (generally) cross-platform data movement to support application integration, database interoperability and data lake population. Examples include:

  • PostgreSQL and/or Oracle replication to Snowflake to support data warehouse/data lake pipelines

  • PostgreSQL and/or Oracle replication to Kafka for real-time streaming analytic applications

  • PostgreSQL to Oracle (or) Oracle to PostgreSQL replication to provide interoperability between systems to support database refactoring or migration from Oracle to PostgreSQL.

You can also use SharePlex to replicate data from Oracle source to maintain a change history database in an Oracle target. Rather than updating or deleting target rows based on the source change, SharePlex inserts a new row on the target for every source change. The result is an archive that reflects the chronological history of every change made to the source database.

SharePlex's value and versatility continue to grow with the requirements and requests of our customers. Although SharePlex is a reliable, relatively low-maintenance solution, our top-rated support team is ready around the clock to help with any trouble you may have. To get you started with your deployment, our professional services team is highly experienced and readily available.

Join our community

For expert advice and the latest news about SharePlex, join the SharePlex Community at https://www.quest.com/community/products/shareplex. Take advantage of our forums, blogs, videos, and more from our own experts, as well as input from our customers and partners.

About this release

In this release, SharePlex supports the Compare and Repair commands for the PostgreSQL database as both a source and target. Additionally, SharePlex also supports the following database versions and operating systems:

  • PostgreSQL 16 and PostgreSQL Enterprise Database (EDB) 16 as source and target

  • Kafka 3.3 and 3.6.1 as target

  • JMS Apache ActiveMQ 5.16.7

  • JMS IBM MQ 9.3

  • Snowflake 8.1 as target

  • RHEL (Red Hat Enterprise Linux) 9.x

Revision History

Document Version Date Change History
2 6th May 2024 Added a condition of support for the BINARY DOUBLE and BINARY FLOAT data types.
3 17th May 2024
  • Added Oracle 21c as a supported database for OLTP compressed data.

  • Removed Oracle 23c DBCS support-related information since Oracle DBCS no longer supports Oracle 23c.

4 19th June 2024
  • Added support for Fujitsu Enterprise PostgreSQL 15 SP2 as both a source and target database for PostgreSQL.

  • SPO-24851 (Repair status shows invalid “Total Rows” information while executing during the initial phase) was removed from the Resolved Issues section. While it was believed that the fix in 11.4 fully resolved the issue, it did not. For any customers facing this issue, a one-off has been generated and can be obtained through support.

5 25th June 2024
  • Added support for the AlloyDB Omni 15.5.x database for PostgreSQL as both a source and a target.

  • Added support for the Google AlloyDB for PostgreSQL Cloud platform as a source for PostgreSQL and as a target for PostgreSQL, Oracle, and SQL Server.

  • Updated a note regarding support for JSON and JSONB data type columns with partition keys in the PostgreSQL to PostgreSQL Replication section.

6 22nd July 2024
  • Added a known issue (SPSQL-2530) related to performance observed during bulk DML operations.

  • Removed the SPO-24845 issue from the Resolved Issues section. While it was believed that the fix in 11.4 fully resolved the issue, it did not. For any customers facing this issue, a one-off has been generated and can be obtained through support.

  • Added a limitation regarding the replication of data containing the ALTER statement during DDL operations.

  • Added a known issue (SPO-24922) about not supporting the RAISE command on PostgreSQL databases.

7 13th August 2024 Added LATIN1 as a supported character set for PostgreSQL-to-PostgreSQL replication, with a note.

New Features

What's New in this Release

Compare/Repair commands support:

SharePlex now supports the Compare and Repair commands for PostgreSQL database as both a source and a target.

Data Types support:

SharePlex now supports the JSON and JSONB data types for PostgreSQL to PostgreSQL replication.

Note: JSON and JSONB data types are supported only with logical replication.

Snowflake Performance Enhancement:

SharePlex now supports the replication of bulk updates and deletes for the Snowflake database as a target, excluding the following advanced data types:

  • RAW, LONGRAW, BLOB, CLOB, NCLOB, BINARY_FLOAT (for Oracle databases)

  • CHAR(2000), VARCHAR(4000), TEXT, BYTEA (for PostgreSQL databases)

Database/Platform Support:

  • This release includes support for PostgreSQL 16 and PostgreSQL Enterprise Database (EDB) 16 as both a source and a target.

  • This release includes support for Kafka 3.3 and 3.6.1 as a target.

  • This release includes support for the following JMS message Queues:

    • Apache ActiveMQ 5.16.7

    • IBM MQ 9.3

  • This release includes support for Snowflake 8.1 as a target.

Operating System support:

This release includes support for RHEL (Red Hat Enterprise Linux) 9.x.

Other features:

  • This release includes support for Azure Flexible Server with high availability using logical replication.

  • This release includes support for communication protocol TLS 1.3 for all supported Unix platforms.

  • This release includes support for Docker containers.

 

 

 

Resolved Issues and Enhancements

Resolved Issues in this release

The following is a list of issues addressed in this release of SharePlex.

Issue ID Known Issues Source and Target Component/ Feature
SPO-24847 The Silent RDS database setup fails with an error when users run silent ora_setup from the prod/install or VARDIR/data directories. Oracle to Oracle Silent Oracle setup
SPO-24845 The Poster process does not exit even if the execution time elapsed exceeds the time set through the SP_OPO_MAX_OEXN_TIME parameter. Oracle to Oracle Poster
SPO-24840 When multiple host names are associated with a single IP address, SharePlex uses the first host name listed in the /etc/hosts file for disaster recovery procedures instead of updating it with the host name specified by the user in the command. Not applicable Provision Utility
SPO-24819 While replicating data from Oracle to an XML file, a commit is missing in the XML file output. This issue is observed in SharePlex version 10.2. Oracle to an XML file XML file
SPO-24809 When users attempt to run the Provision utility at the target to change the source host name, SharePlex displays an error. Oracle to Oracle Provision utility
SPO-24803 The SharePlex Poster process is discarding all the messages of Batch Insert operations as part of conflict resolution. Oracle to Oracle, Oracle to PostgreSQL Poster
SPO-24801 The SharePlex Reader process is restarting and displaying an 'Invalid Length' error while replicating data with Latin character set having length of more than 4000 bytes. Oracle to PostgreSQL Reader
SPO-24791 SharePlex is replicating incorrect XML data from Oracle to Oracle. Oracle to Oracle XML data
SPO-24784 The object caches of Capture and Poster processes fail to return to their original state after modifying visible or invisible columns through DDL operations on the Source, preventing SharePlex from replicating data to the targeted columns. Oracle to Oracle Capture and Poster
SPO-24747 SharePlex is replicating incorrect data to the target, while replicating XML data that has nested namespaces. Oracle to Oracle XML data
SPO-24743 The SharePlex Poster process stops with a JSON syntax error while performing the DML operation on the LOB data with 'Out Row' secure file. Oracle to Oracle Poster
Herramientas de autoservicio
Base de conocimientos
Notificaciones y alertas
Soporte de productos
Descargas de software
Documentación técnica
Foros de usuarios
Tutoriales en video
Aviso de actualizaciones de páginas web (RSS)
Comuníquese con nosotros
Obtenga asistencia con las licencias
Soporte Técnico
Ver todos
Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación