In order for the SharePlex processes to issue name lookups and migrate properly in a clustered environment (where a package name supersedes the local system name), the SP_SYS_HOST_NAME parameter must be set to the correct package name. In addition, the host name set by this parameter must be the same on all members of the cluster so that the name can bind to a socket and the /etc/hosts file or nameserver can correctly map the parameter’s value to the correct IP address.
The sp_cop program should only be started through the cluster management software.
When setting up SharePlex to work with an Oracle database, you provide the ORACLE_SID and then SharePlex gets the ORACLE_HOME from the oratab file on Unix/Linux. Both values are stored in the SharePlex environment. SharePlex uses the Oracle libraries that are in the location specified with ORACLE_HOME.
To determine the ORACLE_SID and ORACLE_HOME being used by SharePlex:
Issue the orainfo command in sp_ctrl.
sp_ctrl (mysysl11:2101)> orainfo
Oracle instance #1:
Oracle SID ora12
Oracle HOME /oracle/products/12
Oracle Version 12
Oracle instance #2:
Oracle SID ora12
Oracle HOME /oracle/products/12
Oracle Version 12
To determine the default ORACLE_SID and ORACLE_HOME on UNIX and Linux:
On most Unix and Linux systems the oratab file is under /etc/oratab. On Oracle Solaris systems, it is under /var/opt/oracle, but sometimes there is an oratab file in the /etc directory as well.
The entry in the file looks like the following example:
qa12:/qa/oracle/ora12/app/oracle/product/12.0
In the example, qa12 is the ORACLE_SID and /qa/oracle/ora12/app/oracle/product/12.0 is the ORACLE_HOME.
The following installation and setup configurations apply to the PostgreSQL database as a source and service.
SharePlex Pre-installation Checklist for PostgreSQL
Network checklist for PostgreSQL
Installer checklist for PostgreSQL
Linux system 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
Set up replication from PostgreSQL to PostgreSQL
Set up replication from PostgreSQL to Oracle
Set up replication from PostgreSQL to Kafka
Set up Replication from PostgreSQL to SQL Server
Installation and Setup for Cloud-Hosted Databases for PostgreSQL
Overview of SharePlex Setup on Cloud for PostgreSQL
Post to PaaS Cloud from the Source Server for PostgreSQL
Post to PaaS Cloud from an Intermediary Server for PostgreSQL
Installation and Setup for Remote Capture for PostgreSQL
Install SharePlex on PostgreSQL High Availability Cluster
Generic SharePlex Demonstration for PostgreSQL
Prework for the demonstrations
Create and activate a configuration for PostgreSQL
Demonstration of replication for PostgreSQL
Demonstration of named post queues for PostgreSQL
Advanced SharePlex Demonstrations for PostgreSQL
Demonstration of Conflict Resolution - PostgreSQL to PostgreSQL
Demonstration of conflict resolution - PostgreSQL to Oracle
Sample configuration for PostgreSQL to PostgreSQL replication
Configure, activate, and verify replication on the PostgreSQL source
Database Setup for PGDB as a Service
Installation of pg_hint_plan extension
Solve Installation Problems for PostgreSQL
Network checklist for PostgreSQL
Installer checklist for PostgreSQL
Review and satisfy all of the requirements in this checklist before installing SharePlex.
Note: The requirements in this checklist apply to all source and target systems where SharePlex will be installed unless otherwise noted.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
