SharePlex™ 9.0
Release Notes
Revision: 8/16/2017
New Features |
Deprecations |
Resolved Issues |
Basic system requirements |
System requirements for Oracle |
System requirements for SQL Server |
Known issues |
Product Licensing |
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 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.
For expert advice and the latest news about SharePlex, join the SharePlex Community at www.quest.com/community. Take advantage of our forums, blogs, videos, and more from our own experts, as well as input from our customers and partners.
This is a patch release with little or no new functionality.
The following new features are introduced in this release.
For more information about each of these features, see the documentation that is provided with this release.
The following content from the Administration Guide has been moved to the Installation Guide:
Additionally, the Installation Guide now includes the following new setup topics:
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:
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:
For objects, operations, and target/platform combinations that SharePlex supports when capturing from SQL Server, see the System Requirements. |
Installation |
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. |
SharePlex now supports replication to a MySQL target. Ther following new utilities support this target:
For more information about these utilities, see the SharePlex Reference Guide.
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.
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.
The following parameters were introduced.
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:
See the SharePlex Reference Guide for more information.
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.
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.
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.
Issue ID | Description |
---|---|
SPO-10740 | SharePlex Manager reports export and import processes incorrectly if the shareplex version is 9.0.0. |
SPO-10808 | Verify config on sql server capture generates too many sessions and not exit automatically. |
SPO-10781 | Investigate how SQL Server Replication is able to replicate tables with identity columns. |
SPO-10270 | Out sync for LOB data on Windows platform. |
SPO-10826 | Invalid SCN reported in conflict log. |
SPO-10827 | Fix HostPriority conflict resolution routine. |
SPO-10669 | Missing asm_user and asm_password when asm tns_alias is supplied. |
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-111905, CR-111920 |
Support SP_OCT_ARCH_LOC on ASM |
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. |
CR112476, SPO-3353 |
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 |
CR112519, 112518, 112520 |
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 |
SPO-9775 |
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. |
SPO-10041 |
Virus protection software on the server caused SNMP traps not to work |
SPO-10046 |
Unexpected LMN record caused capture failure |
SPO-10051 |
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. |
SPO-10094 |
Reconcile created an oracle post object cache when it processes an activation |
SPO-10108 |
Compare and repair error (interval partition) |
SPO-10144 | Poster failed on partial rollback when updating shareplex trans table |
SPO-10189 |
Dropping a replicated sequence with autoadd sequence off caused object-cache to be updated |
SPO-10267 |
Capture failed due to regression from the initial fix. |
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy