SharePlex® 11.4
Release Notes
Revision: 8/13/2024
| Revision History |
| New Features |
| Resolved Issues and Enhancements |
| Deprecated Platforms and Operating Systems |
| Basic system requirements |
| Source and Target System Requirements and Data Types |
| System Requirements and Conditions of Support When Replicating from Oracle |
| System Requirements and Conditions of Support When Replicating from PostgreSQL |
| System Requirements and Conditions of Support When Replicating from PostgreSQL Database as a Service |
| Known issues |
| Product Licensing |
| Third Party Contributions |
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.
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.
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
| 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 |
|
| 4 | 19th June 2024 |
|
| 5 | 25th June 2024 |
|
| 6 | 22nd July 2024 |
|
| 7 | 13th August 2024 | Added LATIN1 as a supported character set for PostgreSQL-to-PostgreSQL replication, with a note. |
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.
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 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
