SharePlex - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
SharePlex Support Services
SharePlex Training Course
Troubleshoot slow post
SharePlex Starter
SharePlex Product Page
Contact Support
Contact Support

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2476
Shareplex installation fails with "ERROR: spo-query-oracle: Incompatible Oracle specification. (47822)

When installing Shareplex 6.x or up, one comes across the following error as given in the installation log: ERROR: spo-query-oracle: Incompatible Oracle specification (111 vs. 100). Shareplex is registering a wrong oracle binary . Resolution 1 : ...

Product(s): SharePlex for OracleNT, SharePlex
Last Updated On: 5/19/2017
(0 Ratings) 2257 views
Error "Poster: 15002 - Ora_setup has not been run for database "SID_name" " when configuring Shar (52604)

Post complained about ora_setup not run for the database and consequently no entry for login found in paramdb though the ora_setup was indeed run earlier and it ran successfully: Info 2009-03-23 16:25:22.759436 2649 1 ...

Product(s): SharePlex for OracleNT, SharePlex
Last Updated On: 5/18/2017
(0 Ratings) 2819 views
Capture and Read complaining about "OCISessionBegin failed with ORA-1034" (41201)

The Capture queue has 0 messages and does not grow though the "status" issued from sp_ctrl shows that it is running. The event log shows the following: sp_ctrl (wpst4002:2109)> show log reverse. 03/27/08 16:34 Warning: 12035 - OCISessionBegin failed with ORA-1034. ...

Product(s): SharePlex
Last Updated On: 5/18/2017
(0 Ratings) 2417 views
The ora_chpwd results in error "can't log into Oracle as SYSTEM" and "perhaps SID is not correct" (184628)

The below errors are observed when running ora_chpwd: Please enter the SID where SharePlex is installed [OracleSID] : OracleSID. In order to change the password for the SharePlex user account,. we must connect to the database as DBA user. ...

Product(s): SharePlex
Last Updated On: 5/18/2017
(0 Ratings) 888 views
Is it possible to serialize the “copy using” command (104815)

When the command “copy using” is issued, it will sync multiple tables at a given time, depending on the # of tables in the config file upon which the command is operated. Ideally this is the optimum approach. At times customers ...

Product(s): SharePlex
Last Updated On: 5/17/2017
(0 Ratings) 6 views
Do compare log out of sync entry in status database if the table is found to be out of sync? (229204)

In the process of identifying hidden out of sync on tables and keeping a log of the findings, one may want to know if compare can be used to update the out of sync entries in the statusdb (status database) for tables discovered by compare to be out of sync. General information. ...

Product(s): SharePlex
Last Updated On: 5/17/2017
(0 Ratings) 3 views
Compare running slow. (18765)

Compare is running slow. One or more reasons can slow down the compare at the time you are running compare. See resolution below. One or more of the followings, but not limited to, can slow down the compare while it is ...

Product(s): SharePlex
Last Updated On: 5/17/2017
(0 Ratings) 2015 views
How to check for details on builds of various Shareplex binaries including one-off patch if any? (64837)

How to check for details on builds of various Shareplex binaries including one-off patch if any. General information. There is a program named sp-bininfo that provides the information about the build # of a binary, its one-off status ...

Product(s): SharePlex
Last Updated On: 5/16/2017
(0 Ratings) 2099 views
Config file limitiations (48254)

What are the config file limitations in terms length of each entry and total number of tables? Activation may fail if the config file has too many tables, too many routes, too many columns, or each entry is too long. Shareplex 7.5 ...

Product(s): SharePlex for OracleNT, SharePlex
Last Updated On: 5/16/2017
(0 Ratings) 1914 views
Where can I find the current version of Shareplex for Oracle (131487)

Where can I find the current version of Shareplex for Oracle Need to download the current version of Oracle. You can download the current version of Shareplex from the support site. https://support.quest.com/shareplex-for-oracle ...

Product(s): SharePlex
Last Updated On: 5/12/2017
(0 Ratings) 5 views
Post core dumps using a dedicated non-replication DDL queue (229377)

Post core dumps after directing DDLs to a non-replication DDL Post Queue. Event Log error: Post o.ORA11G-ddl_q o.ORA11G Stopped - core dumped. Error 2017-05-11 01:00:00.000000 12345 123456789 Poster killed due to SIGSEGV. ...

Product(s): SharePlex
Last Updated On: 5/12/2017
(0 Ratings) 7 views
When tried to install shareplex service on the window 2008, "Server error" message showed in "Current Service" box under service tab of SpUtils (225947)

Fresh installation of SharePlex on windows 2008. Installation completed with no errors. When trying to create the service in SpUtils under the services tab, "Current Service" box shows the message "server error" and there is no install button shown to install the service. ...

Product(s): SharePlex
Last Updated On: 5/12/2017
(0 Ratings) 3 views
Is it possible for SharePlex to replicate only committed data (223634)

Is it possible for SharePlex to replicate only committed data? General information. There is no feature in SharePlex that would allow only committed data to be replicated. To reduce latency at the target, SharePlex replicates changes from source without waiting for COMMITs. ...

Product(s): SharePlex
Last Updated On: 5/11/2017
(0 Ratings) 184 views
Is there any debug flag for troubleshooting ora_setup? (228349)

Is there any way to debug the running of ora_setup to get more details on the events leading to its failure? General information. No, but the oracle errors appearing during the running of ora_setup should be helpful in troubleshooting. ...

Product(s): SharePlex
Last Updated On: 5/11/2017
(0 Ratings) 2 views
How do Shareplex replicate a DML that refers to a pseudocolumn on source side? (178239)

It is possible to formulate a DML that references a pseudocolumn on source side. This article explains how the DML is replicated to the target side, given that pseudocolumn was used to construct it on the source. General information. ...

Product(s): SharePlex
Last Updated On: 5/11/2017
(0 Ratings) 2 views
How to run compare in a peer to peer (master-master) replication environment (33078)

Compare command is designed to correct out of sync conditions on tables in a replication environment used for reporting. The reason being that when compare is run, it assumes that the target table will not be locked exclusively ...

Product(s): SharePlex
Last Updated On: 5/11/2017
(0 Ratings) 750 views
No compare server running and compare client exists on target with event log message “Error, lock file not found” and “Error: compare server is not responding; pipe broken” (228348)

No compare server is running and compare client exists on target with event log message “Error, lock file not found” and “Error: compare server is not responding; pipe broken” as the following event log entries on target show: sp_ctrl (server_name:2100)> show log reverse. ...

Product(s): SharePlex
Last Updated On: 5/11/2017
(0 Ratings) 1 views
How to know in advance which tables will be in replication when using wildcards (109959)

It is quite a challenge to know what tables will replicate after activating a config file that has wildcards, depending on how many tables qualify. General information. Issue “verify config <config_file_name>” from source sp_ctrl. ...

Product(s): SharePlex
Last Updated On: 5/11/2017
(0 Ratings) 5 views
Compare running out of temp space. (18579)

Compare is running out of temp space and I don't have extra space to add. Not enough temp space. Normally, compare will double the size of the table for temp space. If you don't have extra space to add, there are two options ...

Product(s): SharePlex
Last Updated On: 5/11/2017
(0 Ratings) 1619 views
Is it possible to control the structure and other DDL features of target table with autoadd (107729)

Is it possible to control the structure and other DDL features of target table during its creation when using auto add feature. General information. It is not possible to control what will be the target table structure or its storage and ...

Product(s): SharePlex
Last Updated On: 5/11/2017
(0 Ratings) 2 views
SharePlex does not fill in NULL for INSERT (229190)

On source, insert null into some columns and on target with open post writing out to xml file for Kafka it does not show the column with NULL value for this insert statement. insert into cdc values(958686,null,33,null); Result: <?xml version="1.0" encoding="UTF-8"?>. ...

Product(s): SharePlex
Last Updated On: 5/10/2017
(0 Ratings) 3 views
VIDEO - How to create and activate a basic config file (119857)

This video describes how to create and activate a basic config file. See the video below:

Product(s): SharePlex
Last Updated On: 5/4/2017
(0 Ratings) 5039 views
Capture: 12010 - error getting obj# for SHAREPLEX_CONFIG table due to ORA-01031: insufficient privileges (225852)

The following Capture errors are observed when Oracle is upgraded from 11g to 12c: Info 2017-02-07 15:41:06.129886 21281 1 Capture exited with code=1, pid = 21289 (capturing from sourceSID). Error 2017-02-07 15:41:06.113592 ...

Product(s): SharePlex
Last Updated On: 5/1/2017
(0 Ratings) 1 views
Read error 11000 - sp_ordr failed: can't peek at queue (225682)

The Read errors out and the following messages are observed in event_log: Error 2017-01-30 10:11:39.206000 4280 16888 Reader: 11000 - sp_ordr failed: can't peek at queue (from sourceSID) [module ord]. At times this can ...

Product(s): SharePlex
Last Updated On: 5/1/2017
(0 Ratings) 1 views
CREATE or DROP TRIGGER on tables in replication can now be replicated starting with SharePlex 8.6.6 (225342)

Starting with SharePlex 8.6.6, the CREATE or DROP TRIGGER DDL on tables in replication can be replicated. General information. The following steps are required: On source database set the following Capture parameter and bounce Capture: ...

Product(s): SharePlex
Last Updated On: 5/1/2017
(0 Ratings) 4 views