SharePlex 9.2.10 - Upgrade Guide for Oracle Source

New Features in this Release

SharePlex 9.2.10

SharePlex 9.2.10 is a patch release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.

SharePlex 10.0

Database Support. This release of SharePlex includes support for the following database versions:

• Oracle 19c. This release includes support for capture from and replication to Oracle 19c on all platforms(except HP/UX).
• Oracle 19c on RDS. This release includes support for capture from and replication to RDS running Oracle 19c.

NOTE: Advanced Row (OLTP) Compression is not supported by SharePlex for replication of objects using DML operations in Oracle 18c and 19c. This limitation applies to objects in the source database.

SharePlex 9.4

Database Support. This release of SharePlex includes support for the following database versions:

NOTE: 9.4.0 is a Linux only release. To properly replicate from SharePlex 9.4.0 capture (source) to a non-9.4.0 target, set the SP_SYS_TARGET_COMPATIBLITY. See Interoperability between versions for how to use and set this parameter.

NOTE: OLTP compression is not supported by SharePlex for replication of objects using DML operations in Oracle 18c and 19c. This limitation applies to objects in the source database.

SharePlex has put bug fixes into a cumulative update rollup (denoted by third digit in the version number)—starting with the 9.2.3 release. Customers that require bug fixes which are already available in a patch update rollup will be required to apply that patch release to get the bug fix.

SharePlex 9.2.9

SharePlex 9.2.9 is a patch release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.

SharePlex 9.2.8

SharePlex 9.2.8 is a patch release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.

SharePlex 9.2.7

SharePlex 9.2.7 is a patch release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.

SharePlex 9.2.6

SharePlex 9.2.6 is a patch release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.

SharePlex 9.2.5

SharePlex 9.2.5 is a patch release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.

SharePlex 9.2.4

Oracle Cloud Infrastructure as a Service (IaaS) Compute Virtual Machine is now supported as a target.

SharePlex 9.2.4 is a patch release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.

SharePlex 9.2.3

SharePlex 9.2.3 is a minor release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.

SharePlex 9.2.1

SharePlex 9.2.1 is a minor release and includes the following new features and enhanced functionality.

Other New Features

• Oracle 18c. This release includes support for capture from and replication to Oracle 18c.

Note: SharePlex does not support replication of DML operations on objects compressed using OLTP Compression in Oracle 18c. This limitation applies to objects in the source database.

• Kafka 1.1.x. This release includes support for replication to a Kafka 1.1.x target.

Operating System Support. This release includes support for SuSE SLES 15.

Installation

SharePlex installer packages for Linux/Unix. SharePlex installer packages for Linux/Unix are now database independent. You are no longer required to select an installer package based on the database for which SharePlex will be used (i.e., Oracle or Open Target). To install SharePlex for Oracle or Open Target, simply select the installer package for your operating system.

The SharePlex installer packages now have a slightly different naming convention:

SharePlex-release#-build#-platform-chipset.tpm

For Oracle Solaris (Sun), the operating system version is included:

SharePlex-release#-build#-platform-version-chipset.tpm

SharePlex 9.2

SharePlex 9.2 is a minor release and includes the following new features and enhanced functionality.

New Features for Oracle Source

Oracle UROWID data type. Support has been added for the Oracle UROWID data type. This support applies to Oracle-to-Oracle configurations only.

Support for SCN metadata for HANA target. This release of SharePlex supports posting the Oracle SCN to a column in a HANA target table.

Oracle replication to MySQL 5.7. SharePlex supports replication from an Oracle source to a MySQL 5.7 target on-premises.

Oracle 12c R2 Support

Support for 128-byte table and column names. In Oracle capture, SharePlex now supports table and column names that are up to 128 bytes in length. Please note the following limitations applicable to this release.

• UDT column names more than 30-bytes in length are not supported.
• Type names for UDTs and VARRAYS with names more than 30-bytes in length are not supported.
• IOT names more than 30-bytes in length are not supported.

Other New Features

Support for Windows Server 2016. Support for capture from and replication to databases on Microsoft Windows Server 2016.

Improved Performance in the Post Process.

The following enhancements were made to improve performance of the Post process.

• Implemented multi-threading for SQL Server and PostgreSQL targets: The Transaction Concurrency component of Post Enhanced Performance has been extended to support SQL Server and PostgreSQL targets. A new parameter, SP_OPX_THREADS, controls this feature. When set to a value of 2 or greater, Post runs with the specified number of threads (concurrent operations).
• Batch similar operations: To maximize its performance when applying SQL operations to the target, the Post process groups smaller replicated operations into one larger batched operation. Post groups replicated operations when the operations are identical and the SQL is similar. A new parameter, SP_OPX_BATCH_ENABLE, controls this feature and is enabled by default. Another new parameter, SP_OPX_MAX_BATCH_MBYTES, controls the maximum size of the batched DML operation that Post applies to the target. This supports databases, such as Teradata, that have a maximum transaction size and can be used for other purposes where batch size must be changed.

New jobs status database

• This release includes a new jobs status database. This database resides in the data sub-directory of the SharePlex variable-data directory. The parameter SP_SYS_JOB_HISTORY_SIZE allows you to control the size of this database. Use this parameter to specify the maximum size (in kB) allowed for the database.

Simplified SharePlex Installation Process on Windows

• When installing on Windows, you are no longer required to specify the Oracle database version or specify whether or not you are installing in a non-Oracle environment.
• You no longer need to manually change the default setting for Global Resources memory in the MKS Toolkit after you install SharePlex on a Windows system. The setting is now modified automatically during installation.

Data Type Mapping

This release of SharePlex includes a new typemap command, as well as changes to the default data type mappings. Review the following details.

• Use the typemap show command to display all default data type mappings. Use typemap show source-target to display the mapping for the specified source-target combination, for example oracle-sqlserver. See the SharePlex 9.2 Reference Guide for more information about using the typemap command.
• Use the typemap command instead of the data type option of the target command. (The data type option of the target command has been discontinued in this release.)
• For a list of supported data types, see Supported data types: Oracle to Open Targets or .

Other Changes in SharePlex

TLS 1.2 (or later) required for TLS connections. If you intend to use TLS connections in SharePlex, TLS 1.2 or later is required.