SharePlex replication from Oracle On-premises to Oracle on RDS.
In this scenario, Capture, running on premises, connects to the source database through a bequeath connection and the Post process connects to the RDS database through TNS.
NOTE: In a high-volume transactional environment, the buildup of data in the post queues and the presence of multiple Post processes may generate unacceptable overhead for a production system. In that case, you should use an intermediary server.
You can use an on-premises intermediary server to run the Import and Post components (and the post queues). This method removes most of the replication overhead from the source server.
Demo Environment:
Source: Oracle on Premises.
Target: Oracle Amazon RDS
Steps overview:
Steps in detail:
1. Install SharePlex
Install SharePlex on the source (and on the intermediary server, if using one for the Post process).
This demo assumes the SharePlex binaries are already installed. If you need assitance with the install, please refer to the SharePlex 9.1 Install guide.
2. Configure TNSnames.ora:
ORACLERDS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =oraclerds.ch2b8qrh6oss.us-east-2.rds.amazonaws.com )(PORT = 1521))
(CONNECT_DATA =
(SID = ORCL)
)
)
3. Running ora_setup:
This process creates tables and user accounts needed to run Oracle SharePlex replication.
NOTE: ora_setup will need to be run twice, once for the source on premises instance and secondly for the RDS target instance.
On the source, run ora_setup for the source database.
Prepare Config:
Set up routing in the configuration file
Activate config
sp_ctrl> verify config rds
5. Verify Replication:
Oracle on Premises, Insert DML into splexrds.demo_src and verify the data is replicated to splexrds.demo_dest on Oracle RDS.
In Toad for Oracle, establish a connection to Oracle RDS.
For Example: oraclerds@ORACLERDS.CH2B8QRH6OSS.US-EAST-2.RDS.AMAZONAWS.COM:1521/ORCL
Select * from splexrds.demo_dest;
