Chat now with support
Chat with Support

SharePlex 12.2 - 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 Set up Replication from Oracle to Cloud storage 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 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 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

Solve sp_ctrl problems

Did you assign the users to the SharePlex groups?

Only one SharePlex user, the Administrator who owns the SharePlex binaries and files, is created during SharePlex installation. Other users must be assigned to the appropriate SharePlex user groups. These groups control the authorization levels for various SharePlex functions. To issue a specific command (such as activate config or stop export), a user must have that command’s authorization level or higher. For example, a SharePlex Administrator (authorization level 1) can issue any command, but a member of the spview group can only issue status commands and a few other commands that do not directly affect the replication processes. For more information, see Assign SharePlex Users to Security Groups.

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

  • Windows: Local 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>);

 

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating