SharePlex 12.0 - Release Notes

内容导航

Release Notes New Features Resolved Issues and Enhancements Deprecated Platforms and Operating Systems Basic system requirements Source and Target System Requirements and Data Types

Compatibility matrix for supported operating system and target platform Compatibility matrix for operating system and target platform support 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

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.

Operating System	Source	Target	SharePlex versions	On-premises	Cloud
Linux RHEL 7	Link-Local IPV6	Link-Local IPV6	11.0 and above	√	√
Linux RHEL 8	Link-Local IPV6	Link-Local IPV6	11.0 and above	√	√
Linux RHEL 9	Link-Local IPV6	Link-Local IPV6	11.4 and above	√	√
HP UA	Link-Local IPV6	Link-Local IPV6	11.0 and above	√	√
HP IA	Link-Local IPV6	Link-Local IPV6	11.0 and above	√	√
SUN Sparc	Link-Local IPV6	Link-Local IPV6	11.0 and above	√	√
SUN Solaris	Link-Local IPV6	Link-Local IPV6	11.0 and above	√	√
AIX	Link-Local IPV6	Link-Local IPV6	11.0 and above	√	√

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

Notes:

SharePlex 10.2, as a source, and above versions are not interoperable with older versions than 10.2 as a target when using Extended Data Types and TLS 1.3.
For the supported features of SharePlex 11.0 and above , including its version interoperability, see SharePlex Features Interoperable with Versions 11.x and 12.0.

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:

Stop Capture.
sp_ctrl> stop capture
In sp_ctrl on the source system, issue the following command:
sp_ctrl>reset param SP_OCT_TARGET_COMPATIBILITY
Restart Capture.
sp_ctrl>start capture

SharePlex Features Interoperable with Versions 11.x and 12.0

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

SharePlex feature	Supported source database	Supported target database	SharePlex source version	SharePlex target version
Ability to replicate PostgreSQL timestamp to Oracle Date Unidirectional replication	PostgreSQL	Oracle	SharePlex 11.0 and above	SharePlex 11.1 and above
Ability to replicate PostgreSQL timestamp to Oracle Date replication with BDR support	PostgreSQL	Oracle and PostgreSQL	SharePlex 11.1 and above	SharePlex 11.1 and above
Activate config with LSN using user provided LSN¹	PostgreSQL	PostgreSQL, Oracle, SQL Server, Kafka, Snowflake	SharePlex 11.1 and above	SharePlex 11.1 and above
show_last_posted utility¹	PostgreSQL	PostgreSQL	SharePlex 11.1 and above	SharePlex 11.1 and above
High Availability cluster environment with CrunchyData¹	PostgreSQL	PostgreSQL	SharePlex 11.1 and above	SharePlex 11.0 and above
PG2O-O2PG BDR - SharePlex prepared routines - !MostRecentRecord, !LeastRecentRecord, !UpdateUsingKeyOnly, !HostPriority, !UpdateUsingKeyOnly	Oracle and PostgreSQL	Oracle and PostgreSQL	SharePlex 11.0 & Above	SharePlex 11.0 & Above
Case sensitive column names	PostgreSQL	Oracle	SharePlex 11.1 & Above	SharePlex 11.1 and above
PostgreSQL Database as a Service as source	PostgreSQL	PostgreSQL, Oracle, SQL Server, Kafka, Snowflake	SharePlex 11.1 and above	SharePlex 11.0 & Above
Trigger scripts	PostgreSQL	PostgreSQL	SharePlex 11.1 and above	SharePlex 11.1 and above
SharePlex PostgreSQL - config.sql and build_config.sql scripts	PostgreSQL	Not target dependent	SharePlex 11.1 and above	SharePlex 11.1 and above
Implementation of the BOOLEAN data type	PostgreSQL	PostgreSQL, Oracle, Kafka, Snowflake	SharePlex 11.1 & Above	SharePlex 11.1 & Above
Implementation of the TIME data type	PostgreSQL	PostgreSQL, Kafka, Snowflake	SharePlex 11.1 & Above	SharePlex 11.1 & Above
Implementation of the BYTEA data type	PostgreSQL	PostgreSQL, Kafka, Oracle	SharePlex 11.1 & Above	SharePlex 11.1 & Above
Column name > 30 characters³	PostgreSQL, Oracle	PostgreSQL, Oracle, SQL Server, Kafka, Snowflake	SharePlex 11.1 and above	SharePlex 11.1 and above
Kafka Partition key	Oracle	Kafka	SharePlex 11.1 and above	SharePlex 11.1 and above
Long table name	Oracle	PostgreSQL, Oracle, SQL Server, Kafka, Snowflake	SharePlex 11.0 and above	SharePlex 11.1 and above
PostgreSQL Compression Algorithm with Physical replication²	PostgreSQL	PostgreSQL, Oracle, SQL Server, Kafka, Snowflake	SharePlex 11.0 and above	SharePlex 11.0 and above
PostgreSQL Compression Algorithm with Logical replication²	PostgreSQL	PostgreSQL, Oracle, SQL Server, Kafka, Snowflake	SharePlex 11.1 and above	SharePlex 11.1 and above
Compare and Repair commands	PostgreSQL	PostgreSQL	SharePlex 11.4 and above	SharePlex 11.4 and above
Docker Container	Oracle, PostgreSQL	Oracle, PostgreSQL	SharePlex 11.4 and above	SharePlex 11.4 and above
Compare and Repair commands⁴, ⁵	Oracle	PostgreSQL	SharePlex 12.0	SharePlex 12.0
Ignore Port	PostgreSQL	PostgreSQL	SharePlex 12.0	SharePlex 12.0
AVRO format	Oracle	Confluent Kafka	SharePlex 12.0	SharePlex 12.0

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, and 21c, as well as all supported PostgreSQL platforms.

5. The AVRO File format and the Compare and Repair commands (Oracle to PostgreSQL) are not supported on the Windows operating system.

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.

Target databases	Oracle (Source)	PostgreSQL (Source)	PostgreSQL Database as a Service (Source)
Azure Event Hub	√	X	X
File Output	√	X	X
JMS	√	X	X
Kafka	√	√	√
MariaDB	√	X	X
MySQL	√	X	X
Oracle	√	√	√
PostgreSQL	√	√	√
PostgreSQL Database as a Service	√	√	√
Snowflake	√	√	√
SQL Server	√	√	√

Platform Support Matrix

Oracle as source & target	All supported platforms¹
Postgres as source	Linux
Postgres as Target	Linux, Windows
SQL Server	Linux, Windows
My SQL	Linux, Windows
SnowFlake	Linux, Windows
MariaDB	Linux
Kafka	Linux
Event Hub	Linux
JMS	All supported platforms
File	All supported platforms

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

Compatibility Across Operating Systems (Local Installation)

SharePlex allows replication between source and target installations across different operating system platforms. The table below outlines the OS platform combinations that are supported.

Source Platform	Supported Target Platform
Linux	Linux , AIX , Solaris Sparc, Windows
AIX	AIX , Linux
Solaris Sparc	Solaris Sparc , Linux
Windows	Windows , Linux
HP-UX	HP-UX
Solaris Intel	Solaris Intel

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.

Shareplex Platform	Database Platform
Linux	Linux
	Sun Solaris Sparc
	Sun Solaris Intel
AIX	AIX
Solaris Sparc	Solaris Sparc
Solaris intel	Solaris intel
Windows	Windows
HP-UX	HP-UX

Compatibility matrix for supported operating system and target platform

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

Operating Systems	Target platforms
Operating Systems	Oracle	PostgreSQL	Azure Event Hubs	File Output	JMS	Kafka	MariaDB	MySQL	SnowFlake	SQL Server
Versions	12cR1, 12cR2, 18c, 19c, 21c, 23AI*	13.4, 13.6, 14.1, 15.x, 16, 17, EDB 15.x, 16, Fujitsu Enterprise PostgreSQL 15 SP2, AlloyDB Omni 15.5.x	NA	NA	ActiveMQ 5.8, 5.16.7, IBM MQ 8, 9.3	Apache 3.6.1, 3.8, Confluent 7.6	11.4.2	8.0.26	8.38.2	2016, 2017, 2019, 2022
AIX
7.3	√	X	X	√	√	X	X	X	X	X
CentOS
7.x	√	√	√	√	√	√	√	√	√	√
HP-UX
11.31	√	X	X	√	√	X	X	X	X	X
Oracle Linux
9.x	√	√	√	√	√	√	√	√	√	√
8.x	√	√	√	√	√	√	√	√	√	√
7.x	√	√	√	√	√	√	√	√	√	√
Oracle Solaris SPARC
11.4	√	X	X	√	√	X	X	X	X	X
Oracle Solaris x86
11.4	√	X	X	√	√	X	X	X	X	X
RHEL
9.x	√	√	√	√	√	√	√	√	√	√
8.x	√	√	√	√	√	√	√	√	√	√
7.x	√	√	√	√	√	√	√	√	√	√
SUSE SLES
12.x	√	√	√	√	√	√	√	√	√	√
15.x	√	√	√	√	√	√	√	√	√	√
Rocky Linux
8.x	√	√	√	√	√	√	√	√	√	√
Ubuntu
22.04	√	√	√	√	√	√	√	√	√	√
Windows
2022	√	√	X	√	√	X	X	√	√	√
2019	√	√	X	√	√	X	X	√	√	√

*Oracle 23AI is supported only on Oracle Cloud Interface (OCI) platforms.

Compatibility matrix for operating system and target platform support

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

Operating Systems	Target platforms
Operating Systems	Kafka	Oracle	PostgreSQL	SnowFlake	SQL Server
Versions	Apache 3.6.1, 3.8, Confluent 7.6	19c, 21c, 23AI*	13.x, 14.x, 15.x, 16, 17, EDB 15.x, 16, Fujitsu Enterprise PostgreSQL 15 SP2, AlloyDB Omni 15.5.x	8.38.2	2016, 2017, 2019, 2022
AIX
7.3	X	√	X	X	X
CentOS
7.x	√	√	√	√	√
HP-UX
11.31	X	√	X	X	X
Oracle Linux
9.x	√	√	√	√	√
8.x	√	√	√	√	√
7.x	√	√	√	√	√
Oracle Solaris SPARC
11.4	X	√	X	X	X
Oracle Solaris x86
11.4	X	√	X	X	X
RHEL
9.x	√	√	√	√	√
8.x	√	√	√	√	√
7.x	√	√	√	√	√
SuSE SLES
12.x	√	√	√	√	√
15.x	√	√	√	√	√
Rocky Linux
8.x	√	√	√	√	√
Ubuntu
22.04	√	√	√	√	√
Windows
2019	X	√	X	X	X
2022	X	√	X	X	X

*Oracle 23AI is supported only on Oracle Cloud Interface (OCI) platforms.

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

SharePlex 12.0 - Release Notes

Basic system requirements

System

Communications Protocols

SSL/TLS

Internet protocol

Interoperability Between Versions

SharePlex Features Interoperable with Versions 11.x and 12.0

Source and Target System Requirements and Data Types

Supported Source and Target Combinations

Platform Support Matrix

Compatibility Across Operating Systems (Local Installation)

Compatibility Across Operating Systems (Remote Collection and Posting)

Compatibility matrix for supported operating system and target platform

Compatibility matrix for supported operating system and target platform

Compatibility matrix for operating system and target platform support