Tchater maintenant avec le support
Tchattez avec un ingénieur du 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

Install SharePlex on Linux and UNIX

Install SharePlex

Install SharePlex on Linux/UNIX for Oracle Database

Install SharePlex on Linux/Unix for Oracle database

Read this before you begin:

Run the installer in interactive mode

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

Perform the following steps to run the installer in an interactive mode:

  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 HA Cluster.

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 HA Cluster.

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 for Oracle.

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 HA Cluster

At any point before you run SharePlex you can add the license key with the splex_add_key utility. For more information, see the SharePlex License Utilities section in the SharePlex Reference Guide.

Please specify platform for license key (select a number):

Please select the appropriate number from the following list of platforms to install the license key:

1) Oracle
2) File
3) JMS
4) Kafka
5) SQL Server
6) Postgres
7) MySQL
8) Snowflake
9) MariaDB 
10) Event Hubs
11) All Platforms	

Note: To install a trial version of SharePlex, users need to select the All Platforms option.

License key

Enter the license key you received from Quest.

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

See Next steps.

Next steps

The following setup tasks must be finished before you start up replication:

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.

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 the Run SharePlex section in SharePlex Administrator’s Guide.

Install SharePlex on Linux for Open Target Databases

Install SharePlex on Linux/Unix 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.

Perform the following steps to run the installer in interactive mode:

  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. 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 for Oracle.

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 the SharePlex License Utilities section in the SharePlex Reference Guide.

Please specify platform for license key (select a number):

Please select the appropriate number from the following list of platforms to install the license key:

1) Oracle
2) File
3) JMS
4) Kafka
5) SQL Server
6) Postgres
7) MySQL
8) Snowflake
9) MariaDB 
10) Event Hubs
11) All Platforms

Note: To install a trial version of SharePlex, users need to select the All Platforms option.

License key

Enter the license key you received from Quest.

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

See Next Steps.

Next Steps

The following setup tasks must be finished before you start up replication:

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.

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 Oracle to a Supported 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.

Run the installer in unattended mode

SharePlex can be installed unattended through the use of a response file. This installation method speeds the installation of multiple SharePlex instances. The file supplies responses to the standard installer prompts, while providing on screen status information.

Note:When running in unattended mode, the installation process does not call the system password utility. If you create a new SharePlex user during the installation, that user will remain locked until the password is set manually.

Response files that you can edit are located in the install subdirectory of the SharePlex product (installation) directory:

/productdir/install

Enter responses in the File

Important! The response file contains two sections. Only the top section is user configurable. Do not edit the bottom section. The bottom section begins with the line "Do not change settings that appear below."

Edit the top section of the response file to provide the responses for the installation. Only edit the values to the right of the colon, and make certain there is a space between the colon and the response.

The following example is for non-root installation:

# Please modify the following settings for your particular system to
# install the SharePlex. Only values to the right of a
# colon may be editted. Incorrect changes on the left side may make
# the installer output questions and wait for answeres, thus becoming
# interactive instead of silent.
#
the SharePlex Admin group: spadmin
product directory location: /home/splex/proddir
variable data directory location: /home/splex/vardir
# not required for Open Target installations #
ORACLE_SID that corresponds to this installation: oracledb
# not required for Open Target installations #
ORACLE_HOME directory that corresponds to this ORACLE_SID: /home/oracle/products/version
TCP/IP port number for SharePlex communications: 2100
# To specify the platform for license key [ Oracle, File, JMS, Kafka, SQL Server, Postgres, MySQL, Event Hubs, All Platforms ]
the platform for license key: Oracle
the License key: XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
# only change the current version number of SharePlex in place of 11.0.0
# do not change the value from yes to no
valid SharePlex v. 11.0.0 license: yes
# Do not change settings below.
#
Proceed with installation: yes
Proceed with upgrade: no
OK to upgrade: no

To run the response file:

From the command shell of the operating system, run the .tpm installation file with the -r option followed by the full path to the response file.

# ./installation_file -r /users/shareplex/product.rsp

Next steps:

For additional setup requirements, see the Next Steps section in one of the following depending on the platform:

Install SharePlex on Linux/Unix for Oracle database

Install SharePlex on Linux/Unix for open target databases

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation