This manual provides instructions for installing and setting up SharePlex on an Oracle and PostgreSQL database(s) as a source and all the supported target types.
This manual also contains some demonstration tutorials that show how certain features of SharePlex work.
For the complete SharePlex documentation set, go to https://support.quest.com/shareplex/technical-documents.
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.
The following typographic conventions are used in this guide:
[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.
Document Version | Date | Change History |
---|---|---|
2 | 17th May 2024 | Added a query to grant privileges to existing objects after completing the Snowflake setup in the Run database setup for Snowflake section. |
3 | 21st August 2024 | Added a prerequisite in the Database Setup for PostgreSQL section to set the value of the logical_decoding_work_mem parameter to 4096MB. |
The following installation and setup configurations apply to the Oracle source database.
SharePlex Pre-installation Checklist for Oracle
Download the SharePlex Installer for Oracle
Set up an Oracle Environment for Replication
Set up Replication from Oracle to a Supported Target Type
Installation and Setup for Cloud-Hosted Databases for Oracle
Installation and Setup for Remote Capture
Installation and Setup for HA Cluster
Basic SharePlex Demonstration for Oracle
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center