How to set up replication from two source databases on the same system to a target db on another (4309245)

How to set up replication from two source database on the same system to a target db on another system.

We can set up replication from two source databases on the same system, to one target database on a different system .You can set up replication in two ways.

1. Replicate data from both source databases on the same port#.

Install Shareplex once and run ora_setup for both source sids on source side. On target install Ahareplex and run ora_setup once. On source, create and activate config for both source sids. (one config for each source sid).

2. Replicate data on two different port#.

On source:

Install Shareplex twice sharing same proddir (Assuming Shareplex version is same for both) and create seperate vardir for each port, then run ora_setup for each instance of Shareplex.

Startup sp_cop seperately on different port#.

NOTE: Before starting sp_cop for each instance of Shareplex, make sure that sp_sys_vardir, sp_cop_tport and sp_cop_uport are exported in the environment.

Target:
------------
On target, also install shareplex twice. You can share same proddir for both instances (Assuming Shareplex version is same for both) and create seperate vardir for each port, then run ora_setup for each instance of shareplex.
Startup sp_cop seperately on different port#.

NOTE: Before starting sp_cop for each instance of Shareplex, make sure that sp_sys_vardir, sp_cop_tport and sp_cop_uport are exported in the environment.