SharePlex Replication

SharePlex is a potential replacement for Oracle Advanced Replication or Oracle Streams Replication.  Now that both these have been removed from Oracle 12C its time to consider alternatives.  Oracle Gold Gate is a possible but it’s expensive and complex.  SharePlex seems to have a lot going for it in terms of simplicity and ability to use it across different database environments.

[table id=1 /]

Sources:
https://support.quest.com/technical-documents/shareplex/8.6.4/installation-guide

Useful SharePlex Commands:
• startup, shutdown
• all configuration commands relating to an active configuration
• all parameter commands except list param
• start capture
• stop capture
• abort capture
• truncate log