Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

SharePlex 9.2.6 - Administration Guide

Table of Contents

About this Guide Conventions used in this guide Overview of SharePlex

Advantages of SharePlex About source and target data About SharePlex architecture How SharePlex replication works Understanding the concept of synchronization Strategies for information availability

Run SharePlex on UNIX Run SharePlex on Windows

Run multiple instances of SharePlex

Run multiple instances of SharePlex from separate installations Run multiple instances of SharePlex from one installation

Execute commands in sp_ctrl

How to run sp_ctrl Define a default port for sp_ctrl Define a default host for sp_ctrl Set a default editor for sp_ctrl Command guidelines Issue commands on a remote system Issue commands for a clustered system Add a scroll bar to output on Windows

Set SharePlex parameters

Set and activate parameters Where parameter information is stored

Configure data replication

Ensure compatible source-target mapping Create a configuration file How to qualify object names How to specify case-sensitive names Database specifications in a configuration file Target specifications in a configuration file Routing specifications in a configuration file Configuration examples Capture from multiple local datasources Use Wildcards to specify multiple objects Define a unique key Filter DML operations Map source columns to target columns Build a configuration file using a script

Configure replication to and from a container database

Replicate to and from a PDB

Configure named queues

Configure named export queues Configure named post queues

Configure partitioned replication

Configure horizontally partitioned replication Configure vertically partitioned replication

Configure replication to a change history target

Overview of the change-history target Configure change history

Configure a replication strategy

Configure Replication to share or distribute data Configure Replication to maintain a central data store Configure peer-to-peer replication Configure Replication through an intermediary system Configure Replication to maintain high availability

Configure DDL replication

DDL that SharePlex supports Enable DDL replication Filter DDL Replication Best practices for ALTER TABLE DDL DDL logging and error handling

Configure error handling

Continue to Post when there is an error Continue to Post on DDL errors Increase the number of retries on error Handle transactions that contain out-of-sync operations

Configure data transformation

Overview of transformation Considerations when using transformation Deploy transformation

Configure security features

Secure data with SSL/TLS Host Authentication Secure data with SSH Encrypt data between Export and Import Assign SharePlex users to security groups

Overview of SharePlex security groups Create and populate SharePlex groups on Unix and Linux Create and populate SharePlex groups on Windows

Start replication on your production systems

What is activation? Activation commands Requirements for activating a configuration Test the configuration before activation Frequently Asked Questions about activation How to activate multiple configuration files Activate replication with an Oracle hot backup on an active database Activate replication with an Oracle hot backup on a quiet database Activate replication with Oracle transportable tablespaces Activate replication with cold copy/transfer methods Activate replication from Oracle to Open Target

Monitor SharePlex

View and kill SharePlex processes View events and errors Monitor with sp_ctrl commands Run monitor scripts on UNIX

Monitor Oracle capture with sp_logmon Monitor events with sp_eventmon Monitor processes with sp_ps Monitor queues with sp_qstatmon

Run a monitor script on Windows Monitor with SNMP

Prevent and solve replication problems

Find the problem in the SharePlex Knowledge Base Solve database setup problems Solve configuration file problems Solve activation problems Solve replication problems Solve Oracle DDL replication problems Solve queue problems Solve synchronization problems Solve compare command errors Solve other problems How to resynchronize source and target objects How to restore Oracle archive logs How to release semaphores after process failure How to resolve disk space shortage How to find the ORACLE_SID and ORACLE_HOME

Repair out-of-sync data

Overview of Compare and Repair Before you use Compare and Repair How to use the repair and compare commands

Tune the Capture process

Disable LOB Mapping Tune Capture on Exadata Tune Checkpointing Add a second thread

Tune the Post process

Use INDEX hints Tune SQL Caching Adjust open cursors Skip maintenance DML Make small transactions faster Split a large transaction into a smaller one Tune queue performance Tune hash-based horizontally partitioned replication

Recover replication after Oracle failover

Recover replication if the primary system fails Recover replication if the secondary Oracle instance fails Move replication during planned failover and failback Resume replication after failure and recovery

Make changes to an active replication environment

Change a configuration file Add or change table specifications in an active replication configuration Change Partitioned Replication Add Oracle sequences to an active replication configuration Remove objects from replication Make DDL changes in an active replication configuration Make Oracle changes that affect replication Change the SharePlex database account Change the name or IP address of a replication host Set the SharePlex port number

Apply an Oracle application patch or upgrade

Before you patch or upgrade an application Apply patch/upgrade to source then copy it to target Apply patch/upgrade to source and target Apply patch to source and replicate it to the target

Back up Oracle data on the source or target

Perform a partial backup of the source system Perform a full backup on the source system

Troubleshooting Tips Appendix A: Peer-To-Peer Diagram Appendix B: SharePlex environment variables

cleanup.sql

Description

Use the cleanup.sql script to truncate all of the SharePlex internal tables except the SHAREPLEX_PARTITION table (which contains partition schemes that might be needed again).

Note: The cleanup.sql script does not remove the SharePlex Oracle user, password, or demonstration objects from the SharePlex tables.

The cleanup.sql script preserves the replication data in the SharePlex variable-data directory. Other utilities provide related options:

To clean out the variable-data directory without truncating the SharePlex tables, see clean_vardir.sh.
To clean out the variable-data directory and truncate the SharePlex tables, see ora_cleansp. This utility completely restore SharePlex to an initial state.

Contact Quest Technical Support before running cleanup.sql for the first time. Unless a procedure in the SharePlex documentation requires running clean_vardir.sh, this utility rarely is appropriate in a production environment. It deactivates the configuration, and using it improperly can result in replication problems and the need to resynchronize the data. Usually, there is another alternative.

Supported databases

Oracle on Unix and Windows

Run cleanup.sql

Log into Oracle as the SharePlex database user. The SharePlex tables belong to that user. On Unix and Linux, If you are running multiple instances of sp_cop with multiple variable-data directories, there is a SharePlex Oracle user for each one. Make certain to run this script as the correct one.
(Unix and Linux) Set the SP_SYS_VARDIR environment variable to point to the SharePlex variable-data directory.

ksh shell:

export SP_SYS_VARDIR=/full_path_of_variable-data_directory

csh shell:

setenv SP_SYS_VARDIR=/full_path_of_variable-data_directory
Run cleanup.sql as a SharePlex Administrator. The script is in the util sub-directory of the SharePlex product directory. Use the following syntax, where Oracle_version is one of the SharePlex-supported Oracle versions.

SQL> @proddir/util/cleanup.sql

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center