Chatta subito con l'assistenza
Chat con il supporto

SharePlex 10.2.1 - Release Notes

Release Notes

SharePlex® 10.2.1

Release Notes

Revision: 10/27/2023

 

About SharePlex

SharePlex provides high-speed replication from Oracle database to different target databases and messaging containers on major Unix, Linux and Windows operating systems— both on-premises and in the cloud. SharePlex supports a wide variety of configurations to meet different and complex data availability needs.

SharePlex supports reliable Oracle high availability configurations where replication maintains a duplicate database in a different location that is ready for fast, seamless failover and failback in planned or unplanned mode.

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 also includes, at no extra charge, the compare and repair tools that you need to verify the accuracy of a target maintained by replication. These tools not only detect hidden out-of-sync conditions, but they also repair the target to restore parity of your source and target data.

SharePlex value and versatility continues 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

This release supports only Windows Server 2022.

New Features

New Features in this Release

Operating System Support

This release includes support for Windows server 2022.

Resolved Issues and Enhancements

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

Issue ID Description Source and target
SPO-24752 SharePlex Poster process stops with the 'ORA-04016' error when users set the SP_OPO_DEPENDENCY_CHECK parameter to 1 while executing DDL on the target. Oracle to Oracle
SPO-24746 SharePlex Poster stops with the 'ORA-01458: invalid length inside variable character string' error when users add a column with a LONG RAW data type to replication after activating a configuration. Oracle to Oracle
SPO-24744 SharePlex Poster stops with the 'basic_string::_M_create' exception while replicating data from Oracle to Oracle. Oracle to Oracle
SPO-24742 The import and export process is restarting frequently when SharePlex is upgraded from 10.0 to the latest version or 11.0. Oracle to Oracle
SPO-24730 When the SP_OPO_DEPENDENCY_CHECK parameter is set to 1 during DML operations, SharePlex is displaying tables in an out-of-sync manner. Oracle to Oracle
SPO-24727 When users execute a drop partition query using a PL/SQL script, some part of a query is not getting replicated to the target. This issue is observed when the SP_OCT_ALLOW_DP_DDL and SP_OCT_TRUNC_PARTITION_BY_ID parameters are set to 1. Oracle to Oracle
SPO-24707 The conflict resolution routine is failing with the 'ORA-06550 and ORA-00911: invalid character' error while demonstrating the trusted source priority. Oracle to Oracle
SPO-24706 The CDC table is not capturing the bulk data from the source environment. Oracle to Oracle
SPO-24694 When running ora_setup with Oracle client binaries, it fails with the ‘unable to check oracle file’ error message while connecting to ASM. Oracle to Oracle
SPO-24690 Some characters from the replicated data column of the table are missing when replicating data from Oracle Database to flat files. Oracle Database to flat files
SPO-24689 In Oracle to SQL file replication, when users insert 0 (zero) into a number datatype column in the source table, the SQL file is missing a comma and starting single quotes. Oracle to SQL file
SPO-24683 The SharePlex Poster process stops due to the DDL error ORA-01418, causing it to go out of sync with the source. Oracle to Oracle
SPO-24651 When sp_ctrl receives input from a file with more than 510 bytes of memory, SharePlex displays an error when run in interactive mode, and it enters an infinite loop, exhausting system memory. Oracle to Oracle
SPO-24543 Users have found the non-ASCII characters in the event logs/ sp_eventmon due to the issue with SSL connection between export and import. Oracle to Oracle
SPO-24512 The sp_cop process gets stuck when it doesn't receive a response from the client socket during replication. Oracle to Oracle
SPO-24500 Repair parallelism is not working when the character sets of the source and target databases are different, and users see only one active session. Oracle to Oracle
SPO-24498

When users execute the drop table statement using the dbms_scheduler package the capture is getting core dump.

Oracle to Oracle
SPO-24331 SharePlex is displaying the ‘StmtExecute failed with ORA 1455’ error when activating the configuration. Oracle to Oracle
SPO-24316 The SharePlex Capture process stops with SP-OCT01007 even when the database is not using TDE, encrypted tablespaces, or columns during the ora_setup. Oracle to Oracle
SPO-24248 SharePlex is not replicating a table with a materialized view from the source to the target, even when the SP_OCT_AUTOADD_MVIEW parameter is set to 1. Oracle to Oracle
SPO-24157 The Capture process displays the 'Capture: 15006 OCIStmtExecute failed with ORA-1403' error when replicating XML data. Oracle to Oracle
SPO-24084 Users observed the 'Reader missed a marker' issue in the reader logs, causing the Capture queue to grow large. Oracle to Oracle
SPO-24080 SharePlex is unable to scan the event, capture, read, or post logs using the 'show log' command, even with the correct input. It displays the 'File xxx does not exist' message. Oracle to Oracle
SPO-24068 The Compare/Repair process fails with the 'unable to get object id, rc=1455' error when executed on a partitioned table. Oracle to Oracle
SPO-23964 The SharePlex Capture process is not replicating XML data with the namespace tag, considering it as invalid. Oracle to Oracle
SPO-23947 The SharePlex Capture process is failing due to an sp_wallet issue and displaying the 'Capture: Unknown error code 1' error. Oracle to Oracle
SPO-22520 After displaying the 'ORA-00060: deadlock' error, the Poster queue does not start automatically again; it requires manual intervention. Oracle to Oracle
SPO-22429 SharePlex Poster is displaying the 'invalid byte sequence for encoding' error when replicating extended ASCII symbols from an Oracle database to a PostgreSQL database. Oracle to Oracle
SPO-22302 Poster displays the ‘ORA-40441: JSON syntax error' error when replicating the JSON data to the target. Oracle to Oracle

Basic system requirements

This chapter contains the basic system requirements for SharePlex. See also: Source and Target System Requirements and Data Types

System

Before installing SharePlex, ensure that your system meets the minimum hardware and software requirements.

  • SharePlex processes are all 64-bit and can exceed 4 GB.
  • Per process memory of greater than or equal to 256 MB is required. Depending on how you configure SharePlex, there can be one or more of the following processes on a system :
    • Capture
    • Read
    • Export
    • Import
    • Post
  • See the Preinstallation Checklist in the SharePlex Installation Guide for additional system and/or database requirements.

Communications Protocols

SSL/TLS

For TLS connections, SharePlex supports TLS 1.2 (or later) only.

Internet Protocol

SharePlex supports IPv4 and IPv6 internet protocols. The following table shows the operating systems for which SharePlex was tested with IPv6.

Note: If the SP_SYS_HOST_NAME environment variable is set to an IPV6 address on the source system, SharePlex on the target system must be version 9.0 or later.

Operating System

Source

Target

SharePlex Source
and Target versions

On-premises/Cloud

Windows

Link-Local IPV6

Link-Local IPV6

9.0 - 9.0

On-premises

Windows

Link-Local IPV6

Link-Local IPV6

9.0 - 8.6.4

On-premises

Windows

Public IPV6

Public IPV6

9.0 - 9.0

Cloud

Interoperability between versions

Refer to the following guidelines if the system where you are installing SharePlex is in a configuration where one or more other systems will continue to use an older version of SharePlex. An example is when installing or upgrading SharePlex on a target, but the source will continue to use SharePlex 9.2.x.

Versions with full interoperability

The following SharePlex versions are fully interoperable, including the Compare/Repair feature:

  • 9.2.x
  • 9.4.x
  • 10.0.x
  • 10.1.x
  • 10.2.x

To support replication from a higher to a lower version, set the SP_SYS_TARGET_COMPATIBILITY parameter on the source system to the lower SharePlex version. If Capture is running, restart it.

Important: Downgrading from a higher to a lower version of SharePlex is not supported.

Notes:

  • The older version of the SP_SYS_TARGET_COMPATIBILITY parameter, SP_OCT_TARGET_COMPATIBILITY, was deprecated in version 9.0. If your source SharePlex is currently replicating to a lower SharePlex version on the target and you have SP_OCT_TARGET_COMPATIBILITY set to the lower version, SharePlex will continue to use that value after you upgrade to the current version.
  • If you upgrade the target to the current release at a future time, issue a reset for SP_OCT_TARGET_COMPATIBILITY on the source system to remove it from the SharePlex environment. Going forward, SharePlex will use the setting of the new SP_SYS_TARGET_COMPATIBILITY parameter, which defaults to the current version.

To reset SP_OCT_TARGET_COMPATIBILITY

  1. Stop Capture.

    sp_ctrl> stop capture

  2. In sp_ctrl on the source system, issue the following command:

    sp_ctrl>reset param SP_OCT_TARGET_COMPATIBILITY

  3. Restart Capture.

    sp_ctrl>start capture

Strumenti self-service
Knowledge Base
Notifiche e avvisi
Supporto prodotti
Download di software
Documentazione tecnica
Forum utente
Esercitazioni video
Feed RSS
Contatti
Richiedi assistenza sulle licenze
Supporto tecnico
Visualizza tutto
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione