Chat now with support
Chat with Support

SharePlex 11.3 - Installation and Setup Guide

About this Guide Conventions used in this guide Revision History Installing and Setting up SharePlex on an Oracle Source
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 Generic SharePlex Demonstration for PostgreSQL Advanced SharePlex Demonstrations for PostgreSQL Database Setup for PostgreSQL Database Setup for PGDB as a Service Solve Installation Problems for PostgreSQL
Assign SharePlex users to security groups Solve Installation Problems Uninstall SharePlex Advanced installer options Install SharePlex as root SharePlex installed items

Solve host connection problems

If SharePlex cannot resolve a host name, try creating an alias for it using a simple alphanumeric name.

Map the name to the alias in the following locations:

  • Network: The NIS and DNS servers
  • UNIX: Local /etc/hosts file

In the hosts files, put each entry on an individual line. The following is an example, where sysA and sysB are aliases:

111.22.33.44   sysA.company.com   sysA   # source system
55.66.77.88    sysB.company.com   sysB   # target system

Uninstall SharePlex

Contents

This section contains instructions for using the SharePlex uninstallation program to remove SharePlex from a system. The uninstaller permanently removes the replication environment from the system.

To preserve the replication environment, including the queues that store the data, you can install a SharePlex upgrade or reinstall the current version, rather than uninstall SharePlex. Before you upgrade or reinstall SharePlex, see the Release Notes for the version you are installing to determine if there are any special upgrade or installation requirements.

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>);

 

 

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating