What's new for SharePlex

August 2017

Subscribe to the RSS


Top

Documentation

New

None at this time

Revised

None at this time

Top

Patches

New

None at this time

Revised

None at this time

Top

New

None at this time

Revised

None at this time

Top

New
232391 - [SP-COM01011] The ORACLE_HOME environment variable is not set.

SharePlex is highly linked to the Oracle binaries of the Database that is going to replicate, even with an open target it is necessary to have...

Created: August 25, 2017
232284 - Post fails on Target for the Horizontally partitioned table setup to replicate to Open Target

Post fails when trying to replicate a horizontally partitioned table to an Open Target target server. It throws garbage data in the event_log...

Created: August 22, 2017
232414 - The ALTER TABLE to ADD PRIMARY KEY does not update the object cache on target

When a Primary key is added to the source table, the target table does not get updated with this DDL, despite the DDL replication turned on. The...

Created: August 26, 2017
232339 - What happens if you cancel out a long running activation

When you activate a config, it takes some time for the sp_ctrl to return the control back to the issuer. This time typically depends on the # of...

Created: August 24, 2017
232337 - Shareplex fails to start after installation because mfc100.dll is missing

After installing shareplex, SpUtils.exe fails to start with the error "The program can't start because mfc100.dll is missing...

Created: August 24, 2017
232412 - Compare server Oracle 11.1.0.6 to 11.2.0.2 do not support SELECT with a parallel hint. Set the SP_DEQ_PARALLELISM parameter to 0 for those Oracle versions

The following warning messages are observed when running a compare: sp_ctrl> show log reverse Info     2016-12-09 12:09...

Created: August 25, 2017
232492 - How to safely activate the currently active config file without causing disaster by way of lost activation

At times it is required to activate the same config file. The reasons are numerous. One common reason is to update the object cache on source and...

Created: August 30, 2017
232298 - The ora_cleansp or ora_setup prompts auto populate with "\c".

When running ora_cleansp or ora_setup, the prompts auto populate with "\c" without any action on the part of the user. Here is a sample...

Created: August 23, 2017
232489 - Error “Poster: Oracle error: ORA-00942: table or view does not exist” in CDC environment even though the table does exist on target

The Post is stopped due to error and the following messages appear in the event_log in a CDC (Change Data Capture or Change History) environment...

Created: August 29, 2017
Revised
232058 - What is the difference between “abort config” and “ora_cleansp”

These two commands achieve somewhat similar goals but with some subtle differences. This article attempts to address them. 

Revised: August 23, 2017
232059 - Is it possible to assign priority to Post queues so that one Post queue can apply its data sooner than another one?

At times the question or need arises as to whether it is possible to have one Post queue apply its transactions/operations sooner than another...

Revised: August 23, 2017
215457 - What is the use of the Repair option “insertonly”

Starting with SharePlex 8.6.3 and up, the repair command now has a new option “insertonly”. This article illustrates the functioning...

Revised: August 23, 2017
124027 - How much space is required in rim directory to hold captured data when target is shutdown.

When Shareplex or database on target is shutdown, the source Shareplex or target Shareplex (in case of latter) will keep gathering changes from...

Revised: August 22, 2017
230007 - The command "add partition to <scheme_name>" results in "Invalid specitication; not in key=value format"

The following errors occur when issuing the command to add a partition to a partition scheme: sp_ctrl (alvsupu15:5438)&gt; add partition to...

Revised: August 27, 2017
231505 - SQL Server login failed

SQL Server login failed

Revised: August 16, 2017
104409 - VIDEO - How to Install SharePlex for Oracle on Windows

Demonstration of the SharePlex for Oracle on Windows installation procedure

Revised: August 28, 2017
104409 - VIDEO - How to Install SharePlex for Oracle on Windows

Demonstration of the SharePlex for Oracle on Windows installation procedure

Revised: August 28, 2017
232338 - Non conversion to Scientific notation for number column in KAFKA

Replicate source number type to target as is, without converting it into enotation like 6.8050526636390530E+16&nbsp;

Revised: August 30, 2017
40929 - Preinstallation for Solaris 10

Preinstallation for Solaris 10

Revised: August 30, 2017
92662 - VIDEO - SharePlex architecture, its processes and queues.

Discussion of SharePlex architecture, its processes and queues

Revised: August 23, 2017
92662 - VIDEO - SharePlex architecture, its processes and queues.

Discussion of SharePlex architecture, its processes and queues

Revised: August 23, 2017
184626 - Does Shareplex support replication to or from an RDS Oracle instance in AWS

Does Shareplex support replication to or from an RDS Oracle instance in AWS?

Revised: August 28, 2017
215443 - Zero byte output file from sp_ctrl command redirecting on window server

Trying to redirect sp_ctrl command output to the file on window server, but got zero byte for the output file. For example: /proddir/bin/sp_ctrl...

Revised: August 22, 2017
230006 - SharePlex upgrade fails with “ERROR tpm spo-collect-legacy-instances closed stream”

When SharePlex 9.0.243 (which was a Beta version) was already installed and it was attempted to be upgraded to SharePlex 9.0.0.6 (a mainstream...

Revised: August 22, 2017
231276 - After upgrade how does Shareplex deal with deprecated parameters that exist in paramdb file

Shareplex parameters are deprecated at times. Since any parameter setting that is different from the default is stored in the paramdb file, when a...

Revised: August 22, 2017
231316 - The compare or repair errors out with Cannot compare horizontally partitioned by HASH table

The following errors are observed when running compare on a table involved in horizontal partitioning with hash: sp_ctrl (alvsupu15:5438)&gt...

Revised: August 22, 2017
229616 - The “show capture detail” returns a status of “waiting for logfile”

The &ldquo;show capture detail&rdquo; returns a status of &ldquo;waiting for logfile&rdquo;

Revised: August 21, 2017
229766 - The command “drop partition scheme <scheme_name>” results in error “partition scheme <scheme_name> does not exist”

The following errors occur when issuing the command to drop a partition scheme: sp_ctrl (alvsupu15:5438)&gt; drop partition scheme scheme2...

Revised: August 21, 2017
231317 - The compare with force option

The following errors are observed &nbsp;&ldquo;compare force&rdquo; is issued on a table that exists in the source and target database and is not...

Revised: August 22, 2017
229417 - Creating horizontal partition configuration using sp_ctrl without having to login to the source database

SharePlex 9 and up allows the horizontal partitioned replication to be configured via sp_ctrl without having to do the DML entries for the various...

Revised: August 23, 2017
230938 - Is it possible to repair or compare a table from a given SCN onwards?

Is it possible to repair or compare a table from a given SCN onwards?

Revised: August 23, 2017
231189 - Waring "Cannot replicate to or from schema "SYS" encountered during activation

When try to activate config, following warning showed up in event_log: &quot;Warning &nbsp;2017-07-11 14:27:30.343700 2567 670348560 Activation...

Revised: August 23, 2017
231168 - How to speed up the posting of UPDATEs on target?

When Post processes an UPDATE, by default it builds a where clause that not only includes the key value but also includes the before values (pre...

Revised: August 23, 2017
105706 - Poster Error: ORA-00607 and ORA-00602

The following errors are received by Post: Notice   2013-03-11 15:34:55.165374 3476 6 s:2 Poster: ORA-00607: Internal error occurred while...

Revised: August 23, 2017
40307 - INTERNAL - How to ignore DELETE on a table

There are times when you just want to ignore a certain type of DML, in our case it is DELETE.

Revised: August 25, 2017
231317 - The compare with force option results in error “Cannot compare owner.table_name, required information is missing” “Missing target host name” and “Missing target SID”

The following errors are observed &nbsp;&ldquo;compare force&rdquo; is issued on a table that exists in the source and target database and is not...

Revised: August 27, 2017
230937 - Does Antivirus software installed on target/source systems affect SharePlex?

Does Antivirus software&nbsp; installed on target/source systems affect SharePlex?

Revised: August 22, 2017
Top

Product Life Cycle

New

None at this time

Revised

None at this time

Top

Notifications

New

None at this time

Revised

None at this time

Please note our Privacy Policy recently changed to support GDPR. You may read it here. Continuing to use our website indicates you have accepted the new policy.