Chat now with support
Chat with Support

SharePlex 9.0.1 - Release Notes

Release Notes

SharePlex™ 9.0.1

Release Notes

Revision: 9/13/2017


About SharePlex

SharePlex provides high-speed replication from Oracle and SQL Server databases to different target databases and messaging containers on major Unix, Linux and Windows platforms — both on-premise 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.

Join our community

For expert advice and the latest news about SharePlex, join the SharePlex Community at Take advantage of our forums, blogs, videos, and more from our own experts, as well as input from our customers and partners.

About this release

This is a patch release with some new functionality.

New Features

New features in this release

New in version 9.0.1

SharePlex now supports the replication of SQL Server identity columns between SQL Server source and target databases.

New in version 9.0

For more information about each of these features, see the documentation that is provided with that release.

Note about the documentation:

The following content from the Administration Guide has been moved to the Installation Guide:

  • Set up an Oracle environment for replication (Formerly Prepare an Oracle environment for replication)
  • Set up replication between different database types (Formerly Configure replication to Open Target targets)

Additionally, the Installation Guide now includes the following new setup topics:

  • Set up replication between SQL Server databases
  • Installation and setup for cloud-hosted databases

Capture from SQL Server tables

SharePlex can now capture from Microsoft SQL Server tables. The following are specifics for configuring SQL Server tables for capture:

Configuration Requirement Description
Configuration file

To specify a SQL Server capture datasource, use an r rather than an o on the datasource specification line of the configuration file:

Datasource: r.database

where: database is the actual name of the database, not a Data Source Name (DSN) or instance name.

SQL Server can be configured to be case-insensitive or case sensitive. For case-insensitive databases type a table name or column name in upper or lower case in the configuration file. For case-sensitive databases type a table name or column name in its case-sensitive form and enclose it within double quotes. For example:

  • case-insensitive: SALES.ACCOUNTS
  • case-sensitive: "Sales"."Accounts".

The way to specify a SQL Server target remains the same. The basic syntax is: host@r.database_name.

Non-supported SharePlex features

Certain SharePlex features are not supported when capturing from SQL Server tables

Scope of support

The SQL Server capture feature supports the following:

  • Only DML operations are supported. DDL replication is not supported from a SQL Server source.
  • SQL Server source and target tables must have a primary key.
  • Only committed transactions are processed.
  • Restarting replication from a previous point in time is not supported.
  • SQL Server source tables must be quiesced for the activation process.
  • SharePlex does not support replication from SQL Server tables to other tables within the same SQL Server database. Replication between databases in the same SQL Server instance is supported.
  • You can have both a SQL Server source and an Oracle source replicating data to the same target.
  • You can activate two or more databases in a SQL Server source all going to the same, or different, targets.
  • See additional requirements, guidelines and setup instructions in the SharePlex Installation Guide.

For objects, operations, and target/platform combinations that SharePlex supports when capturing from SQL Server, see the System Requirements.


See the SharePlex Installation Guide provided with this release.

Note: The mss_setup utility now prompts you to specify whether the database is a SQL Server source. A Yes response directs the setup program to prepare the source database for replication.

Activation and instantiation The reconcile command now has an lsn option to enable the command to reconcile to a specific SQL Server transaction lsn number.

Support for MySQL

SharePlex now supports replication to a MySQL target. Ther following new utilities support this target:

  • mysql_setup: Sets up connectivity to the MySQL database for SharePlex.
  • mysql_cleansp: Restores a MySQL replication environment to a clean state.

For more information about these utilities, see the SharePlex Reference Guide.

New horizontal partitioning configuration

Horizontal partitioning is now completely database-independent and no longer requires inserts into a database table.

To configure horizontal partitioning, you use the following commands in sp_ctrl:

add partition

drop partition

drop partition scheme

modify partition

view partitions

See the SharePlex Reference Guide for more information.

Event log aging

The SharePlex event log is no longer truncated when the file reaches its maximum size. Now, when file reaches its maximum size, it is renamed to event_log_n, where n is a sequence number, and then a new file is created as the active log. For example, when the first event log reaches its maximum size, it is renamed to event_log_0000000001 and then a new file is opened as the active event log. When that file reaches its maximum size, it is renamed to event_log_0000000002, and so forth.

New and changed parameters

The following parameters were introduced.

  • SP_OPO_NLS_DEFAULT_COMPAT: This parameter controls whether Post converts character data (CHAR, VARCHAR). By default no conversion is performed. When set 7, Post will not convert character data, but will convert CLOB data. The compare/repair commands will compare and repair character data without conversion and CLOB data with conversion. The replication of NCHAR data is not affected. SP_OPO_NLS_DEFAULT_COMPAT takes precedence over SP_OPO_NLS_CONVERSION.
  • SP_OPO_UPDATE_SCN: This parameter controls the tracking of Oracle SCNs and allows SharePlex to recover quickly when operating in a high-availability cluster. When this parameter is enabled, SharePlex tracks SCNs in its internal transaction table. This enables SharePlex to activate to the lowest applied transaction and then reconcile to the correct transaction when there is a failover.
  • SP_DEQ_PARTIAL_REPAIR_CLR_OOS: This parameter enables the repair process to clear out-of-sync messages from the statusdb for a table after a compare-repair of only a subset of rows of that table, such as:

    • Row subsets specified with a WHERE clause or an Oracle [sub]partition name.
    • Row subsets specified with horizontally partitioned replication.
  • SP_OCT_DDL_UPDATE_CONFIG: This parameter controls whether SharePlex updates the table name in the configuration file when processing ALTER TABLE RENAME. By default, SharePlex updates the table name when it processes this DDL operation. To prevent updates the configuration file, disable this parameter.
  • SP_OCT_TRUNC_PARTITION_BY_ID: For Oracle 12.2 or later, setting SP_OCT_TRUNC_PARITION_BY_ID is not necessary, and the setting of the parameter will be ignored. The requirement to set it for earlier Oracle versions still remains. For more information about setting this parameter, see the SharePlex Reference Guide

See the SharePlex Reference Guide for more information.

Delete queue enhancements

The delete commands to delete queues and export processes have been simplified. The following are the new commands:

delete capture queue for datasource

delete export process to host [queue queuename]

delete export queue queuename

delete post queue queuename for datasource-datadest [cleartrans]

See the SharePlex Reference Guide for more information.

Support for IPv6

SharePlex now supports the IPv6 protocol. SharePlex automatically detects whether IPv4 or IPv6 is in use on a server.

Note:  See the System Requirements for platforms that were tested.


Deprecations in this release

This section contains a list of SharePlex items that were deprecated in this release line.

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.




  • The name of the SP_OCT_TARGET_COMPATIBILITY parameter has been changed to SP_SYS_TARGET_COMPATIBILITY.
  • The SP_XPT_ALTERNATE_HOST parameter is deprecated. To update the SharePlex configuration with the alternate IP address, run the provision utility. For more information, see the SharePlex Reference Guide.

Resolved Issues

Resolved Issues in this release

Resolved in version 9.0.1

Issue ID Description
SPO-3354 Issues with conflict resolution enhancement
SPO-3521 Fix SP_OPO_LOG_CONFLICT minor issue in 8.6.6
SPO-10270 Out sync for LOB data on Windows platform.
SPO-10493 OOS in datetimeoffset(0), time zone is wrong is target from sqlserver to sqlserver
SPO-10520 OOS on character data from SQL Server to Oracle
SPO-10565 oracle 10g : post core dump on varray
SPO-10605 Reader error : invalid data when activate vertical partition config of char.
SPO-10669 Missing asm_user and asm_password when asm tns_alias is supplied.
SPO-10699 Add Application Name to ODBC Connect Strings.
SPO-10740 SharePlex Manager reports export and import processes incorrectly if the shareplex version is 9.0.0.
SPO-10742 Replicate failed when delete data from Sqlserver capture to oracle target.
SPO-10808 Verify config on sql server capture generates too many sessions and not exit automatically.
SPO-10819 Turn compiler optimization on.
SPO-10821 Kafka target post crash recovery logic is broken for complete rollback
SPO-10826 Invalid SCN reported in conflict log.
SPO-10827 Fix HostPriority conflict resolution routine.
SPO-10871 Implement live parameters for SQL Capture.
SPO-10875 On Windows, ora_cleansp is still trying to truncate shareplex_routes table and fails


socket_test failed on HPUX long system name > 8 bytes

SPO-10912 When the target database fails a DML, OT post should provide a detailed source-target comparison in the post log.
SPO-10916 Issuing a Drop table on replicated table with parameter SP_OCT_ALLOW_DP_DDL=1 caused capture to core.


Compare server SIGSEGV.

SPO-11031 Post core dump processing SecureFile Compressed LOB
SPO-11084 Windows ora_cleansp should not truncate shareplex_routes or shareplex_wildcard
SPO-11091 Poster SIGSEGV when testing DDL/DML on tabs having varray on diff schema


Errors found in the event_log after upgrade SharePlex to 9.x.


Fix issue with SID case sensitivity exercised after upgrade.


Fix performance regression in sp_cnc processing of the compare command.


Repair did not clear statusdb because marker was sent to wrong post queue

Resolved in version 9.0

Issue ID Description
112521 Fixed an issue with ‘show config’ which occurs when ‘alter table’ and ‘create table’ DDLs are being processed
112522 Fixed an issue with ‘show config’ which occurs when ‘create/drop sequences’ DDLs are being processed



CR-112069 Added a parameter to not automatically update the configuration entry when a RENAME is encountered.
CR112117 Restart on log_wrap; retry on failure to find archive log in arch_loc.
CR-112244 Support ‘Comment on Column’ DDL
CR-112454 Route NOPs correctly for Hash Partitioned tables.



Failed to repair view table that got constraint violation
CR-112484 Enhancement for SQL Server alter table oracle number 1 ) number (without precision) to SQL server float 2) number(x;y) to sql server numeric(x;y)
CR-112503 Support sybase ntypes for Thai character set
CR-112513 Fix bug which caused updates with ‘not nullable’ columns to be filled with NULL




Fixed issues with DDL loopback in master/master setup
CR112520 Problem when Post processed Alter Table operation in the presence of Drop Table DDL with the same name.
SPO1489 implement 7.5/8.x NLS compatibility
SPO-2338 Rework system generated partition implementation
SPO-2443 Do not put SQL into errlog when in secure mode.
SPO-2444 Allow hidden password for ora_cleansp.
SPO-2457 When the event log reaches its maximum size, copy it to a sequenced filename and restart the event_log
SPO-2629 Fixed privilege issue in ppas_setup to RDS target
SPO-3079 Open Target Post fails when Sybase target is bigdatetime.
SPO-3592 Fix lost connection issue causing OOS
SPO-3954 In a PDB environment, the sync process failed when the ORACLE_SID did not match what is stored in the registry.
SPO-9719 Create table for autoadded tables were sent more than once if there was more than one line for an expanded route
SPO-9749 Fix oracle conversion big number such as 999e123


Support JSON format for Kafka

SPO-9997 Frequent checkpoints generated with ODR_UPDATE_INTERNAL for grant select operations when SP_OCT_REPLICATE_GRANT parameter was enabled.


Virus protection software on the server caused SNMP traps not to work


Unexpected LMN record caused capture failure


Capture failed when it saw drop table with comments followed by create table with comments.

SPO-10058, CR112522 Capture: ReconcileLog: failed to remove object cache, which caused the whole object-cache to be written to the object-cache during checkpoint duplicating the entries in the OCache log.


Reconcile created an oracle post object cache when it processes an activation


Compare and repair error (interval partition)

SPO-10144 Poster failed on partial rollback when updating shareplex trans table


Dropping a replicated sequence with autoadd sequence off caused object-cache to be updated


Capture failed due to regression from the initial fix.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating