Chat now with support
Chat with Support

SharePlex 11.4 - Installation and Setup guide

About this Guide Conventions used in this guide 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 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

Post to PaaS Cloud from the Source Server for Oracle

These instructions help you set up SharePlex to replicate to a target cloud database directly from the source server. All of the SharePlex processes will run on this server. In a high-volume transactional environment, this may generate unacceptable overhead on the production system. In that case, you should use an intermediary server.

See also:

Post to PaaS cloud from an intermediary server

Overview of SharePlex setup on cloud databases

Source Oracle to cloud Oracle

All steps are performed on the source server:

  1. Complete the SharePlex pre-installation checklist.

  2. Install SharePlex. See Install SharePlex on Linux/Unix for Oracle Database.

  3. Run ora_setup to establish connection information for the source Oracle database. See Database Setup for Oracle.

  4. Add an entry in the local tnsnames.ora file that points to the target cloud database. This enables you to query the target database from the source server.

  5. Run ora_setup to establish connection information for the target cloud database. Run the utility as the master user that was created when the service was created. This user has the required DBA privileges.

    IMPORTANT:

    1. When asked whether this is a bequeath connection, enter N. This directs SharePlex to use TNS to connect to the target cloud database.

    2. When prompted to specify the tns_alias, specify the one that you created for the target cloud database.

    3. When asked if the current SID will be used as a source, enter N.

  6. Specify the following in the routing map of the SharePlex configuration file:

    • The name of the source host to specify the target system.

    • The ORACLE_SID of the target cloud database.

    In the following example, source1 is the source system and orcldb1 is the tns_alias of the target cloud database.

    datasource:o.orcldbprim
    #source tables target tables routing map
    splex.demo_src splex.demo_dest source1@r.orcldb1

For more information, see Configure SharePlex to replicate data in the SharePlex Administration Guide.

Source Oracle to cloud Open Target

All the below steps are performed on the source server:

  1. Complete the SharePlex preinstallation checklist.

  2. Install SharePlex. See:

  3. Run the appropriate database setup utility for the source database. See:

    IMPORTANT:

    1. (Oracle setup only) When asked whether this is a bequeath connection, enter Y to use bequeath, unless this system is RAC.

    2. Reply Y when asked if the database or SID will be used as a source.

  4. Install the appropriate ODBC client of the target cloud database.

  5. Run the appropriate database setup utility for the target cloud database. See Database Setup Utilities.

  6. Specify the following in the routing map of the SharePlex configuration file:

    1. the name of the source server as the target host.

    2. the name of the cloud database as the target database

For more information about how to specify configuration components, see Configure SharePlex to replicate data in the SharePlex Administration Guide.

Post to PaaS Cloud from an Intermediary Server for Oracle

These instructions help you set up SharePlex to replicate to a target cloud database from an intermediary server that runs the SharePlex Import and Post components.

See also:

Post to PaaS cloud from the source server.

Overview of SharePlex setup on cloud databases.

Source Oracle to cloud Oracle

  1. Complete the SharePlex preinstallation checklist.

  2. On the source server, install SharePlex for the source database. See: Install SharePlex on Linux/Unix for Oracle Database.

  3. On the source server, run ora_setup to establish connection information for the source database. See Database Setup for Oracle.

    IMPORTANT:

    1. When asked whether this is a bequeath connection, enter Y, unless this system is RAC.

    2. When asked if the current SID will be used as a source, enter Y.

  4. On the intermediary server, install the Oracle binaries. Do not create an Oracle instance.

  5. On the intermediary server, add an entry in the oratab file that points to the local Oracle home, and create a dummy entry for the ORACLE_SID. Make certain to specify N so that the startup scripts do not attempt to start the dummy instance.

    orcldb:/u01/app/oracle/product/12.1.0/dbhome_1:N

  6. On the intermediary server, add an entry in the tnsnames.ora file that points to the target cloud database.

  7. On the intermediary server, install SharePlex for the target cloud database. When prompted for the ORACLE_SID, specify the tns_alias that you created for the target cloud database. See: Install SharePlex on Linux/Unix for Oracle Database.

  8. On the intermediary server, run ora_setup to establish connection information for the target cloud database. Run it as the master user that was created when the cloud service was created. This user has the required DBA privileges to establish connection information for the target database.

    IMPORTANT:

    1. When asked whether this is a bequeath connection, enter N. This directs SharePlex to use TNS to connect to the target cloud database.

    2. When prompted to specify the tns_alias, specify the one that you created for the target cloud database.

    3. When asked if the current SID will be used as a source, enter N.

  9. Specify the following in the routing map of the SharePlex configuration file:

    • the name of the intermediary server as the target host.

    • the ORACLE_SID of the target cloud database.

In the following example, intermediary1 is the intermediary server and orcldb1 is the tns_alias of the target cloud database.

datasource:o.orcldbprim
#source tables target tables routing map
splex.demo_src splex.demo_dest intermediary1@o.orcldb1

For more information, see Configure SharePlex to replicate data in the SharePlex Administration Guide.

Source Oracle to cloud Open Target

  1. Complete the SharePlex preinstallation checklist.

  2. On the source server, install SharePlex for the source database. See: Install SharePlex on Linux/Unix for Oracle Database.

  3. On the source server, run the appropriate database setup utility for the source database. See: Database Setup for Oracle.

    IMPORTANT:

    1. (Oracle setup only) When asked whether this is a bequeath connection, enter Y to use bequeath, unless this system is RAC.

    2. Reply Y when asked if the database or SID will be used as a source.

  4. On the intermediary server, install the appropriate ODBC client of the target cloud database.

  5. On the intermediary server, install SharePlex for the target cloud database. See: Install SharePlex on Linux/Unix for Oracle Database.

  6. On the intermediary server, run the appropriate database setup utility for the target cloud database. See Database Setup Utilities.

    IMPORTANT:

    • If the target is Aurora, use the mysql_setup utility.

    • If the target is SQL Server, reply N when asked if this database will be used as a source.

    • (All targets) Specify the full target database name when prompted for the connection string.

  7. Specify the following in the routing map of the SharePlex configuration file:

    1. the name of the intermediary server as the target host.

    2. the name of the cloud database as the target database.

In the following example using a MySQL target, intermediary3 is the intermediary system and sptest3 is the target cloud database.

datasource:o.orcldbprim
#source tables target tables routing map
HR.EMP "sptest3"."emp" intermediary3@r.sptest3

For more information, see Configure SharePlex to replicate data in the SharePlex Administration Guide.

Installation and setup for remote capture

SharePlex can capture from an Oracle database that is running on a system other than the system where SharePlex is running.

This support covers Oracle databases running on Linux. This support applies only when SharePlex and the remote capture database are running on the same operating system type (i.e., if SharePlex is on Linux, the remote database must be on Linux).

SharePlex does not support remote capture from Oracle on RAC unless the database is running on ASM.

Notes: 

  • If configuring SharePlex to capture from a remote database that is on Amazon AWS, see the SharePlex Installation and Setup Guide for Oracle on RDS.

  • Remote capture using more than one SharePlex instance to the same Oracle instance is not supported.

To set up SharePlex for remote capture:

  1. Install an Oracle client on the system where SharePlex is running. No database is required on this system.
  2. Set the ORACLE_HOME system variable on the SharePlex system to the Oracle client installation folder.
  3. Set the ORACLE_SID to a dummy value, as a placeholder for the non-existent local database.
  4. Create a tnsnames.ora file on the SharePlex system and make an entry for the remote source database. Place the file in the path specified in the TNS_ADMIN environment variable.
  5. Install SharePlex on the remote system in the normal manner.

  6. Run Oracle Setup on the SharePlex system according to the directions in Database setup for Oracle.

    • Reply NO to "Will SharePlex install be using a BEQUEATH connection?"
    • Reply NO to "Are you setting up SharePlex for an RDS database?"
    • Reply YES to "Will the current setup for sid: SID be used as a source (including cases as source for failover or primary-primary setups)?"
  7. Complete all other installation and setup tasks according to this document.
  8. After setup is complete, start sp_cop and sp_ctrl.
  9. Set the SP_OCT_OLOG_USE_OCI parameter to 1 to enable it. When capturing from a remote database, Capture must read the redo logs through OCI calls because it does not have access to the log files on disk.
  10. See the SharePlex Administration Guide for help with configuring and starting replication.

Installation and setup for HA cluster

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating