What's new for SharePlex

June 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
230809 - The “repair” errors out with “Table OWNER.TABLE_NAME is not in replication, use force option to repair”

The following error messages are observed when attempting to repair a table that is not in replication: sp_ctrl repair OWNER.TABLE_NAME Table...

Created: June 26, 2017
230491 - The activate config results in “cnc_activate() File does not exist”

The following errors are observed when activating a config: sp_ctrl (alvsupu15:5438)> activate config config_name    cnc...

Created: June 16, 2017
230783 - What is "force" option in compare

Compare has a "force" option for tables not in replication and this article delves on this option. 

Created: June 26, 2017
230888 - What do the log *oconf* contain?

The log *oconf* is generated during activation. This article explains the content of this log. 

Created: June 28, 2017
230892 - Is it possible to selectively replicate tables on the basis of criteria like object type, datatype, etc?

Customers want to know if they can direct SharePlex to only replicate tables that qualify under some criteria like object type, datatype, date...

Created: June 29, 2017
Revised
114509 - Does SharePlex lock or analyze tables during reactivation

At times the same config file need to be activated once again. It is important to   know if Shareplex locks the objects already in...

Revised: June 26, 2017
138930 - Post stopped due to ORA-00060

Post stopped with following errors: "Notice   2014-11-04 19:59:59.393863 13486 1088403776 s:4 Poster: ORA-00060: deadlock...

Revised: June 19, 2017
230480 - How to setup Oracle to MySQL Replication

Demo of  quick replication between Oracle to MySQL.

Revised: June 27, 2017
115476 - How to get started with SharePlex

What is SharePlex?      When to use SharePlex?        How to install SharePlex?       Where to get help on SharePlex?      

Revised: June 16, 2017
115853 - How to Upgrade SharePlex

How to upgrade SharePlex to a newer version of SharePlex?

Revised: June 16, 2017
115853 - How to Upgrade SharePlex

How to upgrade SharePlex to a newer version of SharePlex?

Revised: June 16, 2017
18270 - Ora_setup failed with invalid username/password

Ora_setup fails due to invalid username/password. Error in the event_log: 2909681504 OID E+ora_setup: 12026 - OCIEnvInit failed with ORA-90002...

Revised: June 19, 2017
116520 - Since compare parameters are live, do they take effect immediatelyr when changed?

When compare parameters are changed, do they take effect immediately?

Revised: June 20, 2017
230260 - How to preserve the compatibility, when replicating between different versions of SharePlex?

This solution clarifies the difference between SP_SYS_TARGET_COMPATIBILITY and SP_OCT_TARGET_COMPATIBILITY parameters and their usage.

Revised: June 16, 2017
115853 - How to Upgrade SharePlex

How to upgrade SharePlex to a newer version of SharePlex?

Revised: June 21, 2017
115853 - How to Upgrade SharePlex

How to upgrade SharePlex to a newer version of SharePlex?

Revised: June 21, 2017
229419 - The delete queue command results in error “Cop: delete queue failed: que_INUSE: Que is already open

The following error are observed when attempting to delete a queue using the command “delete queue <queue_name>: sp_ctrl (alvsupu16...

Revised: June 19, 2017
229416 - The delete queue command results in error “Cop: delete queue failed: que_NOEXIST: Queue does not exist”

Following errors are observed when attempting to delete a queue using “delete queue” command: sp_ctrl (alvsupu16:5438)> delete...

Revised: June 19, 2017
229540 - Cancelling a job results in "job is not active"

When customer issued the command "cancel <jobid>", it  resulted in "Job <jobid> is not active".  However...

Revised: June 19, 2017
229580 - The row count differs across source and target tables but “show sync” shows that the table is in syn

Users determine that the row count differs across source and target tables but “show sync” shows that the table is in sync. This...

Revised: June 19, 2017
112432 - What is the use of the compare parameter SP_DEQ_LOCK_WAIT

This solution delves on the nuances of the setting of the parameter SP_DEQ_LOCK_WAIT.

Revised: June 27, 2017
224956 - What do the value “DEPRECATED” in the “Set At” field of “list param modified” signify?

When you issue “list param modified”, you come across a value “DEPRECATED” under the field “Set At”: sp...

Revised: June 19, 2017
225146 - How to find out the unwanted Post queues from numerous Post queues for the purpose of removing them

How to identify the unwanted Post queues from numerous Post queues for the purpose of removing them?

Revised: June 19, 2017
225147 - How to enable horizontally partitioned replication with named queues for a table already in normal replication with no named queue architecture.

How to enable horizontally partitioned replication with named queues for a table already in normal replication with no named queue architecture.

Revised: June 19, 2017
225277 - Do SharePlex processes execute any DML in the source database?

Do SharePlex processes execute any DML in the source database?

Revised: June 19, 2017
225466 - How the parameter SP_OPO_SAVE_OOS_TRANSACTION works

How the parameter SP_OPO_SAVE_OOS_TRANSACTION works.

Revised: June 19, 2017
226366 - How SharePlex handles DDL replication in an open target environment?

Is DDL replication supported in Open Target environment?

Revised: June 19, 2017
226446 - Do SharePlex keep record of the redo logs processed by it?

<cause> Do SharePlex keep track of the redo logs processed by it? </cause>

Revised: June 19, 2017
228110 - Compare client errors out with ORA-01114

The following errors are observed in target event log when compare/repair is run on a table: Notice&nbsp;&nbsp; 2017-04-03 04:29:58.523911...

Revised: June 19, 2017
228246 - Error “Capture: 10722 - can't open capture queue que_ERR: Non specific error” and “Capture: No such file or directory que_open.open_fd”

The following messages are seen in event_log when Capture stopped due to error: sp_ctrl &gt; show log reverse Info&nbsp;&nbsp;&nbsp;&nbsp...

Revised: June 19, 2017
228300 - Note: Cannot install Compare Varray package because Oracle Spatial datatype is not installed.

When running ora_setup, the following notice/warning appear as the screen shot below shows: &quot;Loading Compare Package from &quot;/sw...

Revised: June 19, 2017
228346 - Why replication is not supported from a Materialized View (MV) on source to a Materialized View on target?

Why replication is not supported from a Materialized View (MV) on source to a Materialized View on target?

Revised: June 19, 2017
228347 - Will disabling of DDL replication interfere with SP_OCT_AUTOADD_ENABLE and wildcards

For customers that do not replicate any form of DDL, a very valid question arises as to whether SharePlex will still create the tables on target...

Revised: June 19, 2017
229046 - How does the commit reduction work in Post Enhanced Performance (PEP) feature

Starting with SharePlex 8.6, a new feature named Post Enhanced Performance (PEP) has been introduced. The PEP feature helps greatly improve Post...

Revised: June 19, 2017
229206 - What are the implications of leaving the parameters set to their changed values once the errors or problem conditions have been bypassed and no further errors are forthcoming?

There are numerous parameters in SharePlex which are set to get past a problem or error condition. Usually they are unset by users once the issue...

Revised: June 19, 2017
228247 - The number of messages in Export queue are huge and not going down though backlog is 0

SharePlex is replicating to one or more target. The replication to one or more of these is working fine but the number of messages in Export queue...

Revised: June 19, 2017
228250 - What do messages "Poster: Parameter SP_OPO_CONF_LOG is deprecated; use SP_OPO_LOG_CONFLICT" imply?

The following notice appears in the event log: Notice&nbsp;&nbsp; 2017-03-28 10:29:09.203154 17178 1 Poster: Parameter SP_OPO_CONF_LOG is &nbsp...

Revised: June 19, 2017
185820 - Errors “Poster 12070 - OCITransCommit failed with ORA-12008” and “error in materialized view refresh path.ORA-00942 table or view does not exist”

The&nbsp; following errors are seen in target event_log when a materialized view exists on target where the underlying table may or may not be a...

Revised: June 19, 2017
34799 - Setup SharePlex to utilize Oracle Shared Server (MTS)

By default SharePlex is using the BEQ protocol connecting to the database. If you want to change this to use your Shared Server setup, you will...

Revised: June 19, 2017
212609 - How to set up SharePlex replication to Kafka?

How to set up SharePlex replication to Kafka?

Revised: June 20, 2017
198 - How to uninstall Shareplex

How to Uninstall SharePlex on Unix / Linux / Windows.

Revised: June 16, 2017
Top

Product Life Cycle

New

None at this time

Revised
Product Life Cycle -SharePlex

Revised: June 23, 2017
Top

Notifications

New
Quest Support Product Release Notification - SharePlex 9.0

Type: Release Created: June 26, 2017
Revised

None at this time