Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

SharePlex 8.6.6 - Administration Guide

Table of Contents

About this Guide Conventions used in this guide Overview of SharePlex

The advantages of SharePlex About source and target data About the SharePlex architecture About sp_cop About sp_ctrl Understand 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

SharePlex parameters

Set and activate parameters Where parameter information is stored

Prepare an Oracle environment for replication

Set up Oracle redo logging to support SharePlex Set up Oracle database objects for replication Set up an Oracle database to support SharePlex Set up SharePlex to support Oracle data Set up TDE Support

Create a configuration file

Ensure compatible source-target mapping How to create a configuration file Database specifications in a configuration file Target specifications in a configuration file Routing specifications in a configuration file Replicate to or from an Oracle PDB Configuration examples Use a script to build a configuration file Configure replication to Oracle on Amazon RDS 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 Open Target targets

Configure replication to a Microsoft SQL Server target Configure replication to a Postgres (PPAS) target Configure replication to an SAP ASE target Configure replication to a SAP HANA target Configure replication to a Teradata target Configure replication to other Open Target databases Configure replication to a JMS target Configure Replication to a Kafka target Configure replication to a SQL or XML file target

Configure a replication strategy

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

Configure partitioned replication

Configure horizontally partitioned replication Configure vertically partitioned replication

Configure named queues

Configure named export queues Configure named post queues

Configure SharePlex to maintain a change history target

Overview of the change-history target Configure change history

Replicate Oracle DDL

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

Set up 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

Overview of transformation Considerations when using transformation Deploy transformation

Configure SharePlex security features

Secure connections to SharePlex Secure data with SSH Encrypt data across the network 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

Activate replication in your production environment

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

Procedures to maintain Oracle high availability

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

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

Tune the Capture process

Disable LOB Mapping Tune Capture on Exadata Tune Checkpointing

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

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

show sync

The show sync command shows any out-of-sync issues that Post may have encountered. The information is extracted from the Status Database. For each out-of-sync object, the command displays:

Count: the number of statements that failed
Detail: contains the table name, queue name, date and time

To see which SQL statement caused the error, view the SID_errlog.sql log file. The Event Log also will contain a record of the problem.

If nothing is out of synchronization when you issue the show sync command, you will be returned to the sp_crtl prompt.

Issue this command for the target system.

Usage

Supported targets:	All
Authorization level:	Viewer (3)
Issued for:	target system
Related commands:	show statusdb

Syntax

Basic command

Remote options

show sync

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Remote options

These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.

Option	Description
on host	Execute the command on a remote system (one other than the one where the current sp_ctrl session is running). You are prompted for login credentials for the remote system. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on SysA
on host:portnumber	Execute the command on a remote system when a remote login and port number must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on SysA:8304
on login/password@host	Execute the command on a remote system when a remote login, password, and host name must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on john/spot5489@SysA
on login/password@host:portnumber	Execute the command on a remote system when a remote login, password, host name, and port number must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on john/spot5489@SysA:8304

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy