SharePlex® 11.0
Release Notes
Revision: 8/5/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 |
| 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.
SharePlex 11 requires new license keys.
License keys issued for versions prior to 11.0 will be incompatible with SharePlex 11.x. Existing customers should obtain a new license key before installing and/or upgrading to SharePlex 11.x. To obtain a new license key, please refer to the Licensing Assistance page on the Support Portal.
SharePlex 11.0 is available for installation on Linux and Unix platforms.
An 11.x version of SharePlex that can be natively installed on Windows will be delivered in the future. Customers who wish to replicate to and from sources and targets that run on Windows can either use the 10.x version of SharePlex or use remote replication, where the SharePlex software runs on a Linux server. Please see the System Requirements sections for details on supported source/target combinations with remote replication.
| Document Version | Date | Change History |
|---|---|---|
| 2 | 21st Feb 2023 | Added SPSQL- 3596 and SPSQL- 3255 issues in the Known Issues section. |
| 3 | 21st March 2023 | Added AIX 7.3 as the supported operating system. |
| 4 | 29th March 2023 |
|
| 5 | 4th April 2023 |
|
| 6 | 6th April 2023 | Added the version interoperability-related note for Extended Data Types and TLS 1.3. |
| 7 | 4th December 2023 |
|
| 8 | 2nd February 2024 | Removed the SPO-19872 issue from the Resolved Issues section. |
| 9 | 28th February 2024 | Updated the licensing related information in the Licensing section. |
| 10 | 5th March 2024 | Added an important note regarding OLS policy configuration in the Conditions of Support - OLS section. |
| 11 | 6th May 2024 |
|
PostgreSQL source capture is now supported. This version was designed to support the following major features:
Replication from PostgreSQL to PostgreSQL, Oracle, SQL Server, Kafka, and Snowflake.
Peer-to-peer replication with Conflict Resolution, between PostgreSQL and PostgreSQL, to enable the creation of enterprise grade HA, DR, and Horizontal Scaling PostgreSQL architectures. For detailed information, see the Configure PostgreSQL to PostgreSQL Replication section in the SharePlex Admin Guide.
Note: A PostgreSQL database set up in High Availability mode is not supported.
Peer-to-peer replication, with Conflict Resolution, between PostgreSQL and Oracle, to de-risk and facilitate complex Oracle to PostgreSQL migration and refactoring projects. For detailed information, see the Configure PostgreSQL to Oracle Replication section in the SharePlex Admin Guide.
SharePlex Horizontal and Vertical Partitioning. For detailed information, see the Configure Partitioned Replication section in the SharePlex Admin Guide.
Snowflake is now a supported target for both Oracle and PostgreSQL sources. Please see the appropriate sections for specific conditions of support.
Upgraded the TLS version to 1.3.
The following is a list of issues addressed in this release of SharePlex.
| Issue ID | Description | Source and target | Component/ Feature |
|---|---|---|---|
| SPSQL-3043 | Poster is getting core dumped while updating the qa_raw datatype in Oracle to MS SQL replication. | Oracle to MS SQL | Poster |
| SPSQL-2997 | SharePlex Poster is displaying an ODBC communication link failure error while replicating data from Oracle to Azure SQL Server. | Oracle to Azure SQL Server | Poster |
| SPO-24690 | SharePlex replicates an incorrect number of characters in SharePlex SQL file while replicating data from Oracle to a flat file. | Oracle to flat file | SQL file |
| SPO-24689 | When users insert 0 (zero number) in the number data type column of the source table, comma and starting single quotes go missing in the SQL file. | oracle to oracle and oracle to SQL file | Number data type |
| SPO-22799 |
While running the pg_setup utility, if users encounter the "file not found" problem on a Linux system , even though the file is present. This issue occurs because the SharePlex has upgraded the OpenSSL library and the PostgreSQL ODBC drivers continue to function with the older version of OpenSSL. For example: The symbolic link libcrypto.so.1.0.0 will point to libcrypto.so.1.1 and the symbolic link libssl.so.1.0.0 will point to libssl.so.1.1. Commands: ln -s libcrypto.so.1.1 libcrypto.so.1.0.0 ln -s libssl.so.1.1 libssl.so.1.0.0 |
Oracle to PostgreSQL | PostgreSQL |
| SPO-24500 | SharePlex is creating only one active parallel session when the source and target database character sets are different. | Oracle to Oracle | Database character sets |
| SPO-24068/ SPO-24331 | SharePlex is displaying an error and is unable to activate the config file when the config file has an Oracle partitioned table. This problem also occurs when the user runs Compare/Repair on an Oracle partitioned table. | Oracle to Oracle | Compare/Repair |
| SPO-24316 | SharePlex Capture is displaying the "TDE error log" error even when the database is not using the TDE and there are no encrypted tablespaces or columns. | Oracle to Oracle | Capture |
| SPO-24248 | When replicating a materialized view from the source to the target, SharePlex does not create the table in the target. | Oracle to Oracle | Materialized view |
| SPO-24157 | The SharePlex Capture process cores when replicating XML data from a source to a target because it interprets repeated tags as duplicate tags. | Oracle to Oracle | Capture |
| SPO-24084 | The SharePlex Reader process stopped due to a missed marker. | Oracle to Oracle | Reader |
| SPO-24080 | When users run the show log capture, read, or poster commands for the data source, SharePlex fails to generate the output. | Oracle to Oracle | capture, read, and poster |
| SPO-23964 | SharePlex is replicating incomplete XML data from source to target. | Oracle to Oracle | XML data |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center
