Chat now with support
Chat mit Support

SharePlex 11.4 - Release Notes

System Requirements and Conditions of Support When Replicating from PostgreSQL

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

PostgreSQL source basics

This section contains the requirements for a PostgreSQL database as a source when capturing from a PostgreSQL database and replicating to supported target databases.

Supported operating systems

The following operating systems are supported for capture from a supported PostgreSQL database and replication to supported target database. For a list of supported source and target databases for PostgreSQL capture, see Supported Source and Target Combinations.

SharePlex supports only the 64-bit version of the listed operating systems.

Supported operating systems via native installation

  • RHEL 7.x, 8.x, and 9.x

  • Rocky Linux 8.x

  • Oracle Linux 7.x and 8.x

Supported versions and ODBC requirements

  • PostgreSQL 13.x, 14.x, 15.x, 16

  • Enterprise Database (EDB) 15.x, 16

  • Fujitsu Enterprise PostgreSQL 15 SP2

  • AlloyDB Omni 15.5.x*

*Note: To use the AlloyDB Omni 15.5.x database for data replication using SharePlex, contact the Quest Support team at www.quest.com/contact.

ODBC driver requirement:

ODBC drivers for Community Edition: postgresql13-odbc-13.02.0000, postgresql14-odbc-13.02.0000,postgresql15-odbc-16.00.0000, and postgresql16-odbc-16.00.0000

ODBC drivers for Enterprise Edition (EDB): edb-odbc-13.02.0000 and edb-odbc-16.00.0000.01

Supported cloud platforms

Amazon Web Services:

Amazon EC2 (IaaS) Virtual Machine

Microsoft Azure:

Azure Virtual Machine (IaaS)

Google Cloud Platform:

  • Cloud SQL for PostgreSQL

  • AlloyDB for PostgreSQL*

*Note: To use the Google AlloyDB for PostgreSQL Cloud platform for data replication using SharePlex, contact the Quest Support team at www.quest.com/contact.

PostgreSQL source basic conditions of support

Supported / non-supported SharePlex features for PostgreSQL to Oracle and open targets replication

The following table shows whether specific SharePlex features are supported for replication from PostgreSQL to Oracle and open targets .

SharePlex feature Supported targets
reconcile command (target instantiation) Oracle, PostgreSQL
compare/compare using and repair/repair using commands Not supported
copy/copy using and append/append using commands Not supported
Hash horizontally partitioned replication PostgreSQL
Column-based horizontally partitioned replication PostgreSQL
Vertically partitioned replication PostgreSQL, Oracle
Column mapping PostgreSQL, Oracle, SQL Server, Kafka, Snowflake
Key definition PostgreSQL, Oracle
Build configuration with scripts Not supported
Named queues PostgreSQL, Oracle, SQL Server, Kafka, Snowflake
Commit Reduction (feature of Post Enhanced Performance) PostgreSQL, Oracle, SQL Server, Kafka, Snowflake
Dependency Checking (feature of Post Enhanced Performance) Not supported
Transformation Not supported
Conflict resolution

PostgreSQL, Oracle

Peer-to-peer replication (bi-directional) PostgreSQL, Oracle
Consolidated replication (many to one) PostgreSQL, Oracle, SQL Server, Kafka, Snowflake
Broadcast replication (one to many) PostgreSQL, Oracle, SQL Server, Kafka, Snowflake
High availability replication (active/passive bi-directional) Not supported
Change tracking target (CDC) Not supported
Data encryption Not supported
Data compression Not supported
SSH PostgreSQL, Oracle, SQL Server, Kafka, Snowflake
auth_hosts file Not supported
Monitoring scripts Not supported
SNMP monitoring Not supported
Continue posting on error (SP_OPX_CONT_ON_ERR) PostgreSQL, SQL Server, Kafka, Snowflake
Suspend on out of sync errors (SP_OPX_OUT_OF_SYNC_SUSPEND) PostgreSQL, SQL Server, Kafka, Snowflake
Reduced key (SP_OPX_REDUCED_KEY) PostgreSQL, SQL Server, Kafka, Snowflake
Logical Transaction Rollback on out-of-sync transactions Not supported
Tables without key* PostgreSQL, Oracle, SQL Server, Kafka, Snowflake

* Limitation: Data inconsistency is likely to occur in replication or compare-repair processes when SharePlex replication involves tables containing non-key columns with duplicate data.

Supported and non-supported key features for physical and logical slots

The table below presents information on the metrics that are supported and not supported for physical and logical slots in on-premises and PostgreSQL Database as a Service environments.

Note: SharePlex supports logical replication with pgoutput plugin only.

SharePlex Features PostgreSQL On-Prem/Cloud VM/EDB (Enterprise Database) PGDB as a Service AWS- RDS and Aurora, Azure Flexi server
Physical Replication Logical Replication (pgoutput plugin) Logical Replication (pgoutput plugin)
Activate with LSN Supported Not supported Not supported
HA Cluster Replication with failover Applicable with On-prem PostgreSQL database CrunchyData* Not supported Applicable only with Azure Flexi server using the pg_failover_slots extension; it is not supported with AWS-RDS and Aurora.
Horizontal and Vertical Partitioning Supported Supported Supported
Utilities and Commands Supported Supported Supported
Database level Table Partitioning Supported Supported Supported
Bi-Directional Replication Supported Supported Supported
DDL Support Not supported Not supported Not supported
Compare and Repair Not supported Not supported Not supported
Replication Performance No Lag Minimal Lag Minimal Lag
Insert using PostgreSQL Copy command Not supported Not supported Not supported

* The HA Cluster Replication with Failover feature is not supported with PostgreSQL Enterprise Database (EDB).

PostgreSQL to Kafka replication

SharePlex supports replication from PostgreSQL to Kafka, according to the details below.

Supported operating systems

Supported operating systems via native installation:

  • RHEL 7.x, 8.x, and 9.x

  • Rocky Linux 8.x

  • Oracle Linux 7.x and 8.x

Remote replication from the following operating systems is supported:

  • RHEL 7.x, 8.x, and 9.x

  • Rocky Linux 8.x

  • Oracle Linux 7.x and 8.x

Note: SharePlex supports only the 64-bit version of the listed operating systems.

Supported Kafka targets

Apache Kafka 0.8.x, 0.9.x, 0.10.x, 0.11.x, 1.0.x, 1.1.x, 2.0.x, 2.1.0, 2.3.1, 2.5.0, 3.0, 3.3, and 3.6.1

We test and reproduce issues against:

  • Apache Kafka

  • Confluent Kafka

NOTE: If you would like to use a different vendor who provides their own Kafka distribution or provides a Kafka compliant interface, you are welcome to do so. From a support perspective, our support and development teams will share any Kafka broker errors that SharePlex receives and also ensure SharePlex itself is working properly to capture data, the target configuration formats in SharePlex are correct, and the SharePlex poster is posting or attempting to post according to the Kafka versions under support. If there are SharePlex issues with Kafka support that can be reproduced on Apache Kafka or otherwise demonstrated to be definitely associated with SharePlex, our team will address those as standard Kafka issues.

Supported formats

  • XML format
  • JSON format

Supported DML operations

SharePlex supports DML operations on tables. DML can be replicated from a PostgreSQL source to a kafka target.

Tables

SharePlex supports the following DML operations on tables:

  • Singular and bulk operation - Insert
  • Singular and bulk operation - Update with key(s)/ non key(s)
  • Singular and bulk operation - Delete with key(s)
  • Above operations with rollback/savepoint

Supported operations and objects for DDL replication

Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL source to a Kafka target. It only supports tables as objects for data replication.

PostgreSQL to Oracle replication

SharePlex supports replication from PostgreSQL to Oracle, according to the details below.

Supported target operating systems

The following operating systems are supported from PostgreSQL to Oracle database. SharePlex supports only the 64-bit version of the listed operating systems.

Native SharePlex installation is supported on the below platforms:

  • AIX 7.1, 7.2, and 7.3

  • Oracle Linux 7.x and 8.x

  • RHEL 7.x, 8.x, and 9.x

  • CentOS Linux 7.x

  • Oracle Solaris SPARC 11

  • SuSE SLES 12.x and 15.x

  • HP-UX 11.31 Itanium

  • Rocky Linux 8.x

Remote replication from the following operating systems is supported:

  • AIX 7.1, 7.2, and 7.3

  • Oracle Linux 7.x and 8.x

  • RHEL 7.x, 8.x, and 9.x

  • CentOS Linux 7.x

  • Oracle Solaris SPARC 11

  • Rocky Linux 8.x

  • SuSE SLES 12.x and 15.x

  • HP-UX 11.31 Itanium

Supported target operating systems via remote replication:

All platforms listed above, plus Windows Server 2016 and 2019, are supported via remote replication.

Supported target database versions

Oracle 19c

Supported target cloud platforms

Oracle Cloud Infrastructure

  • Oracle Exadata Cloud Service (ExaCS)
  • Oracle Exadata Cloud@Customer (ExaCC)
  • Oracle Database Cloud Service (DBCS)
  • Oracle Compute (IaaS) Virtual Machines and Bare Metal

Amazon Web Services

  • Amazon RDS for Oracle
  • Amazon EC2 (IaaS) Virtual Machine

Microsoft Azure

Azure Virtual Machine (IaaS)

Supported characterset

UTF 8

Supported data types

SharePlex supports the following data types for replication from PostgreSQL to Oracle:

PostgreSQL Oracle
INT NUMBER / INT
REAL BINARY_FLOAT / NUMBER
SMALLINT NUMBER
BIGINT NUMBER
NUMERIC NUMBER
DOUBLE PRECISION BINARY_DOUBLE / NUMBER
CHAR(1:2000) CHAR(n)
CHAR(2001:) CLOB
CHAR(1:1000) NCHAR(n)
VARCHAR(1:4000) VARCHAR2(n)
VARCHAR(4001:) CLOB
VARCHAR CLOB
VARCHAR(1:2000) NVARCHAR2(n)
TEXT CLOB / NCLOB
DATE DATE
TIMESTAMP(0) DATE
TIMESTAMP(0) TIMESTAMP(0)
TIMESTAMP TIMESTAMP / TIMESTAMP [(fractional_seconds_precision)] WITH LOCAL TIME ZONE
TIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE
BOOLEAN CHAR (1)*
BYTEA BLOB

*NOTE: For PostgreSQL Physical or Logical replication, BOOLEAN values will be replicated as 1/0 in a CHAR(1) column on the Oracle target.

SharePlex supports the following PostgreSQL data types for replication from PostgreSQL to Oracle when conflict resolution is configured:

  • VARCHAR

  • SMALLINT

  • INT

  • BIGINT

  • NUMERIC

  • DATE

  • CHAR

  • TIMESTAMP(0)

  • TIMESTAMP

  • TIMESTAMP WITH THE TIME ZONE

  • TIME

  • TIME WITH TIME ZONE

  • BOOLEAN

Supported DML operations

SharePlex supports DML operations on tables. DML can be replicated from a PostgreSQL source to an Oracle target.

Tables

SharePlex supports the following DML operations on tables:

  • Singular and bulk operation - Insert

  • Singular and bulk operation - Update with key(s)/ non key(s)

  • Singular and bulk operation - Delete with key(s)

  • Above operations with rollback/savepoint

The target table must support the column types that are being replicated from the source PostgreSQL table.

Supported operations and objects for DDL replication

Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL source to an Oracle target. It only supports tables as objects for data replication.

PostgreSQL to PostgreSQL replication

SharePlex supports replication from PostgreSQL to PostgreSQL , according to the details below.

Supported target operating systems

Native SharePlex installation is supported on the following platforms:

  • RHEL 7.x, 8.x, and 9.x

  • Rocky Linux 8.x

  • Oracle Linux 7.x and 8.x

Remote replication from the following operating systems is supported:

  • RHEL 7.x, 8.x, and 9.x

  • Rocky Linux 8.x

  • Oracle Linux 7.x and 8.x

Supported target operating systems via remote replication:

  • AIX 7.1, 7.2, and 7.3

  • CentOS Linux 7.x

  • HP-UX 11.31 Itanium

  • Oracle Linux 7.x and 8.x

  • Oracle Solaris SPARC 11.4

  • Oracle Solaris x86 11.4

  • RHEL 7.x, 8.x, and 9.x

  • Rocky Linux 8.x

  • SuSE SLES 12.x and 15.x

  • Windows Server 2016 and 2019

Note: SharePlex supports only the 64-bit version of the listed operating systems.

Supported target versions and ODBC requirements

  • PostgreSQL 13.x, 14.x, 15.x, 16

  • Enterprise Database (EDB) 15.x, 16

  • Fujitsu Enterprise PostgreSQL 15 SP2

  • AlloyDB Omni 15.5.x

Note: To use the AlloyDB Omni 15.5.x database for data replication using SharePlex, contact the Quest Support team at www.quest.com/contact.

ODBC driver requirement:

ODBC drivers for Community Edition: postgresql13-odbc-13.02.0000, postgresql14-odbc-13.02.0000,postgresql15-odbc-16.00.0000, and postgresql16-odbc-16.00.0000

ODBC drivers for Enterprise Edition (EDB): edb-odbc-13.02.0000 and edb-odbc-16.00.0000.01

Supported target cloud platforms

Amazon Web Services:

  • Amazon EC2 (IaaS) Virtual Machine

  • Amazon RDS for PostgreSQL

  • Amazon Aurora

Microsoft Azure:

  • Azure Virtual Machine (IaaS)

  • Azure DBaaS

Google Cloud Platform:

  • Cloud SQL for PostgreSQL

  • AlloyDB for PostgreSQL*

*Note: To use the Google AlloyDB for PostgreSQL Cloud platform for data replication using SharePlex, contact the Quest Support team at www.quest.com/contact.

Supported character sets

  • UTF 8

  • LATIN1

Note: These character sets are supported only if the same character set is present on both the source and target. For example: Latin1 → Latin1 and UTF8 → UTF8.

Supported data types

SharePlex PostgreSQL supports the following data types for replication from PostgreSQL to PostgreSQL:

  • CHAR
  • VARCHAR
  • TEXT
  • SMALLINT
  • INT
  • BIGINT
  • NUMERIC
  • REAL
  • DOUBLE PRECISION
  • DATE
  • TIMESTAMP (0)
  • TIMESTAMP
  • TIMESTAMP WITH TIME ZONE
  • BOOLEAN
  • BYTEA
  • TIME
  • TIME WITH TIME ZONE
  • JSON
  • JSONB

Limitations:

  • The JSON & JSONB data types are supported only with logical replication.

  • Columns with the JSON and JSONB data types are not supported when defining a unique key.

  • Partition keys defined on JSON and JSONB data type columns are not supported for replicating partitioned table data.

  • A table containing columns with data types such as VARCHAR > 2k, VARCHAR without specified length, TEXT, BYTEA, JSON, and JSONB, without a defined key, and where basic data type columns are non-key columns with duplicate data across multiple rows, can result in data inconsistency during the Repair process.

Supported DML operations

SharePlex supports DML operations on tables. DML can be replicated from a PostgreSQL source to a PostgreSQL target.

Tables

SharePlex supports the following DML operations on tables:

  • Singular and bulk operation - Insert
  • Singular and bulk operation - Update with key(s)/ non key(s)
  • Singular and bulk operation - Delete with key(s)
  • Above operations with rollback/savepoint

The target table must support the column types that are being replicated from the source PostgreSQL table.

Supported operations and objects for DDL replication

Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL source to a PostgreSQL target. It only supports tables as objects for data replication.

PostgreSQL to Snowflake replication

SharePlex supports replication from PostgreSQL to Snowflake, according to the details below.

Supported operating systems

The following operating systems are supported for capture from a PostgreSQL database and replication to a Snowflake target database. SharePlex Snowflake supports only the 64-bit version of the listed operating systems.

SharePlex replicates remotely to Snowflake. Replication from the following operating systems is supported:

  • RHEL 7.x, 8.x, and 9.x

  • Oracle Linux 7.x and 8.x

Supported target versions and ODBC requirements

Snowflake 6.31 Enterprise, Community version and Snowflake 8.1.0

ODBC driver requirement: Snowflake 3.1.4 and above

Supported target cloud platforms

Microsoft Azure

Supported data types

SharePlex supports the following data types for replication from PostgreSQL to Snowflake:

PostgreSQL Snowflake
TEXT TEXT
INT INT,INTEGER,NUMBER
CHAR(1:2000) VARCHAR(n)
CHAR(2001:) VARCHAR(n)
CHAR(n) CHAR(n)
VARCHAR(1:4000) VARCHAR(n)
VARCHAR(4001:) VARCHAR(n)
VARCHAR VARCHAR(n)
REAL REAL
SMALLINT SMALLINT
BIGINT BIGINT
NUMERIC (whole number without fraction) NUMERIC, DECIMAL
NUMERIC (fractional number) FLOAT
DATE DATE
DOUBLE PRECISION DOUBLE PRECISION
TIMESTAMP TIMESTAMP
TIMESTAMP_TZ TIMESTAMP_TZ
BOOLEAN BOOLEAN
TIME TIME
Conditions of support

  • Char(n) data type - In PostgreSQL, Char(n) is a fixed-size data type. If you insert char data with a length less than "n" into the "Char(n)" column, the remaining slots (n - length) are padded with space to occupy the complete "n" memory positions. Snowflake uses  VARCHAR(n) for char storage since Snowflake lacks a comparable fixed-length character data type and only saves char data up to its length. Live replication will ensure that char column data is correctly copied. However, if users are manually inserting data into Snowflake for the equivalent of a Char(n) PostgreSQL column, then the user will need to handle padding as well to occupy the full "n" length so that data will be in sync in both the source and target database.

  • Text data types - Snowflake Text data types have size limitation of 8 MB, so PostgreSQL’s TEXT data type replication will be restricted to max 8 MB size limit of equivalent counterpart. Refer table below.

PostgreSQL Data type Max Size Snowflake Data type Max Size
TEXT unlimited TEXT 8 MB of unicode chars

Supported operations and objects for DML replication

SharePlex supports DML operations on tables, with some conditions. DML can be replicated from an PostgreSQL source to a Snowflake target.

Tables

SharePlex supports the following DML operations on tables when replicating data from an PostgreSQL source to the Snowflake target:

  • Singular and bulk operation - Insert with key(s)/ non key(s)

  • Singular and bulk operation - Update with key(s)/ non key(s)

  • Singular and bulk operation - Delete with key(s)/ non key(s)

 

 

Limitations:

The following DML operations related limitations are observed while replicating data from PostgreSQL to Snowflake:

  • Slowness while performing DML operations

    • Single Insert: Frequent commits and rollbacks can cause slowness in replication.

    • Batch Inserts: Insert with advance data types [target Snowflake data types: TEXT and BINARY] can cause significant slowness in replication for data with plain text or binary JSON and XML.

    • Single Update and Delete : Frequent commits and rollbacks can cause slowness.

For additional information, see Supported Operations and Objects for DML Replication.

Supported operations and objects for DDL replication

Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL source to a Snowflake target. It only supports tables as objects for data replication.

PostgreSQL to SQL Server replication

SharePlex supports replication from PostgreSQL to SQL Server, according to the details below.

Supported target operating systems

The following operating systems are supported for SQL Server database. SharePlex supports only the 64-bit version of the listed operating systems.

Supported operating systems via native installation:

  • RHEL 7.x and 8.x

  • Rocky Linux 8.x

  • Oracle Linux 7.x and 8.x

Remote replication from the following operating systems is supported:

  • RHEL 7.x, 8.x, and 9.x

  • Rocky Linux 8.x

  • Oracle Linux 7.x and 8.x

Supported target operating systems via remote replication:

All platforms listed above, plus Windows Server 2016 and 2019, are supported via remote replication.

Supported target versions and ODBC requirements

SQL Server 2012, 2014, 2016, 2017, 2019, and 2022

Note: SQL Server 2012, 2014, and 2016 databases hosted on Windows servers are compatible with Windows Server 2016 and above.

ODBC driver requirement: ODBC 17.10.1.1-1 and 18.3.2.1-1

Supported target cloud platforms

Amazon Web Services

Amazon EC2 (IaaS) Virtual Machine

Microsoft Azure

  • Azure Virtual Machine (IaaS)

  • Azure SQL Database

  • Azure SQL Managed Instance

Supported data types

SharePlex supports the following data types for replication from PostgreSQL to SQL Server:

PostgreSQL SQL Server
INT INT
REAL REAL
SMALLINT SMALLINT
BIGINT BIGINT
NUMERIC / DECIMAL NUMERIC / DECIMAL
DOUBLE PRECISION FLOAT
CHAR (1:8000) CHAR(n)
CHAR (8001:) VARCHAR (MAX)
CHAR (1:2000) NCHAR (n)
VARCHAR (1:8000) VARCHAR (n)
VARCHAR (8001:) VARCHAR (MAX)
VARCHAR(1:2000) NVARCHAR (n)
VARCHAR VARCHAR (MAX) / TEXT
TEXT TEXT / NTEXT / VARCHAR(MAX)
DATE DATE
TIMESTAMP (p) DATETIME2 (p)
TIMESTAMP DATETIME2
TIMESTAMP WITH TIME ZONE DATETIMEOFFSET

Supported DML operations

SharePlex supports DML operations on tables. DML can be replicated from a PostgreSQL source to an SQL Server target.

Tables

SharePlex supports the following DML operations on tables:

  • Singular and bulk operation - Insert
  • Singular and bulk operation - Update with key(s)/ non key(s)
  • Singular and bulk operation - Delete with key(s)
  • Above operations with rollback/savepoint

The target table must support the column types that are being replicated from the source PostgreSQL table.

Supported operations and objects for DDL replication

Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL source to an SQL Server target. It only supports tables as objects for data replication.

System Requirements and Conditions of Support When Replicating from PostgreSQL Database as a Service

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

PostgreSQL Database as a Service as source and target basics

SharePlex supports replication for the PostgreSQL Database as a Service as source, according to the details below.

Supported operating systems

Supported source operating systems via remote capture:

  • RHEL 7.x, 8.x, and 9.x

  • Rocky Linux 8.x

  • Oracle Linux 7.x and 8.x

Supported target operating systems remote replication:

  • RHEL 7.x, 8.x, and 9.x

  • Rocky Linux 8.x

  • Oracle Linux 7.x and 8.x

Note: SharePlex supports only the 64-bit version of the listed operating systems.

Supported cloud platforms

Amazon Web Services:

  • Amazon EC2 (IaaS) Virtual Machine

  • Amazon RDS for PostgreSQL

  • Amazon Aurora

  • Microsoft Azure:

    • Azure Virtual Machine (IaaS)

    • Azure Database for PostgreSQL Flexible Server

    Google Cloud Platform:

    Cloud SQL for PostgreSQL

    Note: PostgreSQL Database as a Service supports only logical replication.

    Supported PostgreSQL versions

    PostgreSQL 13.x , 14.x, 15.x, 16

    ODBC driver requirement

    ODBC drivers for Community Edition: postgresql13-odbc-13.02.0000, postgresql14-odbc-13.02.0000,postgresql15-odbc-16.00.0000, and postgresql16-odbc-16.00.0000

    Supported data types

    • CHAR

    • VARCHAR

    • SMALLINT

    • INT

    • BIGINT

    • NUMERIC

    • REAL

    • DOUBLE PRECISION

    • DATE

    • TIMESTAMP [p]

    • TIMESTAMP

    • TIMESTAMP [p] [WITH TIME ZONE]

    • TEXT

    Supported DML operations

    SharePlex supports DML operations on tables. DML can be replicated from a PostgreSQL Database as a Service as source to a PostgreSQL target.

    Tables

    SharePlex supports the following DML operations on tables:

    • Singular and bulk operation - Insert
    • Singular and bulk operation - Update with key(s)/ non key(s)
    • Singular and bulk operation - Delete with key(s)
    • Above operations with rollback/savepoint

    The target table must support the column types that are being replicated from the source PostgreSQL table.

    Supported operations and objects for DDL replication

    Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL Database as a Service as source to a PostgreSQL target. It only supports tables as objects for data replication.

    PostgreSQL Database as a Service to Kafka replication

    SharePlex supports replication from PostgreSQL Database as a Service to Kafka, according to the details below.

    Supported operating systems

    Supported source operating systems via remote capture:

    • RHEL 7.x, 8.x, and 9.x

    • Rocky Linux 8.x

    • Oracle Linux 7.x and 8.x

    Remote replication from the following operating systems is supported:

    • RHEL 7.x, 8.x, and 9.x

    • Rocky Linux 8.x

    • Oracle Linux 7.x and 8.x

    Note: SharePlex supports only the 64-bit version of the listed operating systems.

    Supported Kafka targets

    Apache Kafka 0.8.x, 0.9.x, 0.10.x, 0.11.x, 1.0.x, 1.1.x, 2.0.x, 2.1.0, 2.3.1, 2.5.0, 3.0, 3.3, and 3.6.1

    We test and reproduce issues against:

    • Apache Kafka

    • Confluent Kafka

    NOTE: If you would like to use a different vendor who provides their own Kafka distribution or provides a Kafka compliant interface, you are welcome to do so. From a support perspective, our support and development teams will share any Kafka broker errors that SharePlex receives and also ensure SharePlex itself is working properly to capture data, the target configuration formats in SharePlex are correct, and the SharePlex poster is posting or attempting to post according to the Kafka versions under support. If there are SharePlex issues with Kafka support that can be reproduced on Apache Kafka or otherwise demonstrated to be definitely associated with SharePlex, our team will address those as standard Kafka issues.

    Supported formats

    • XML format
    • JSON format

    Supported DML operations

    SharePlex supports DML operations on tables. DML can be replicated from a PostgreSQL Database as a Service as source to a Kafka target.

    Tables

    SharePlex supports the following DML operations on tables:

    • Singular and bulk operation - Insert
    • Singular and bulk operation - Update with key(s)/ non key(s)
    • Singular and bulk operation - Delete with key(s)
    • Above operations with rollback/savepoint

    Supported operations and objects for DDL replication

    SharePlex does not support DDL operations and objects when replicating data from a PostgreSQL Database as a Service as source to a Kafka target.

    PostgreSQL Database as a Service to Oracle replication

    SharePlex supports replication from PostgreSQL Database as a Service to Oracle, according to the details below.

    Supported target operating systems

    The following operating systems are supported from PostgreSQL Database as a Service to Oracle database. SharePlex supports only the 64-bit version of the listed operating systems.

    Native SharePlex installation is supported on the below platforms:

    • AIX 7.1, 7.2, and 7.3

    • Oracle Linux 7.x and 8.x

    • RHEL 7.x, 8.x, and 9.x

    • CentOS Linux 7.x

    • Oracle Solaris SPARC 11

    • Rocky Linux 8.x

    • SuSE SLES 12.x and 15.x

    • HP-UX 11.31 Itanium

    Remote replication from the following operating systems is supported:

    • AIX 7.1, 7.2, and 7.3

    • Oracle Linux 7.x and 8.x

    • RHEL 7.x, 8.x, and 9.x

    • CentOS Linux 7.x

    • Oracle Solaris SPARC 11

    • Rocky Linux 8.x

    • SuSE SLES 12.x and 15.x

    • HP-UX 11.31 Itanium

    Supported target operating systems via remote replication:

    All platforms listed above, plus Windows Server 2016 and 2019, are supported via remote replication.

    Supported target database versions

    Oracle 19c

    Supported target cloud platforms

    Oracle Cloud Infrastructure

    • Oracle Exadata Cloud Service (ExaCS)
    • Oracle Exadata Cloud@Customer (ExaCC)
    • Oracle Database Cloud Service (DBCS)
    • Oracle Compute (IaaS) Virtual Machines and Bare Metal

    Amazon Web Services

    • Amazon RDS for Oracle
    • Amazon EC2 (IaaS) Virtual Machine

    Microsoft Azure

    Azure Virtual Machine (IaaS)

    Supported characterset

    UTF 8

    Supported data types

    SharePlex supports the following data types for replication from PostgreSQL Database as a Service to Oracle:

    PostgreSQL Oracle
    INT NUMBER / INT
    REAL BINARY_FLOAT / NUMBER
    SMALLINT NUMBER
    BIGINT NUMBER
    NUMERIC NUMBER
    DOUBLE PRECISION BINARY_DOUBLE / NUMBER
    CHAR(1:2000) CHAR(n)
    CHAR(2001:) CLOB
    CHAR(1:1000) NCHAR(n)
    VARCHAR(1:4000) VARCHAR2(n)
    VARCHAR(4001:) CLOB
    VARCHAR CLOB
    VARCHAR(1:2000) NVARCHAR2(n)
    TEXT CLOB / NCLOB
    DATE DATE
    TIMESTAMP(0) DATE
    TIMESTAMP(0) TIMESTAMP(0)
    TIMESTAMP TIMESTAMP / TIMESTAMP [(fractional_seconds_precision)] WITH LOCAL TIME ZONE
    TIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE
    BOOLEAN CHAR (1)*
    BYTEA BLOB

    *NOTE: For PostgreSQL Physical or Logical replication, BOOLEAN values will be replicated as 1/0 in a CHAR(1) column on the Oracle target.

    SharePlex supports the following PostgreSQL data types for replication from PostgreSQL Database as a Service to Oracle when conflict resolution is configured:

    • VARCHAR

    • SMALLINT

    • INT

    • BIGINT

    • NUMERIC

    • DATE

    • CHAR

    • TIMESTAMP(0)

    • TIMESTAMP

    • TIMESTAMP WITH THE TIME ZONE

    • TIME

    • TIME WITH TIME ZONE

    • BOOLEAN

    Supported DML operations

    SharePlex supports DML operations on tables. DML can be replicated from a PostgreSQL Database as a Service to an Oracle target.

    Tables

    SharePlex supports the following DML operations on tables:

    • Singular and bulk operation - Insert

    • Singular and bulk operation - Update with key(s)/ non key(s)

    • Singular and bulk operation - Delete with key(s)

    • Above operations with rollback/savepoint

    The target table must support the column types that are being replicated from the source PostgreSQL table.

    Supported operations and objects for DDL replication

    Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL Database as a Service as source to an Oracle target. It only supports tables as objects for data replication.

    PostgreSQL Database as a Service to PostgreSQL replication

    SharePlex supports replication from PostgreSQL Database as a Service to PostgreSQL, according to the details below.

    Supported target operating systems

    Native SharePlex installation is supported on the following platforms:

    • RHEL 7.x, 8.x, and 9.x

    • Rocky Linux 8.x

    • Oracle Linux 7.x and 8.x

    Remote replication from the following operating systems is supported:

    • RHEL 7.x, 8.x, and 9.x

    • Rocky Linux 8.x

    • Oracle Linux 7.x and 8.x

    Supported target operating systems via remote replication:

    • AIX 7.1, 7.2, and 7.3

    • CentOS Linux 7.x

    • HP-UX 11.31 Itanium

    • Oracle Linux 7.x and 8.x

    • Oracle Solaris SPARC 11.4

    • Oracle Solaris x86 11.4

    • RHEL 7.x, 8.x, and 9.x

    • Rocky Linux 8.x

    • SuSE SLES 12.x and 15.x

    • Windows Server 2016 and 2019

    Note: SharePlex supports only the 64-bit version of the listed operating systems.

    Supported target versions and ODBC requirements

    • PostgreSQL 13.x , 14.x, 15.x, 16

    • Enterprise Database (EDB) 15.x and 16

    • Fujitsu Enterprise PostgreSQL 15 SP2

    • AlloyDB Omni 15.5.x*

    *Note: To use the AlloyDB Omni 15.5.x database for data replication using SharePlex, contact the Quest Support team at www.quest.com/contact.

    ODBC driver requirement:

    ODBC drivers for Community Edition: postgresql13-odbc-13.02.0000, postgresql14-odbc-13.02.0000,postgresql15-odbc-16.00.0000, and postgresql16-odbc-16.00.0000

    ODBC drivers for Enterprise Edition (EDB): edb-odbc-13.02.0000 and edb-odbc-16.00.0000.01

    Supported target cloud platforms

    Amazon Web Services:

    • Amazon EC2 (IaaS) Virtual Machine

    • Amazon RDS for PostgreSQL

    • Amazon Aurora

    Microsoft Azure:

    • Azure Virtual Machine (IaaS)

    • Azure DBaaS

    Google Cloud Platform:

    • Cloud SQL for PostgreSQL

    • AlloyDB for PostgreSQL*

    *Note: To use the Google AlloyDB for PostgreSQL Cloud platform for data replication using SharePlex, contact the Quest Support team at www.quest.com/contact.

    Supported character sets

    • UTF 8

    • LATIN1

    Note: These character sets are supported only if the same character set is present on both the source and target. For example: Latin1 → Latin1 and UTF8 → UTF8.

    Supported data types

    SharePlex PostgreSQL supports the following data types for replication from PostgreSQL Database as a Service to PostgreSQL:

    • CHAR
    • VARCHAR
    • TEXT
    • SMALLINT
    • INT
    • BIGINT
    • NUMERIC
    • REAL
    • DOUBLE PRECISION
    • DATE
    • TIMESTAMP (0)
    • TIMESTAMP
    • TIMESTAMP WITH TIME ZONE
    • BOOLEAN
    • BYTEA
    • TIME
    • TIME WITH TIME ZONE

    Supported DML operations

    SharePlex supports DML operations on tables. DML can be replicated from a PostgreSQL Database as a Service to a PostgreSQL target.

    Tables

    SharePlex supports the following DML operations on tables:

    • Singular and bulk operation - Insert
    • Singular and bulk operation - Update with key(s)/ non key(s)
    • Singular and bulk operation - Delete with key(s)
    • Above operations with rollback/savepoint

    The target table must support the column types that are being replicated from the source PostgreSQL table.

    Supported operations and objects for DDL replication

    Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL Database as a Service as source to a PostgreSQL target. It only supports tables as objects for data replication.

    PostgreSQL Database as a Service to Snowflake replication

    SharePlex supports replication from PostgreSQL Database as a Service to Snowflake, according to the details below.

    Supported operating systems

    The following operating systems are supported for capture from a PostgreSQL Database as a Service and replication to a Snowflake target database. SharePlex Snowflake supports only the 64-bit version of the listed operating systems.

    SharePlex replicates remotely to Snowflake. Replication from the following operating systems is supported:

    • RHEL 7.x, 8.x, and 9.x

    • Oracle Linux 7.x and 8.x

    Supported target versions and ODBC requirements

    Snowflake 6.31 Enterprise, Community version, and Snowflake 8.1.0

    ODBC driver requirement: Snowflake 3.1.4 and above

    Supported target cloud platforms

    Microsoft Azure

    Supported data types

    SharePlex supports the following data types for replication from PostgreSQL Database as a Service to Snowflake:

    PostgreSQL Snowflake
    TEXT TEXT
    INT INT,INTEGER,NUMBER
    CHAR(1:2000) VARCHAR(n)
    CHAR(2001:) VARCHAR(n)
    CHAR(n) CHAR(n)
    VARCHAR(1:4000) VARCHAR(n)
    VARCHAR(4001:) VARCHAR(n)
    VARCHAR VARCHAR(n)
    REAL REAL
    SMALLINT SMALLINT
    BIGINT BIGINT
    NUMERIC (whole number without fraction) NUMERIC, DECIMAL
    NUMERIC (fractional number) FLOAT
    DATE DATE
    DOUBLE PRECISION DOUBLE PRECISION
    TIMESTAMP TIMESTAMP
    TIMESTAMP_TZ TIMESTAMP_TZ
    BOOLEAN BOOLEAN
    TIME TIME
    Conditions of support

    • Char(n) data type - In PostgreSQL, Char(n) is a fixed-size data type. If you insert char data with a length less than "n" into the "Char(n)" column, the remaining slots (n - length) are padded with space to occupy the complete "n" memory positions. Snowflake uses  VARCHAR(n) for char storage since Snowflake lacks a comparable fixed-length character data type and only saves char data up to its length. Live replication will ensure that char column data is correctly copied. However, if users are manually inserting data into Snowflake for the equivalent of a Char(n) PostgreSQL column, then the user will need to handle padding as well to occupy the full "n" length so that data will be in sync in both the source and target database.

    • Text data types - Snowflake Text data types have size limitation of 8 MB, so PostgreSQL’s TEXT data type replication will be restricted to max 8 MB size limit of equivalent counterpart. Refer table below.

    PostgreSQL Data type Max Size Snowflake Data type Max Size
    TEXT unlimited TEXT 8 MB of unicode chars

    See Conditions of support for the additional conditions of support for the above-mentioned supported data types.

    Supported operations and objects for DML replication

    SharePlex supports DML operations on tables, with some conditions. DML can be replicated from an PostgreSQL Database as a Service to a Snowflake target.

    Tables

    SharePlex supports the following DML operations on tables when replicating data from an PostgreSQL Database as a Service to the Snowflake target:

    • Singular and bulk operation - Insert with key(s)/ non key(s)

    • Singular and bulk operation - Update with key(s)/ non key(s)

    • Singular and bulk operation - Delete with key(s)/ non key(s)

    Limitations:

    The following DML operations related limitations are observed while replicating data from PostgreSQL Database as a Service to Snowflake:

    • Slowness while performing DML operations

      • Single Insert: Frequent commits and rollbacks can cause slowness in replication.

      • Batch Inserts: Insert with advance data types [target Snowflake data types: TEXT and BINARY] can cause significant slowness in replication for data with plain text or binary JSON and XML.

      • Single Update and Delete : Frequent commits and rollbacks can cause slowness.

    For additional information, see Supported Operations and Objects for DML Replication.

    Supported operations and objects for DDL replication

    Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL Database as a Service as source to a Snowflake target. It only supports tables as objects for data replication.

    PostgreSQL Database as a Service to SQL Server replication

    SharePlex supports replication from PostgreSQL Database as a Service to SQL Server, according to the details below.

    Supported target operating systems

    The following operating systems are supported for SQL Server database. SharePlex supports only the 64-bit version of the listed operating systems.

    Supported operating systems via native installation:

    • RHEL 7.x, 8.x, and 9.x

    • Rocky Linux 8.x

    • Oracle Linux 7.x and 8.x

    Remote replication from the following operating systems is supported:

    • RHEL 7.x, 8.x, and 9.x

    • Rocky Linux 8.x

    • Oracle Linux 7.x and 8.x

    Supported target operating systems via remote replication:

    All platforms listed above, plus Windows Server 2016 and 2019, are supported via remote replication.

    Supported target versions and ODBC requirements

    SQL Server 2012, 2014, 2016, 2017, 2019 and 2022

    Note: SQL Server 2012, 2014, and 2016 databases hosted on Windows servers are compatible with Windows Server 2016 and above.

    ODBC driver requirement: ODBC 17.10.1.1-1 and 18.3.2.1-1

    Supported target cloud platforms

    Amazon Web Services

    Amazon EC2 (IaaS) Virtual Machine

    Microsoft Azure

    • Azure Virtual Machine (IaaS)

    • Azure SQL Database

    • Azure SQL Managed Instance

    Supported data types

    SharePlex supports the following data types for replication from PostgreSQL Database as a Service to SQL Server:

    PostgreSQL SQL Server
    INT INT
    REAL REAL
    SMALLINT SMALLINT
    BIGINT BIGINT
    NUMERIC / DECIMAL NUMERIC / DECIMAL
    DOUBLE PRECISION FLOAT
    CHAR (1:8000) CHAR(n)
    CHAR (8001:) VARCHAR (MAX)
    CHAR (1:2000) NCHAR (n)
    VARCHAR (1:8000) VARCHAR (n)
    VARCHAR (8001:) VARCHAR (MAX)
    VARCHAR(1:2000) NVARCHAR (n)
    VARCHAR VARCHAR (MAX) / TEXT
    TEXT TEXT / NTEXT / VARCHAR(MAX)
    DATE DATE
    TIMESTAMP (p) DATETIME2 (p)
    TIMESTAMP DATETIME2
    TIMESTAMP WITH TIME ZONE DATETIMEOFFSET

    Supported DML operations

    SharePlex supports DML operations on tables. DML can be replicated from a PostgreSQL Database as a Service to an SQL Server target.

    Tables

    SharePlex supports the following DML operations on tables:

    • Singular and bulk operation - Insert
    • Singular and bulk operation - Update with key(s)/ non key(s)
    • Singular and bulk operation - Delete with key(s)
    • Above operations with rollback/savepoint

    The target table must support the column types that are being replicated from the source PostgreSQL table.

    Supported operations and objects for DDL replication

    Currently, SharePlex does not support DDL operations when replicating data from a PostgreSQL Database as a Service as source to an SQL Server target. It only supports tables as objects for data replication.

    • Known issues

    Known Issues in this Release

    The following is a list of known issues, including those attributed to third-party products, known to exist at the time of release.

    Issue ID Known Issues Component/ Feature
    SPO-24922 SharePlex does not support the RAISE command on PostgreSQL databases. Poster stops with the Post stops error=-1 when trigger issues a RAISE [LABEL] error message. RAISE command
    SPSQL-2530 Performance issues are observed during bulk DML operations on the text data type in a PostgreSQL cloud database (PGDBaaS). PGDBaaS
    SPSQL-7057

    The Compare process displays an error while comparing the table during replication in SharePlex version 11.4. This issue is observed after upgrading SharePlex from version 11.x to 11.4.

    Workaround: After upgrading, to bring up your existing setup, activate the same configuration file again if your source is PostgreSQL with logical replication. This will add newly created SharePlex internal tables to the publication used for logical replication before starting the Capture process.

    		 Upgrade
    SPSQL-7046 SharePlex fails to replicate bulk data from Oracle to Snowflake when table or column names are case-sensitive. Bulk update
    SPSQL-6609 SharePlex displays an error when users attempt to create a database name in lowercase during pg_setup that matches an existing database name in uppercase on the system. pg_setup
    SPSQL-6104 The SharePlex Poster process stopped due to an ORA-40441 error: JSON syntax error, triggered when users insert bulk JSON data for CLOB/NCLOB storage, which is stored as BASICFILE. Poster
    SPSQL-5625 SharePlex displays the "Error encountered in remove_trigger objectid" error when users attempt to disable or enable any trigger using the sp_pg_add_trigger.sql and sp_pg_remove_trigger.sql scripts for the given schema. Trigger Scripts
    SPSQL-5252

    In the bi-directional replication of data from PostgreSQL 14.7 Google Cloud Platform to Oracle, the Poster process stops with an error when a user-defined procedure tries to resolve the conflicts that occurred on columns with a VARCHAR data type.

    This issue is observed if the update statement is triggered simultaneously in the same row on both source and target.

    		 Bi-directional replication
    SPO-24085 The SharePlex Poster process is performing slow after upgrading to version 10.1.3. Poster
    SPSQL-4982 When there are multiple Named Queues set up in replication, after activating the config, the SharePlex Poster process displays the execute select pg_replication_origin_create ('sp_post_2600_7'); failed error upon its initial startup. However, after displaying the error, SharePlex automatically restarts the Poster process to resolve the issue. Poster
    SPSQL-6502 The SharePlex Poster process is stopping due to the Poster stopped due to error: missing column on target table error during a DML operation. This issue is observed with the latest versions of MySQL and the ODBC driver. This issue is observed while replicating data from Oracle to MySQL. Poster
    SPSQL-4971 The tables are getting out-of-sync after users perform bulk DML operations on the CLOB column data. This issue has been observed while working on Oracle 21c. Oracle 21c
    SPSQL-4854

    The SharePlex Poster displays an error regarding the invalid length for a variable character string while replicating CLOB column data from Oracle to Oracle. This issue has been observed while working on Oracle 19c on the RHEL platform, Oracle 21c.

    Affected versions: SharePlex 10.2, 11.0, 11.1, and 11.2 on the Linux platform.

    		 Oracle to Oracle
    SPSQL-4909 SharePlex displays a value in the TARGET_ROWID column of the shareplex_conf_log table even when the user sets the parameter SP_OPO_LOG_CONFLICT to 1. This issue is observed while replicating data from PostgreSQL to Oracle and Oracle to Oracle. PostgreSQL to Oracle and Oracle to Oracle.
    SPSQL-3596 In bi-directional replication of data from PostgreSQL to Oracle, an Oracle custom routine (splex.PROCEDURE1) is not taking priority over a SharePlex-prepared routine. On the contrary, the SharePlex-prepared routine (LeastRecentRecord) is taking priority over the custom procedure on Oracle Peer for conflict resolution. PostgreSQL-Oracle BDR
    SPSQL-6618 The SharePlex Compare process fails with an error while comparing tables using wild card data in the command options for o.sid/r.dbid. This issue is observed while replicating data from Oracle to Oracle and PostgreSQL to PostgreSQL. Compare
    SPSQL-6608 The SharePlex Compare process fails with Error: RouteDB.load routes file does not exist for actid when comparing data containing special characters using the config file. This issue is observed while replicating data from PostgreSQL to PostgreSQL. Compare
    SPSQL-6607 SharePlex is displaying an error when executing a Compare/Repair query command with wildcards for multiple tables that have a different number of columns. This issue is observed while replicating data from PostgreSQL to PostgreSQL. Compare/Repair
    SPO-24757

    SharePlex displays the “ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT” error while performing the Compare/Repair operation on the XML data.

    Workaround:

    1. Upgrade Oracle to 19.19 DBRU

    2. Set appropriate PGA_AGGREGATE_LIMIT using the below Oracle suggested script :

    WITH

    MAX_PGA as

    (select round(value/1024/1024,1) max_pga from v$pgastat where name='maximum PGA allocated'),

    MGA_CURR as

    (select round(value/1024/1024,1) mga_curr from v$pgastat where name='MGA allocated (under PGA)'),

    MAX_UTIL as

    (select max_utilization as max_util from v$resource_limit where resource_name='processes')

    SELECT

    a.max_pga "Max PGA (MB)",

    b.mga_curr "Current MGA (MB)",

    c.max_util "Max # of processes",

    round(((a.max_pga - b.mga_curr) + (c.max_util * 5)) * 1.1, 1) "New PGA_AGGREGATE_LIMIT (MB)"

    FROM MAX_PGA a, MGA_CURR b, MAX_UTIL c

    WHERE 1 = 1;

    1. Upgrade to or install the SharePlex 11.1 version

    		 Compare/Repair
    SPO-22342 Performance issue is observed while performing the DML operations in bulk. MySQL
    SPO-22517 Performance issue is observed during replication while using partition table over the cloud. PostgreSQL and MySQL
    SPO-21993 While activating a config file with an Oracle SCN number, users are not able to delete a column in a DDL activity. DDL Drop Column
    SPO-21339 The SharePlex Capture process is getting stuck when users change the Oracle compatibility parameter from 11g to 12c. This issue is observed on the 12c 4 node RAC database. Capture
    SPO-20843 Copy job status shows 'Locked' even when competed. Copy/ Append
    SPO-20842 On Oracle 19c processing large n-items can lead to OOS and/or missing commits. LOBs, VARRAYs, XML
    SPO-20841 Post will fail with ORA-14400 performing DML on partitioned table with VARRAY residing in an OLTP compressed table space. Partitioned Replication
    SPO-20733 Compare will hang and the compare server will exit comparing table that has VARRAY containing UDT type. Compare
    SPO-20451 Compare/Repair using [schema].[table] may not work on AIX 7.2 with Oracle 19c due to establishing a network connection. Compare
    SPO-20205 Oracle to Kafka supported data format:
    Kafka replicates the varray column data only in the XML format.
    Currently, Kafka does not replicate the varray column data in the JSON format.    		 Kafka
    SPO-19048 Replication of tables with varray columns from an Oracle source to a non-Oracle target can get out of sync because Oracle doesn't include key information on updates. Post to non-Oracle targets
    SPO-16453 The BINARY_FLOAT and BINARY_DOUBLE data types are not supported for the copy command. Character Sets
    SPO-22429 SharePlex is displaying the 'ERROR: invalid byte sequence for encoding "UTF8": 0xfd;' error related to character mapping while replicating data from an Oracle database to a PostgreSQL database. Character Mapping

    Third-party known issues

    Issue ID Known Issue Component/ Feature
    SR 3-33906406631 After moving the LOB segment, users may encounter an 'ORA-22275' or 'ORA-22990' Oracle error when performing DML operations. Additionally, the Compare result may be displayed as out of sync. This issue is observed intermittently on Oracle 21c. See Oracle bug report SR 3-33906406631. Oracle
    101806 When replicating data from Oracle to MySQL, SharePlex Poster displays an error after performing the Update operation on columns with the data type integer and column values that are multiples of 1000. This issue is related to a defect in the MySQL database: https://bugs.mysql.com/bug.php?id=101806 MySQL
    54799 RHEL with 11g may encounter issues when producing core files. To work around this issue users will need to change the parameter "core_pattern" in the /proc/sys/kernel/core_pattern file. The following command enables core files: sysctl -w kernel.core_pattern=core. The original setting is: /corefiles/core. In this state, the system looks for a directory named /corefiles, which does not exist, therefore a core file could not be created. Linux
    125639 There might be an issue when replicating VARRAYs with FLOAT(n) type to a target machine running Oracle 10g, due to the way that Oracle handles Float(n) types. Float is not an Oracle type; it is a SQL-92 type and Oracle is not consistent in the way that it handles the float type. This is a known Oracle bug. See Oracle bug report 4266304. Oracle
    44626 Users wishing to employ IOTs with overflow need to be running Oracle 11g or higher. This is a known Oracle issue addressed under 4627859. Oracle
    53701 There is a known issue with INSERT DIRECT LOAD VALUES (IDLV) in Oracle 11g that prevents the reading or modification of an object after modifying it in parallel. Oracle has provided three solutions for addressing this issue. They can be found in the Oracle update of SR6849411.993 dated 05-07-2008. This issue was fixed by Oracle in 11gR2. Oracle
    59258 Oracle versions 10.2.0.1 through 11.1.0.6 on AIX 5.3 (64 bit), members of SharePlex Admin group, other than the installation user, cannot run ora_setup or start SharePlex. Please see Oracle Bug # 6800649 and apply Patch 6800649. Oracle
    75179 Oracle 11gR2 - During a SYNC job, the copy of a new table (without data) failed at “EXP-00011: table does not exist” . The table that failed is a new table without any data. The EXP-00011 is caused by 11gR2 new feature "Deferred Segment Creation" that is controlled by the initialization parameter DEFERRED_SEGMENT_CREATION. The default is ON. To avoid this error, disable the parameter. A tar has been opened with Oracle and Oracle created a note 960216.1 Original Export Raises EXP-11 Table Does Not Exist. Oracle
    92152 OLTP compression with supplemental logging enabled may corrupt the Oracle Undo block, so Oracle suggests disabling supplemental logging when running OLTP compression. However, SharePlex requires supplemental logging to be enabled, so you may encounter this bug. This affects Oracle versions 11.2.0.2, 11.2.0.1 and 11.1.0.7. See Metalink ID 1191474.1. Oracle

    Product Licensing

    Licensing

    To use the license utilities, such as to view, add, or remove license keys, see the SharePlex License Utilities section in the SharePlex Reference guide or SharePlex Installation and Setup Guide. For more information, contact your account manager.

    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 and above are 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.

    Note: To upgrade from SharePlex 10.x to 11.0 or 11.1, a new SharePlex license key must be requested. However, to upgrade from SharePlex 11.0 to 11.1, the existing effective SharePlex license key can be utilized.

    Understanding SharePlex licensing and platform requirements

    SharePlex licenses have validity and usage limits according to specific platforms. For example, you must have a PostgreSQL license to use a PostgreSQL database and a Kafka license to use the Kafka platform.

    Additionally, SharePlex supports multiple keys for situations where customers need two platforms on one server. For example, if a user is replicating data from an Oracle source to a Kafka target, where one SharePlex instance is serving as both the source and target, the SharePlex server would require both Oracle and Kafka licenses.

    Installing a trial version

    To install a trial version of SharePlex, users need to select the All Platforms option when prompted during installation of SharePlex or while running the splex_add_key utility. For additional information, see the Install SharePlex section in the SharePlex Installation Guide.

     

    Verwandte Dokumente

    The document was helpful.

    Bewertung auswählen

    I easily found the information I needed.

    Bewertung auswählen