Chatta subito con l'assistenza
Chat con il supporto

SharePlex 12.0 - 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.

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:

  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.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 LSN1 PostgreSQL PostgreSQL, Oracle, SQL Server, Kafka, Snowflake SharePlex 11.1 and above SharePlex 11.1 and above
show_last_posted utility1 PostgreSQL PostgreSQL SharePlex 11.1 and above SharePlex 11.1 and above
High Availability cluster environment with CrunchyData1 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 characters3 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 replication2

 PostgreSQL PostgreSQL, Oracle, SQL Server, Kafka, Snowflake SharePlex 11.0 and above SharePlex 11.0 and above
PostgreSQL Compression Algorithm with Logical replication2 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 commands4, 5 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 platforms1
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

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

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione