Page Comparison

...

• Server Name
• Server IP Address (Make sure that you have an internal and external IP address.  Talk to your admin about firewalls.)
• oracle Oracle (Unix User) password
• Source Database Name
• Source TNS Alias (Make sure it is located in local tnsnames.ora)  also have the full path ready
• SYS  password
• SYSTEM password                 
• List of Schemas or Objects you want to replicate      
• Sufficient disk space to store Dbvisit Replicate Mine PLOGS (default location /home/oracle/<DDC>/)
  For a list of system requirements:
  System Requirements 

...

Assumption is that Oracle database is installed, up and running and has a sys/system user. Also a tablespace that is already will need to be created. Note that in this guide the the Apply server is an Oracle Linux EC2 Instance in AWS.    Note Note that the example initial export dump and import (instantiation) of the source data into the target will be performed from the source database server using Oracle Datapump over a database link.  'Regular' export/import may also be done. Before starting with the Dbvisit Replicate configuration it is recommended to make sure you have the following information ready with regards to the Apply server and process:

• EC2 - Server Name
• Server IP Address (This will be the public DNS on EC2)
• root (Unix User) Password  ********password
• oracle (Unix User) Password  **********Even though this system will not run an Oracle Database, we will make use of an Oracle Unix account as well as the Oracle Instance Client to establish connections between the source and target)password  
• Target Database Name (Amazon AWS EC2 instance)
• Target TNS Alias (Make sure it is located in local tnsnames.ora) also have the full path ready
• A SYS username and password in the EC2 instanceA
• SYSTEM username and password in the EC2 instance DBVREP (Dbvisit Repository) PasswordDbvisit Replicate has a repository in both source and target using the “dbvrep” user name by default.  This account is created during Dbvisit Replicate installation and configuration.           
• Sufficient disk space to store Dbvisit Replicate Apply PLOGS (default location /home/oracle/<DDC>/)
  **** put some size estimation here*****
  For a list of system requirements:
  System Requirements 

SOURCE TNSNAMES.ora

SOURCE_DB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sdfdsfsdfonaws.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = awsdb)
    )
  )

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

...