SharePlex 9.0 - Installation Guide

About this Guide Conventions used in this guide System Requirements SharePlex pre-installation checklist Installation and setup for Oracle cluster Installation and setup for cloud-hosted databases Download SharePlex Install SharePlex on Linux and UNIX Install SharePlex on Windows Assign SharePlex users to security groups Set up an Oracle environment for replication Set up replication between SQL Server databases Set up replication between different database types Basic SharePlex demonstrations Advanced SharePlex demonstrations Solve Installation Problems Uninstall SharePlex SharePlex Utilities Advanced installer options Install SharePlex as root Run the installer in unattended mode SharePlex installed items

About this Guide

This manual provides instructions for installing SharePlex and performing initial setup. It also contains some demonstration tutorials that show how certain features of SharePlex work.

Other SharePlex documentation

For the complete SharePlex documentation set, go to:

http://documents.quest.com

  • See the SharePlex Administration Guide for instructions for:

    • Operating SharePlex
    • Planning your replication strategy
    • Preparing the environment for replication
    • Configuring replication
    • Starting replication
    • Monitoring, tuning, and troubleshooting replication
    • Failover/failback in a high-availability environment
    • Performing administrative operations on replication systems
  • See the SharePlex Reference Guide for reference information that you will need from time to time. It includes detailed information about:

    • sp_ctrl commands that administer, monitor and control replication
    • SharePlex tuning parameters
    • SharePlex utilities
    • SharePlex error messages
  • See the SharePlex Upgrade Guide for instructions for upgrading a current installation of SharePlex to this version.
  • See the SharePlex Release Notes for information about new features, enhancements, bug fixes and known issues in this release.

View this document in PDF format

You can download, view and save this document in Adobe PDF format. Click Download this document 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.

System Requirements

Contents

Overview

This chapter contains the following:

  • SharePlex-supported platforms and database types and versions
  • SharePlex-supported data types, database objects, and database operations
  • Supported SharePlex features, per database type

Basic system requirements

Before installing SharePlex, ensure that your system meets the minimum hardware and software requirements.

  • SharePlex processes are all 64-bit and can exceed 4 GB.
  • Per process memory of greater than or equal to 256 MB is required.
  • See the Preinstallation Checklist in the SharePlex Installation Guide for additional system and/or database requirements.

Internet protocol

SharePlex supports both IPv4 and IPv6 internet protocol. The following table shows the platforms for which SharePlex was tested with IPv6.

Platform

Source

Target

SharePlex Source
and Target versions

On-premise/Cloud

Linux RHEL

Link-Local IPV6

Link-Local IPV6

9.0 - 9.0

On-premise

Linux RHEL

Link-Local IPV6

Link-Local IPV6

8.6.5 - 9.0

On-premise

Linux RHEL

Link-Local IPV6

Link-Local IPV6

9.0 - 8.6

On-premise

Linux Suse

Link-Local IPV6

Link-Local IPV6

9.0 - 9.0

On-premise

Windows

Link-Local IPV6

Link-Local IPV6

9.0 - 9.0

On-premise

Windows

Link-Local IPV6

Link-Local IPV6

9.0 - 8.6.4

On-premise

HP UA

Link-Local IPV6

Link-Local IPV6

9.0 - 9.0

On-premise

HP IA

Link-Local IPV6

Link-Local IPV6

9.0 - 9.0

On-premise

SUN Sprac

Link-Local IPV6

Link-Local IPV6

9.0 - 9.0

On-premise

SUN Solaris

Link-Local IPV6

Link-Local IPV6

9.0 - 9.0

On-premise

AIX

Link-Local IPV6

Link-Local IPV6

9.0 - 9.0

On-premise

Linux RHEL

Public IPV6

Public IPV6

9.0 - 9.0

Cloud

Windows

Public IPV6

Public IPV6

9.0 - 9.0

Cloud

Interoperability between versions

Refer to the following guidelines if the system where you are installing the current version of SharePlex is in a configuration where one or more other systems will continue to use an older version. An example would be where you are installing or upgrading SharePlex on a target, but the source will continue to use SharePlex 8.5 or earlier.

Versions with full interoperability

The following SharePlex versions are fully interoperable, including the Compare/Repair feature:

8.0.x

8.5.x

8.6.x

9.0.x

To support replication from a higher to a lower version, set the SP_SYS_TARGET_COMPATIBILITY parameter on the source system to the lower SharePlex version. If Capture is running, restart it.

Important: Downgrading from a higher to a lower version of SharePlex is not supported.

Notes:

  • The older version of the SP_SYS_TARGET_COMPATIBILITY parameter, SP_OCT_TARGET_COMPATIBILITY, has been deprecated in version 9.0. If your source SharePlex is currently replicating to a lower SharePlex version on the target and you have SP_OCT_TARGET_COMPATIBILITY set to the lower version, SharePlex will continue to use that value after you upgrade to version 9.0.
  • If you upgrade the target to the current release at a future time, issue a reset for SP_OCT_TARGET_COMPATIBILITY on the source system to remove it from the SharePlex environment. Going forward, SharePlex will use the setting of the new SP_SYS_TARGET_COMPATIBILITY parameter, which defaults to the current version.

To reset SP_OCT_TARGET_COMPATIBILITY

  1. Stop Capture.

    sp_ctrl>stop capture

  2. In sp_ctrl on the source system, issue the following command:

    sp_ctrl> reset param SP_OCT_TARGET_COMPATIBILITY

  3. Restart Capture.

    sp_ctrl> start capture

Supported data stores

Data Store Type of Support Version Driver version
Apache Kafka target .08 and later

N/A

Note: A Kafka target is supported on Red Hat Linux version 6.0 or later.

Flat file - SQL output target N/A N/A
Flat file - XML output target N/A N/A
JMS - ActiveMQ target 5.8 N/A
JMS - IBM MQ target 7.x and 8.x N/A

Microsoft SQL Server

source and target

2012

2014

2016

Note: Supported as a source only on Windows 2012 R2.

Microsoft SQL Server ODBC Driver

Do not use the Microsoft SQL Server Native Client. SharePlex will return an error during setup if the correct driver is not used. To tell the difference between the two:

  • The Microsoft SQL Server ODBC Driver has versions such as 06.02.9200.
  • The Microsoft SQL Server Native Client has versions such as 11.00.3513.
MySQL target 5.6 and later ODBC driver version 5.3.2 or later.
Oracle Database (64-bit only)

source and target

10g R1 and R2

11g R1 and R2

12cR1 and R2

N/A
PostgreSQL*

(Symfoware Server, EDB Postgres Advanced Server, others)

target 9.4 and later*

Use the driver version that is recommended by the vendor of the PostgreSQL implementation that you are using.

SAP Adaptive Server Enterprise (ASE) target 15.7 N/A
SAP HANA target 1.0 SPS 11 Rev111 HDBODBC or HDBODBC32 driver provided with the HANA database installation.
Teradata target 15.00.03.05 Teradata ODBC driver version 15.10.00.01 or later

* SharePlex supports all implementations of the PostgreSQL open source object-relational database system.

Cloud support

The following shows the configurations that SharePlex supports when either the source or target, or both, are cloud-based databases.

Source To Target
Oracle on EC2 Linux

Oracle on AWS EC2 Linux

   
Oracle on Azure Linux

Oracle on Azure Linux

   
Oracle on on-premise Linux
  • Oracle on AWS RDS
  • Oracle on AWS EC2
  • PostgreSQL (Community) on Azure Linux
  • PostgreSQL (Community) on AWS EC2

  • PostgreSQL (Community) on AWS RDS

  • EDB Postgres Advanced Server on AWS EC2
  • EDB Postgres Advanced Server on Azure Linux
  • Fujitsu Symfoware Server on AWS EC2
  • Fujitsu Symfoware Server on Azure Linux
  • MySQL on AWS EC2
  • MySQL on AWS RDS
  • MySQL on Azure Linux
  • Aurora on AWS RDS
  • SQL Server on AWS EC2
  • SQL Server on AWS RDS
  • SQL Server on Azure Windows (IaaS)
  • SQL Server on Azure Windows (PaaS)
   
SQL Server on on-premise Windows
  • SQL Server on Azure Windows
  • SQL Server on EC2 Windows
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents