Chat now with support
Chat with Support

SharePlex 12.0 - Installation and Setup Guide

About this Guide Conventions used in this guide Installing and Setting up SharePlex on Oracle Source Database
SharePlex Pre-installation Checklist for Oracle Download the SharePlex installer Install SharePlex on Linux and UNIX Set up an Oracle environment for replication Set up replication from Oracle to a different target type Installation and Setup for Cloud-Hosted Databases for Oracle Installation and setup for remote capture Installation and setup for HA cluster Generic SharePlex demonstration for Oracle Advanced SharePlex demonstrations for Oracle Database Setup Utilities Solve Installation Problems for Oracle
Installing and Setting up SharePlex on a PostgreSQL Database as Source and Service
SharePlex Pre-installation Checklist for PostgreSQL Download the SharePlex installer for PostgreSQL Install SharePlex on Linux for PostgreSQL as a Source Set up Replication from PostgreSQL to Supported Target Types Installation and Setup for Cloud-Hosted Databases for PostgreSQL Installation and Setup for Remote Capture for PostgreSQL Install SharePlex on PostgreSQL High Availability Cluster Configure SharePlex on PostgreSQL Azure Flexible Server with High Availability Using Logical Replication Generic SharePlex Demonstration for PostgreSQL Advanced SharePlex Demonstrations for PostgreSQL Database Setup for PostgreSQL Database Setup for PGDB as a Service Installation of pg_hint_plan extension Solve Installation Problems for PostgreSQL
Installing SharePlex on a Docker container Assign SharePlex users to security groups Solve Installation Problems Uninstall SharePlex Advanced installer options Install SharePlex as root SharePlex installed items

Uninstall SharePlex from UNIX/Linux

Remove SharePlex from Unix/Linux

Perform the following steps to remove SharePlex from Unix or Linux platforms:

  1. Log on as a user who has privileges to remove the SharePlex directories.
  2. Run sp_ctrl.
  3. Issue the shutdown command to shut down SharePlex.

    sp_ctrl> shutdown

  4. Exit sp_ctrl.
  5. Use the following command to make certain that no SharePlex processes are running.

    # ps -ef | grep sp_

  6. Kill any processes that are still running.
  7. Remove the SharePlex product directory, variable-data directory, and the hidden .shareplex directory from the system.

Note: If there are multiple installations, do not remove the hidden directory.

  1. Drop the SharePlex database user from the database.

Note: If desired, remove any objects that SharePlex installs in the database. These objects begin with SHAREPLEX_ or shareplex_. You can remove any such objects using standard SQL commands.

Important!

Points to remember when removing the SharePlex objects from the PostgreSQL database:

  • Remove the replication slot that was created during pg_setup using the following query:

    select pg_drop_replication_slot(<slot_name>);

  • Remove replication origins created by the Post-process:

    • Get replication origin names using the following query:

      Select a roname from pg_replication_origin that is similar to "sp_post_%";

    • Remove these origins with the following query:

      select pg_replication_origin_drop(<origin_name>);

  • If the SP_CAP_DENIED_SESSION_PG parameter was used, remove the replication origin created:

    • Get replication origin names using the following query:

      Select a roname from pg_replication_origin that is similar to "sp_deny_%";

    • Remove these origins with the following query:
      select pg_replication_origin_drop(<origin_name>);

 

 

Remove SharePlex from Windows

Remove SharePlex from Windows

Files removed by the uninstall program

When SharePlex was installed, a file named install.log was installed in the SharePlex product directory. This file contains a record of all files created on the system by the installation program. When you run the uninstall program to remove SharePlex, it reads install.log to determine which files to remove.

If you select the Automatic uninstall option, it removes the following components for all instances of SharePlex (all SharePlex services on all ports):

  • The SharePlex desktop icons.
  • The SharePlex menu items (except for the top-level Program Manager Group folder).
  • The SharePlex product directory. If the variable-data directory is installed under the product directory but contains no files that were added after installation, it is removed as well.
  • The cygwin directory and Cygwin cygserver service.
    Note: If it is not uninstalled automatically, please remove it manually.

Use the Custom uninstall option to remove specific files while leaving the others intact.

Files not removed by the uninstall program

The uninstall program does not remove the following components.

  • The SharePlex entry in the Registry.
  • Files that already existed in the product directory when the current version of SharePlex was installed.
  • Files created by SharePlex or a user in the product or variable-data directory after the current version of SharePlex was installed. Such files can be removed manually after SharePlex is removed. This is standard procedure for most Windows applications.
  • The SharePlex variable-data directory. To remove this directory, delete it through the operating system. The uninstall program does not remove this directory because there could be user-created files, such as configuration files and custom parameter settings, that you want to keep for a future installation of SharePlex.

Remove SharePlex from the system

Perform these tasks in the order shown.

Remove the SharePlex service

Before you remove the SharePlex software from the system, follow these steps to stop and remove each SharePlex service on the system. If you remove SharePlex first, you cannot use SpUtils to stop and remove the service and must do so from the Services utility of the Windows Control Panel.

  1. Double-click the SpUtils desktop icon.
  2. Click the SharePlex Services tab.
  3. Select the port number for the SharePlex instance that you want to remove. The Current State field displays the status of SharePlex on that port.
  4. If the service is running, click Stop. Make certain the status shows Stopped.
  5. Click Remove.
  6. Stop and remove other SharePlex services as needed.
  7. Close the SpUtils dialog box.

Remove the SharePlex software

  1. From Start menu, click Programs, then navigate to the SharePlex program folder and click Uninstall. Alternatively, you can use the Windows Control Panel as you normally would to remove software.

  2. In the Select Uninstall Method dialog box, select an uninstall option.

    • Select Automatic to remove everything listed in Files removed by the uninstall program. This is the recommended procedure because it is the cleanest way to remove SharePlex from the system. Click Finish to execute the uninstallation.

    • Select Custom to selectively remove files. Use this option only if you must retain some files while deleting others. You receive a series of prompts to remove different sets of files.

    • Select Repair to re-install files or update Registry entries. Click Finish to execute the repair.

Remove Registry entries

  • The following Registry entries, if they exist, can be removed by a System Administrator after SharePlex is uninstalled.

    NOTE: Changing and removing Windows Registry components may be harmful to the system. Contact your System Administrator for assistance if needed.

    Remove the SharePlex user and database objects

    This uninstaller does not remove the SharePlex database objects. All SharePlex objects are installed in the SharePlex schema or database that was specified when the Database Setup portion of the installation was performed.

  • Advanced installer options

    The use of additional command line options when installing SharePlex is usually not necessary. These options are typically employed when working with Support to resolve specific issues.

    The installer command line options and their descriptions follow:

    USAGE

    tpm [<options>] [ [<package> | <location>] ... ]

     

    OPTIONS

    -v, --verbose Turns verbose mode on

    -h, -?, --help Prints out this message

    --debug Starts the interactive debugger

    --info Print information about installed

     

    packages

    --install Perform product installation

    --remove Perform product deinstallation

    --commit Commit last installation

    --revert Revert last installation

    -t, --tmp <directory> Temporary directory location

    -d, --directory <directory> Working directory

    -f, --force Unconditionally update existing files

    --no-cleanup Do not perform cleanup on failure

    --nocleanup Same as --no-cleanup, for compatibility

    --list List the content of the archive

    --extract Extract the archive into the current directory

    -r, --responses <yaml file> Use the responses from a specified file

    -D, --defaults Accept default answers

    -l, --log Leave the installation log file

    DESCRIPTION

    Provides package management facilities. Packages can be installed, removed, reverted or committed. The utility also figures out its role based on the command name of its invocation path. For example, "tpm-install" is treated as "tpm --install", "tpm-remove" as "tpm --remove", etc.

    It can also be invoked as part of a self extracting package invocation, in which case it is treated as "tpm --install".

    Note: All command line options for the .tpm file are preceded by two dashes.

    Install SharePlex as root

    You can install SharePlex as a root user. When you install as a root user, the installer prompts you to select whether or not to create the SharePlex user groups. When the installer creates the groups, it adds the SharePlex Administrator user to the spadmin group. For more information about these groups, see Assign SharePlex Users to Security Groups.

    In a cluster, the installer adds the SharePlex groups to the primary node, but you must add them to the other nodes yourself.

    Additionally, see Network checklist for instructions on adding the groups to a nameserver.

    To install as root:

      1. Log in to the system as a root user.
      2. Copy the SharePlex installer file to a temporary directory where you have write permissions. The installer file has a naming format of:

        SharePlex-release#-platform.tpm

      3. Change the permissions of the file as follows:

        # chmod 555 SharePlex-release#-platform.tpm

      4. Run the installer as directed in Install SharePlex .
    Related Documents

    The document was helpful.

    Select Rating

    I easily found the information I needed.

    Select Rating