Chat now with support
Chat with Support

SharePlex 9.2.3 - Installation and Setup for SQL Server Source

About this Guide Conventions used in this guide SharePlex pre-installation checklist Download the SharePlex installer Install SharePlex on Linux and UNIX Install SharePlex on Windows Assign SharePlex users to security groups Set up replication between SQL Server databases Set up replication from SQL Server to a different target type Generic SharePlex demonstration-all platforms Solve Installation Problems Database Setup Utilities General SharePlex Utilities Uninstall SharePlex Advanced installer options Install SharePlex as root Run the installer in unattended mode SharePlex installed items

Download the SharePlex installer

Contents

 

About the SharePlex installers

There are different installers for SharePlex based on the type of operating system. This topic helps you understand the differences and the naming conventions used.

Linux and Unix

The SharePlex installer on Linux and Unix is a self-extracting installation file with the extension .tpm.

Oracle and Open Target:

There is a separate SharePlex installer build for each supported platform.

SharePlex-release#-build#-platform-chipset.tpm

For Oracle Solaris (Sun), there is a separate SharePlex installer build for each supported operating system version. If the operating system version that you have is not listed, choose the highest number that is below your version.

SharePlex-release#-build#-platform-version-chipset.tpm

The installer creates a temporary target directory, within the current directory, for extraction. This temporary target directory is removed upon installation completion. You can extract the files to a file system that is separate from the SharePlex installation location by using the -t option when running the .tpm file. For additional options, see Advanced SharePlex installer options.

Windows

On Windows, the SharePlex installer is named sp_setup_version.exe. It is a bundle that contains SharePlex binaries for all of the supported databases and versions, including components for capture from a SQL Server source database.

The installer installs the following items:

  • The SharePlex binaries and files
  • The SharePlex for database program
  • The MKS Platform Components program from Parametric Technology Corporation (default C:\Program Files\MKS Toolkit)
  • Windows registry entries under \HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432node.
  • One or more SharePlex port_number Windows services (depending on the installed configuration)

Do not remove or modify any of these components while SharePlex is in production, including SharePlex Installer. These components all support SharePlex operation or upgrade.

Where to get SharePlex installers

Download the SharePlex installation package that matches the operating system you are using.

Additionally, download any SharePlex patches, so that you can install them after you install the base software.

  1. Go to the Quest Software Support page: http://support.quest.com/

  2. Click Download Software.

  3. In the search box, type SharePlex and press Go.
  4. Click the arrow in the Download column for the version you need. You can also click the file name for access to more information and to download the file(s).

  5. Transfer the file to system where you are installing SharePlex.
  6. You are ready to begin the installation process. Be sure to thoroughly read the version specific Release Notes prior to running the installer.

Install SharePlex on Linux and UNIX

Contents

 

Install SharePlex on Linux/UNIX for Oracle Database

Important: These instructions are for installing SharePlex on an Oracle target system to support replication from a SQL Server source to a target Oracle database. To install SharePlex to capture from an Oracle source database, see the SharePlex Installation and Setup Guide for Oracle.

Read this before you begin:

Run the installer in interactive mode

In interactive mode, you are prompted for each part of the installation information.

  1. Log in to the system as the user that will be named as the SharePlex Administrator during this installation. This user will own the installation files and binaries.

  2. If sp_cop is running, shut it down.

    sp_ctrl> shutdown

  3. Copy the installation file to a temporary directory where you have write permissions.
  4. Grant executable permissions to the file.

    #chmod 555installation_file

  5. Run the .tpm file. If installing SharePlex in a cluster, run the installer from the primary node (the one to which the shared disk is mounted)

    # ./installation_file

  6. Verify that the information shown on the first screen corresponds to the Oracle version and platform you are upgrading.

  7. You are prompted for the following:

    Prompt

    Input

    Installation type

    Select <New Installation>.

    Product directory location (path)

    Enter the path to the SharePlex installation directory.

    If the specified directory does not exist, the installer creates it. If the directory exists, it must be empty. The installer quits if the directory contains prior SharePlex installations or other files.

    In a cluster, install on the shared disk. For more information, see Installation and setup for Oracle cluster on page 1.

    Variable data directory location

    Specify an empty directory. The installer creates the specified directory if it does not exist. Important! Do not install this directory into the SharePlex product directory.

    In a cluster, install the variable-data directory on the shared disk. For more information, see Installation and setup for Oracle cluster on page 1.

    SharePlex Admin group

    Enter the DBA-privileged group to which the SharePlex Administrator user belongs, which will own the SharePlex binaries. If the default group of the SharePlex Administrator is oinstall, select any option, and make certain this user is listed under oinstall in the etc/group file. For more information, see Installer checklist.

    TCP/IP port for SharePlex

    Enter the port number to use for SharePlex TCP/IP communications.

    License key (do you have?)

    Press Enter to accept the default of Y (yes). If you do not have a license, enter no.

    For licensing on a cluster, see Installation and setup for Oracle cluster on page 1

    At any point before you run SharePlex you can add the license key with the splex_add_key utility. For more information, see SharePlex license utilities.

    License key

    Enter the license key you received from Quest.

    Customer name

    Enter the SiteMessage text string provided by Quest with the license key.

The installer displays the location of the install log file and then quits.

See Next steps.

Next steps

Task Description
Patch SharePlex If you downloaded patches for this version of SharePlex, apply them now.
Run sp_security

Run “sp_security –setup” to specify whether or not to enable SSL/TLS for all network traffic. When enabled, SSL/TLS is used for network communications between the SharePlex instances on the source and target systems. For more information, see “Configure Security Features” in the SharePlex Administrator Guide.

Run Database Setup

Run the Database Setup utility for Oracle (ora_setup) to establish a database account and connection information for SharePlex. For more information, see Database Setup for Oracle.

(Heterogeneous replication)

Install SharePlex on the Open Target system and perform database setup operations. See:

Assign users to security groups For more information, see Assign SharePlex users to security groups.
Multi-instance configurations

To install multiple instances of SharePlex on this system, such as to support consolidated replication, see Run SharePlex in the SharePlex Administrator’s Guide.

Install SharePlex on Linux for Open Target Databases

Read this before you begin:

Run the installer in interactive mode

In interactive mode, you are prompted for each part of the installation information.

  1. Log in to the system as the user that will be named as the SharePlex Administrator during this installation. This user will own the installation files and binaries.

  2. (Reinstallations) If sp_cop is running, shut it down.
  3. Copy the installation file to a temporary directory where you have write permissions.
  4. Grant executable permissions to the file.

    # chmod 555 installation_file

  5. Run the .tpm file. If installing SharePlex in a cluster, run the installer from the primary node (the one to which the shared disk is mounted)

    # ./installation_file

  6. You are prompted for the following:

    Prompt for: Input
    Installation type

    Select <New Installation>.

    Product directory location (path)

    Enter the path to the SharePlex installation directory.

    If the specified directory does not exist, the installer creates it. If the directory exists, it must be empty. The installer quits if the directory contains prior SharePlex installations or other files.

    Variable data directory location

    Specify an empty directory. The installer creates the specified directory if it does not exist. Important! Do not install this directory into the SharePlex product directory.

    SharePlex Admin group

    Enter the DBA-privileged group to which the SharePlex Administrator user belongs, which will own the SharePlex binaries.

    TCP/IP port for SharePlex

    Enter the port number to use for SharePlex TCP/IP communications.

    License key (do you have?)

    Press Enter to accept the default of Y (yes). If you do not have a license, enter no.

    At any point before you run SharePlex you can add the license key with the splex_add_key utility. For more information, see SharePlex license utilities.

    License key

    Enter the license key you received from Quest.

    Customer name Enter the SiteMessage text string provided by Quest with the license key.

The installer displays the location of the install log file and then quits.

See Next steps.

Next steps

Task Description
Patch SharePlex If you downloaded patches for this version of SharePlex, apply them now.
Run sp_security

Run “sp_security –setup” to specify whether or not to enable SSL/TLS for all network traffic. When enabled, SSL/TLS is used for network communications between the SharePlex instances on the source and target systems. For more information, see “Configure Security Features” in the SharePlex Administrator Guide.

Assign users to security groups For more information, see Assign SharePlex users to security groups.
Perform Database Setup and other setup tasks

See:

Set up replication from SQL Server to a different target type

Repeat Repeat all of the installation procedures for all Unix and Linux machines that will be involved in SharePlex replication.
Multi-instance configurations

To install multiple instances of SharePlex on this system, such as to support consolidated replication, see the SharePlex Administrator’s Guide for the correct setup.

Related Documents