Shareplex only allows one active config per datasource per port. But the reverse is not true. Meaning, it is possible to have an active config file with more than one datasource. What this means is that you can bring more than one source SID into replication using one SharePlex instance. So this approach will allow replication from one or more PDBs (or for that matter PDB and non-PDB source SIDs to one or more PDB and non-PDB targets. This solution delves on the way to achieve this.
It is possible to have a single SharePlex instance replicate data from two or more source SID. To do that (assuming that there are two source SIDs involved):
1. Set appropriate value for ORACLE_HOME and ORACLE_SID besides the SP_COP_TPORT, SP_COP_UPORT and SP_SYS_VARDIR when running ora_setup for the first SID. If the source is a PDB, make sure to run ora_setup as detailed in SharePlex Installation Guide.
2. Set appropriate value for ORACLE_HOME and ORACLE_SID besides the SP_COP_TPORT, SP_COP_UPORT and SP_SYS_VARDIR when running ora_setup for the second SID.
3. Likewise run ora_setup on the target(s)
4. Start SharePlex on source and target.
5. Activate the first config file that has the datasource pointing to the first SID.
6. Activate the second config file that has the datasource pointing to the second SID.
7. At this point if you issue "list config", you will see two active config file. Also, "status" will show you two set of Capture, Read and Export processes and "qstatus" will show you two Capture and Export queue.
