Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SharePlex 11.0 - SharePlex Reference Guide

About this guide Conventions used in this guide Revision History SharePlex Commands for Oracle SharePlex Commands for PostgreSQL SharePlex parameters General SharePlex utilities Database Setup utilities Oracle Cloud Infrastructure SharePlex environment variables

About this guide

This guide is a reference for the following:

  • SharePlex commands — an overview of the commands that control replication through sp_ctrl, an explanation of command authorization levels, and detailed documentation for each command.
  • SharePlex parameters — an overview of the SharePlex tuning parameters, how they are set and stored, and detailed documentation for parameters that can be changed by SharePlex users.
  • SharePlex utilities — the SharePlex utilities and their use.
  • SharePlex error messages — common error codes, their cause, and the suggested resolution.

Users of the SharePlex Reference Guide should have a thorough understanding of SharePlex before issuing commands, changing parameters or attempting to solve problems.

Other SharePlex Documentation

For the complete SharePlex documentation set, go to https://support.quest.com/shareplex/technical-documents.

View this Document in PDF Format

You can download, view, and save this document in Adobe PDF format. Click Download in the upper right-hand corner of this page. This action downloads the entire publication.

Conventions used in this guide

Conventions used in this manual

The following typographic conventions are used in this guide:

  • Bold represents required components of a command or option that must be typed as shown.
  • Italics represent variables defined, named or entered by the user.
  • {Braces} enclose required arguments.
  • [Brackets] represent optional command components and may also be used in example command strings to emphasize required user defined variables in long strings.

    Example:

    reconcile queue {queuename} for {datasource-datadest} [on host]

  • A vertical bar, or “pipe” character, ( | ) within brackets or braces indicates that you can use only one of the enclosed components.

    Example:

    abort service {service | all}

Names of commands, programs, directories and files are expressed in Bold.

Other names are expressed in capital letters using the default font.

Examples:

The sp_ctrl program is located in the bin directory.

Open the oramsglst file.

Find the value for ORACLE_HOME.

Click Apply.

System displays, such as prompts and command output, are expressed in a monofaced (fixed-space) font.

Examples:

sp_ctrl(sysA)>

User is a viewer (level=3)

Windows menu items, dialog boxes, and options within dialog boxes are expressed in Bold.

Example:

From the File menu, select Print.

System names are expressed generically or fictitiously. When necessary, the source system (or primary system) is referred to as SysA. Target systems (or secondary systems) are referred to as SysB, SysC, SysD, and so forth.

Revision History

Document Version Date Change History
2 28th February 2024

Updated the licensing information in the SharePlex License Utilities section.

3 5th March 2024 Added the configuration settings required to replicate emoji characters to a non-Oracle target in the Characterset category section of the Target command.
4 17th April 2024 Updated the Actual Value field related information in the list param command section.
5 6th May 2024 Added limitations for the copy/append command.
6 5th August 2024 Added the SP_OPO_LOB_PERFORMANCE_ENABLE parameter to the Oracle Poster Parameters section.

SharePlex Commands for Oracle

The SharePlex commands configure, start, stop, control, and monitor the replication process. SharePlex commands are issued through the sp_ctrl interface.

Contents
Outils libre-service
Base de connaissances
Notifications et alertes
Support produits
Téléchargements de logiciels
Documentation technique
Forums utilisateurs
Didacticiels vidéo
Flux RSS
Nous contacter
Obtenir une assistance en matière de licence
Support Technique
Afficher tout
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation