SharePlex 12.1 - Release Notes

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 1.3 only.

Internet protocol

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

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.4.x/10.x.

Versions with interoperability for Oracle database as a source

The following SharePlex versions are interoperable for Oracle database as a source, including the Compare/Repair feature:

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

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.

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

SharePlex Features Interoperable with Versions 11.x and 12.1

The below table provides a list of features with their SharePlex version compatibility details with supported source and target databases.

Conditions of Support:

1. These features are available only with PostgreSQL physical replication and not with PostgreSQL Database as a Service.

2. Types of PostgreSQL Compression Algorithm:

• pglz is supported with physical replication, where Capture receives data in compressed format and decompresses it.

• pglz and lz4 are supported with logical replication, as decompression is done by the output plugin (pgoutput), and Capture receives data in decompressed format.

3. When a table or column name exceeds 30 characters, Oracle does not log key columns for each update operation in the Redo log, resulting insufficient key columns for SharePlex Poster to use, leading to an Out of Sync condition at the target.

It is recommended to set SP_OCT_USE_SUPP_KEYS = 0, which directs SharePlex to select the appropriate set of key columns for Poster to use.

Note: This may cause additional overhead during the identification of key columns in the SharePlex Read process and at the target during update transactions, potentially resulting in latency at the target.

4. The Compare and Repair commands for Oracle-to-PostgreSQL replication are certified for use with Oracle 18c, 19c, 21c, and 23ai as well as all supported PostgreSQL platforms.

5. The AVRO File format is not supported on the Windows operating system.

6. The Compare and Repair commands for PostgreSQL to Oracle are not supported on the Windows operating system. To refer to the additional conditions of support, see the Compare and Repair commands section in the SharePlex Reference Guide.

7. To refer to the conditions of support, see the Copy/Append commands section in theSharePlex Reference Guide.

8. Values in TIMESTAMP WITH LOCAL TIME ZONE columns at the Oracle source are replicated into the Parquet file without time zone conversion (unlike TIMESTAMP WITH TIME ZONE). If the database local time zone differs from UTC, the corresponding values in the Parquet file may appear different when fetched as UTC.

Source and Target System Requirements and Data Types

This chapter contains the requirements when capturing from various source databases and replicating to supported target databases.

Supported Source and Target Combinations

The following table provides information about the supported source and target database combinations.

Platform Support Matrix

1. Refer to the System Requirements section of the respective platform for detailed platform support information.

Compatibility Across Operating Systems (Remote Collection and Posting)

If users cannot or choose not to install SharePlex directly on the source and/or target server, they can use an intermediate server where SharePlex collects data from the source and/or posts data to the target remotely. In these situations, users must consider the operating system of both the intermediate server running SharePlex and the source and/or target database platform.

Compatibility matrix for supported operating system and target platform

Compatibility matrix for supported operating system and target platform

The table below provides information about supported source and target operating systems and target database versions compatible with Oracle as a source. The statistics in this table apply only to on-premise platforms.

¹Unsupported features on the Windows platform:

• PostgreSQL database as a source

• Compare/Repair commands for Oracle to PostgreSQL replication

• AVRO file format

• MariaDB

The table below provides information about supported source and target operating systems and target database versions compatible with PostgreSQL as a source. The statistics in this table apply only to on-premise platforms.

System Requirements and Conditions of Support When Replicating from Oracle

This chapter contains the requirements when capturing from an Oracle database and replicating to supported target databases.

Pre-requisite: At least the minimum level of supplemental logging must be enabled. Some SharePlex features may require PK/UK supplemental logging to be enabled.