SharePlex - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
SharePlex Kafka replication
SharePlex Training Course
Troubleshoot slow post
SharePlex Starter
SharePlex Product Page
Contact Us
Technical Support
View All

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2655
How to have the same transaction ignored by multiple instances of Shareplex? (76054)

At times a source database may be accessed by multiple instances of Shareplex. This solution delves on how to ignore a transaction for multiple instances of Shareplex. General information. There are two ways to deal with this and each has its own pros and cons. ...

Product(s): SharePlex
Last Updated On: 6/14/2018
(0 Ratings) 2261 views
General housekeeping involving log directory of Shareplex. (41258)

General housekeeping involving log directory of Shareplex. The log subdirectory of Shareplex variable directory (also called vardir and is pointed to by the environment variable SP_SYS_VARDIR) contains logs for various Shareplex processes. ...

Product(s): SharePlex
Last Updated On: 6/12/2018
(0 Ratings) 2134 views
Compare hang waiting for lower case *declt*.lck file while ora_setup is using lower case tns alias (257878)

Replication is working fine but compare hangs. When ora_setup is run with lower case tns alias or SID, but config file is using upper case for @o.SID or @o.TNSALIAS. In that case ora_setup would create a lower case entry in database line in connections.yaml file. ...

Product(s): SharePlex
Last Updated On: 6/11/2018
(0 Ratings) 4 views
How to exclude certain DDL operations from replication. (92094)

How to use SHAREPLEX_DDL_CONTROL to exclude certain DDL operations on NON-REPLICATION objects. RESOLUTION. New feature since version 7.6. SHAREPLEX_DDL_CONTROL table has DDL_CODE column which can be used to exclude certain ddl operations. ...

Product(s): SharePlex
Last Updated On: 6/7/2018
(0 Ratings) 5062 views
SharePlex 8.6.x connections options to ASM instance (147676)

Starting with SharePlex 8.6 and above, users have an option to choose either BEQUEATH method or tns_alias method to connect to the ASM instance. This KB describes in detail on how to choose them. N/A Resolution: 1. By ...

Product(s): SharePlex
Last Updated On: 6/7/2018
(1 Ratings) 4596 views
How to install SharePlex for Oracle RAC (136773)

Quick start to install and configure SharePlex in Oracle RAC environment. Instructions. 1. Install SharePlex Product Directory (PRODDIR) and Variable Directory (VARDIR) on a shared drive. 2. Set Static Virtual IP (VIP) for SharePlex. ...

Product(s): SharePlex for OracleNT, SharePlex
Last Updated On: 6/7/2018
(0 Ratings) 5919 views
VIDEO - How to set up CDC - Capture Change Tracking (107058)

This video describes how to set up CDC - Capture Data Change, otherwise known as Capture Change Tracking. in SharePlex version 8.0.1 and later versions. See the video below:

Product(s): SharePlex
Last Updated On: 6/7/2018
(0 Ratings) 7196 views
VIDEO - ora_setup utility in SharePlex (139833)

This video introduces the ora_setup utility in SharePlex and details its functionality with a demo. Ora_Setup utility is modified and starting Version 8.6, a new option to connect to ASM instance using TNS is added. Refer to the video below for more details:

Product(s): SharePlex
Last Updated On: 6/7/2018
(0 Ratings) 6088 views
Procedure to sync the target database using Oracle Export / Import and flashback_scn option (127763)

Starting with Oracle 9i, it is possible to take an Export of a database which is consistent for a specified SCN. This opens door for its use in conjunction with Shareplex to resync a target database, especially when the source database ...

Product(s): SharePlex
Last Updated On: 6/7/2018
(0 Ratings) 3711 views
How to set up Host Priority based conflict resolution with SharePlex 8.6.4 and above? (205846)

Starting SharePlex 8.6.4 and above, a default conflict resolution based on host priority is introduced for peer to peer replication. New feature. RESOLUTION: Prerequisite: Enable supplemental logging for pk, uk, fk on both servers ...

Product(s): SharePlex
Last Updated On: 6/7/2018
(0 Ratings) 3022 views
VIDEO - How to Upgrade SharePlex for Oracle (97853)

Demonstration of the SharePlex for Oracle upgrade procedure. Video below explains the upgrade procedure.

Product(s): SharePlex
Last Updated On: 6/7/2018
(0 Ratings) 5185 views
How to get started with SharePlex (115476)

What is SharePlex? When to use SharePlex? How to install SharePlex? Where to get help on SharePlex? Information. WHAT: · How SharePlex Works. · Video: SharePlex Architecture in English. · SharePlex Architecture in Spanish and Chinese. · Advantages of SharePlex. WHEN ...

Product(s): SharePlex
Last Updated On: 6/7/2018
(0 Ratings) 10360 views
Poster: ORA-01461: can bind a LONG value only for insert into a LONG column (132447)

Post stopped and queue backlogged. Event_log error: Poster: ORA-01461: can bind a LONG value only for insert into a LONG column. (posting from , queue , to ) [module osp]. NLS character set differences between source and target. ...

Product(s): SharePlex
Last Updated On: 6/5/2018
(0 Ratings) 5 views
VIDEO - How to do basic troubleshooting with SharePlex (92663)

Basic process of troubleshooting SharePlex issues Upon completion of this video, you should be able to: •Determine the SharePlex module that is experiencing the issue. •Locate the error message. •Search Support Link and SharePlex documentation for the error message. ...

Product(s): SharePlex
Last Updated On: 6/4/2018
(0 Ratings) 6004 views
VIDEO - SharePlex architecture, its processes and queues. (92662)

Discussion of SharePlex architecture, its processes and queues. This video elucidates the SharePlex architecture, its processes and queues. It also describe how the processes work together to replicate data and then will expound each process and each queue individually.

Product(s): SharePlex
Last Updated On: 6/4/2018
(1 Ratings) 7535 views
Command server: 12032 - OCIServerAttach failed with ORA-12170 (255835)

The following messages are observed in event_log: Error 2018-05-15 17:02:02.452532 29997 3533290256 Command server: 12032 - OCIServerAttach failed with ORA-12170. (connecting from <name>) [module osp]. Notice ...

Product(s): SharePlex
Last Updated On: 5/30/2018
(0 Ratings) 4 views
Capture process uses large amount of memory. Or is running into core dump while complaining about log wrap though archive logs do exist (104864)

Capture Process is uses too much memory. At times the symptoms are slightly different, as the following log wrap errors are seen in event_log followed by a core dump even though the archive logs exist and Capture was earlier ...

Product(s): SharePlex
Last Updated On: 5/30/2018
(0 Ratings) 2048 views
Unable to start SharePlex services from sp_util (255159)

Installed SharePlex proddir binaries in mapped network drive, not local drive, on Windows OS. Starting SharePlex services from sp_util starts the services then stops it. Windows services can't access mapped drives WORKAROUND 1. ...

Product(s): SharePlex
Last Updated On: 5/30/2018
(0 Ratings) 14 views
How to do cleansp for Kafka Target (254252)

There is a time that Kafka target needs to be cleared up for whatever reason. This article describes how to do so. N/A Resolution: For Kafka target, we do not have any SharePlex internal tables that control SharePlex Kafka target ...

Product(s): SharePlex
Last Updated On: 5/30/2018
(0 Ratings) 5 views
What is the use of the parameter SP_OCF_FK_ANALYSIS? (234678)

What is the use of the parameter SP_OCF_FK_ANALYSIS? General information. The parameter is used to as follows. The parameter, if set to its default value of 1, will force SharePlex activation process to do the Foreign Key analysis for tables being brought in to replication. ...

Product(s): SharePlex
Last Updated On: 5/29/2018
(0 Ratings) 1 views
Import: No such file or directory rename failed (256555)

Event_log on target shows below error but import processes are still running. Import: No such file or directory rename failed - see event_log for details (importing from queue xxx) [module sys]. run truss on sp_cop process with ...

Product(s): SharePlex
Last Updated On: 5/25/2018
(0 Ratings) 7 views
Adding SharePlex license key. (194)

How to replace the existing key with a new permanent license key or trial key. Information. This procedure assumes that a license key for Shareplex has been received. The splex_add_key executable is used to add the key or replace the existing key. ...

Product(s): SharePlex
Last Updated On: 5/18/2018
(0 Ratings) 3596 views
The repair gives error "cannot open object cache for active config" (233499)

Following error messages are seen when running a repair: sp_ctrl> repair "OWNER"."TABLE_NAME". repair " OWNER "." TABLE_NAME ". Cannot open object cache for active config. See the event_log for details. The above error messages can also show up for compare. ...

Product(s): SharePlex
Last Updated On: 5/18/2018
(0 Ratings) 20 views
VIDEO - How to configure replication to Kafka target (224909)

This video delves on configuring replication to a Kafka target. This video deals with: Prerequisites to setup replication to Kafka Target. Setting-up SharePlex to replicate to Kafka Target. Creating configuration file. Configuring SharePlex post process to connect to Kafka. ...

Product(s): SharePlex
Last Updated On: 5/17/2018
(0 Ratings) 1219 views
Update on partition key with row movement on parent table causing OOS on child table with trigger (255540)

Scenario: Parent and child table with delete cascade enabled and row movement enabled on parent table. There is after insert trigger on parent to insert into child record. When update on parent table partition key column causing ...

Product(s): SharePlex
Last Updated On: 5/14/2018
(0 Ratings) 21 views