|Resolved Issues and Enhancements|
|Basic system requirements|
|System requirements for Oracle|
|System requirements for SQL Server|
|Third Party Contributions|
SharePlex provides high-speed replication from Oracle and SQL Server databases to different target databases and messaging containers on major Unix, Linux and Windows operating systems— both on-premises and in the cloud. SharePlex supports a wide variety of configurations to meet different and complex data availability needs.
SharePlex supports reliable Oracle high availability configurations where replication maintains a duplicate database in a different location that is ready for fast, seamless failover and failback in planned or unplanned mode.
You can also use SharePlex to replicate data from Oracle and SQL Server sources to maintain a change history database in an Oracle target. Rather than updating or deleting target rows based on the source change, SharePlex inserts a new row on the target for every source change. The result is an archive that reflects the chronological history of every change made to the source database.
SharePlex also includes, at no extra charge, the compare and repair tools that you need to verify the accuracy of a target maintained by replication. These tools not only detect hidden out-of-sync conditions, but they also repair the target to restore parity of your source and target data.
SharePlex value and versatility continues to grow with the requirements and requests of our customers. Although SharePlex is a reliable, relatively low-maintenance solution, our top-rated support team is ready around the clock to help with any trouble you may have. To get you started with your deployment, our professional services team is highly experienced and readily available.
For expert advice and the latest news about SharePlex, join the SharePlex Community at https://www.quest.com/community/products/shareplex. Take advantage of our forums, blogs, videos, and more from our own experts, as well as input from our customers and partners.
SharePlex 9.2 is a minor release and includes the following new features and enhanced functionality.
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.
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.
Support for Peer-to-Peer Replication Strategy for SQL Server.SharePlex now supports the peer-to-peer replication strategy for SQL Server databases. See the SharePlex 9.2 Administration Guide for more information about configuring peer-to-peer replication. SharePlex provides a prepared routine which you can use to perform basic conflict resolution.
Support for 128-byte table and column names. In SQL Server capture, SharePlex now supports table and column names that are up to 128 bytes in length.
Support for SQL Server 2017. This releases includes support for capture from SQL Server 2017 on Windows and replication to SQL Server 2017 on Windows or Linux.
SQL Server replication to Amazon Aurora PostgreSQL. SharePlex can replicate from SQL Server on-premises to Amazon Aurora with PostgreSQL Compatibility.
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.
New jobs status database
Simplified SharePlex Installation Process on Windows
This release of SharePlex includes a new typemap command, as well as changes to the default data type mappings. Review the following details.
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.
The following features and support are not included in this release of SharePlex.
Note: For a list of all deprecated parameters and commands, their replacements (if any), and the version of SharePlex in which they were deprecated, see the SharePlex Reference Guide.
HP-UX 11.23 Itanium
The following is a list of issues addressed and enhancements implemented in this release of SharePlex.
|SPO-920||Add reminder: to bounce sp_cop once new key is added|
|SPO-1208||Enhancement to have double quote around the SharePlex cop service path|
|SPO-2647||Redo GMT adjustment only works on Linux - provides inaccurate latency any other platform|
|SPO-3196||Rollback of errors not working|
|SPO-3198||Prevent unsupported DDL from being transmitted to the open target post|
|SPO-3267||Enhancement: SharePlex now searches for archive logs in the subdirectories as well as the main directory of the path specified by SP_OCT_ARCH_LOC.|
|SPO-4592||Suppressed out of sync not being called for deletes|
|SPO-4643||Poster memory leak in full rollback|
|SPO-4665||Setting parameter sp_opo_cont_on_err to 2 will instruct poster to treat table errors the same as other errors and stop unless they are in the oramsglist file.|
|SPO-10305||Show capture detail and "show post detail" should have same LSN|
|SPO-10337||Enhancement: For a SQL Server capture, "show capture detail" now includes log number, log offset, and timestamp of last transaction processed.|
|SPO-10441||SQL Server Supportability through Utilization Timers|
|SPO-10623||SQL Server activation will activate SharePlex tables|
|SPO-10671||High CPU usage when colcache grows|
|SPO-10812||Poster won't stop on an ora-00942 error during DDL operation|
|SPO-10820||Qstatus reports incorrect size|
|SPO-11102||Enhancement: Added a message to event_log indicating that there is encrypted data in redo.|
|SPO-11647||Enhancement: Added support for Extended Statistics for Oracle 12c to correct an issue that caused a post error if extended statistics were gathered on source and target table.|
|SPO-12112||Autoadd of Materialized View created with certain syntax caused capture to core|
|SPO-12269||Capture did not replicate CreateUser/Gratn/AlterUser DDLs issued using DataPump|
|SPO-12286||XML varray Out of row dumps core and varray replication results in bad data (extra characters appended to values) in XML file.|
|SPO-12322||Suppressed out of sync core dumps - probably when update has empty columns|
|SPO-12404||Added restart logic for Kafka based on error|
|SPO-12407||Oracle Poster core dumping in PEP|
|SPO-12442||QMI (Array insert) on tales with ROW-DEPENDENCIES on Oracle 12cR2 failed|
|SPO-12578||Compare numeric partition/subpartition name failed|
|SPO-12602||Advice message wrong for SP_OPO_STOP_ON_DDL_ERR|
|SPO-12887||OT skip continue negative error number does not work|
|SPO-12924||ORA-22053 converting sys.tab$.property to 64 bit integer|
|SPO-13034||Missing ' in sql error file for '|| string data|
|SPO-13055||Compare fails with table name that includes Japanese characters.|
|SPO-13080||Poster to use default ddl schema for create synonym|
|SPO-13177||Minimize 2 pass with horizontal partitioning enabled|
|SPO-13198||Factor in possible 0 value for min sequence# in min query to prevent core capture|
|SPO-13337||Post fails applying varray od SDO_GEOMETRY|
|SPO-13385||Multi-OCI mode failure on HP-UX IA64 platform. Added LogParallelism debug to track Out-Of-Order records.|
|SPO-13534||On Windows, "show statusdb detail" command causes sp_ctrl to exit.|
|SPO-13556||Improved compare performance when the source and target character sets are different.|
|SPO-13596||The Poster core dumps when connecting to Postgres with SSL.|
|SPO-13622||Improved performance of CDC (in change-history environment)|
|SPO-13673||Poster core dump in batch of update on a table with many columns (over 500)|
|SPO-13829||Enhancement: Enhance manner used to save reader's ccache to reduce memory usage and physical size.|
|SPO-13872||Enhancement to truncate tranx file assuming only 1 open transaction based on class/slot.|
|SPO-14050||Addressed issue of missing DDLs in DDL log.|
|SPO-14058||Simplified installing SharePlex on Windows: When installing on a Windows platform, you are no longer required to specify Oracle version or whether or not it is a non-Oracle installation.|
|SPO-14059||You no longer need to 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.|
|SPO-14060||When you uninstall SharePlex software in a Windows environment, MKS Toolkit and NuTCRACKER are now removed automatically.|
|SPO-14124||Corrected an issue that caused a "no such file" or "directory rename failed" error when there are multiple imports.|
|SPO-14184||Compare/Repair hangs while waiting for lower case lock file when ora_setup is using lower case tns alias.|
|SPO-14196||Corrected an issue that caused the following Oracle error: ORA-01740 missing double quote in identifier.|
|SPO-14207||Address issue with Oracle error 942 when rename causes reader to query tables before the rename|
|SPO-14401||Import should exit when the connection fails|
|SPO-14437||A particular sequence of operations in IOT caused capture to generate a ''10651 - op ID failed'' message in the event_log.|
|SPO-14541||Allow custom "FROM" in sp_nt_mon|
|SPO-14585||Replication to Kafka with JSON without quotes for numeric data type|
|SPO-14744||Capture intermittently generates ODR message for Drop Sequence DDL with a bad SQL option|
|SPO-14768||Fixed licensing for empty HostID on Windows|
|SPO-14779||In a peer-to-peer environment, after Drop/Create Sequence was issued on source host, issuing 'show config' command resulted in a mismatch between hosts.|
|SPO-14785||Ensure debug in key cache is only logged if debug is set.|
|SPO-14898||Discard messages which need complete keys if debug setting is set.|
|SPO-14901||In the SharePlex Reference Guide, the compare command option nolock has been removed and replaced by the correct options: nolocksource | nolocktarget | nolockboth.|
|SPO-14918||Improve the performance when a transaction has a lot of rollbacks|
|SPO-14932||Handle Oracle error 2396, IDLE time exceeded|
|SPO-15057||Sybase issue with number in exponent format such as 8330e-2|
|SPO-15132||Address issue with ccache corruption with DML filters. Regressed from ccache size fix.|
|SPO-15210||Compare is slow over WAN|
|SPO-15243||Allow the user in connections.yaml to be changed via the connection command in sp_ctrl|
|SPO-15280||SCN is zero on CDC update after record|
|SPO-15340||Unchanged column with non-NULL default value could be updated to NULL value.|
|SPO-15462||Resolved an issue that caused Compare to run longer in 9.1.3 over 8.6.3|
|SPO-15597||Cop does not load all auto-open wallets when there are multiple datastores with auto-open mode in connection.yaml file.|
|SPO-15600||Poster core dump on horizontal partition table insertN|
|SPO-15782||Resolved an issue which caused object cache break up to be forwarded with a hardcoded size of 1000 bytes.|
|SPO-15817||Corrected an issue which resulted in missing or incorrect Change History data.|