...

AWSDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = awsdb.cu1fmi2n7nvjcu1f3524nvj.us-east-1.rds.amazonaws.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = awsdb)
    )
  )

...

This step is required to prepare the RDS database for the data to be loaded from the Source database.   In this example we will load the Swingbench OE schema from the PROD database into the RDS database DBVRDS into the tablespace DATA.  The  The first step is to create the DATA tablespace.  In the example below we added a 5G datafile.

...

In this example we created an AWS EC2   “dbvrds02” will be configured to perform the APPLY related tasks inside the AWS environment.  In an ideal configuration this instance should be in the same region and availability zone as the RDS database environment.  Also ensure there is sufficient resources on this system.

EC2 Instance 2: dbvrds02

This environment will only run an Oracle Instant Client installation with Dbvisit Replicate installed.

...

• EC2 instance running Oracle Linux 6.3
• Install Dbvisit Replicate 2.5.0.8 6 from RPM.
• Oracle client
  • Oracle client or instant client can be used, but in this example, the Oracle Express installation was used.
  • Configure the TNS_ADMIN environment:
    • /u01/app/oracle/product/11.2.0/xe/network/admin
    • create tnsnames.ora file with details for the XE source (sourceSOURCEDB) database and the target rds RDS database called “awsdb”“ RDSTGT”

XESOURCEDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dbvrds01dvrds01)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XESOURCEDB)
    )
  )
RDSTGT  AWSDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = awsdb.cu1fmi2n7nvjcu1fdi2sdn7nvj.us-east-1.rds.amazonaws.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = awsdbRDSTGT)
    )
  )

Ensure the firewall on both environments (IPTABLES) as well as the AWS security groups is configures to allow communication between these systems.  Example:

root@dbvrds01:[/root] # cd /etc/sysconfig


root@dbvrds01:[/etc/sysconfig] # cat iptables
# Firewall configuration written by system-config-securitylevel
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
:RH-Firewall-1-INPUT - [0:0]
-A INPUT -j RH-Firewall-1-INPUT
-A FORWARD -j RH-Firewall-1-INPUT
-A RH-Firewall-1-INPUT -i lo -j ACCEPT
-A RH-Firewall-1-INPUT -p icmp --icmp-type any -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 1521 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 7901 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 7902 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 7903 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 7904 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 8081 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 9090 -j ACCEPT
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 8443 -j ACCEPT
-A RH-Firewall-1-INPUT -j REJECT --reject-with icmp-host-prohibited
COMMIT

Ensure you have configured Security Group to allow the Replicate

Ensure you have configured Security Group to allow the Replicate ports (7901-7904, 1521):Image Removed.

...