Non Oracle (target) Replication

Owned by Anonymous
Last updated: Nov 25, 2014 by KrupeshD (Deactivated)

Dbvisit Replicate can be configured to replicate data from Oracle to MySQL and SQL Server.  You can add MySQL and SQL Server database in the first step of setup wizard. There are following limitations when configuring non-Oracle databases with Dbvisit Replicate.

  • In all replications, source must be an Oracle database. Thus, two-way replication with MySQL and SQL Server as target is not supported.
  • DDL replication is not supported for MySQL and SQL Server as target.
  • Datatypes must be mapped between Oracle to MySQL/SQL Server otherwise replication may fail.Example: timestamp datatype of Oracle is not available in SQL Server and MySQL.

Configuring TNS_ADMIN For Non Oracle Replication

When starting, Dbvisit Replicate processes need to connect to the DDC database to load the DDC DB settings. This is done by reading the DDC file (specific for each process) that contains credentials to the DDC Database (which is usually placed within the source (Oracle) database). Dbvisit Replicate comes with its own Oracle Instant Client to allow the connection from the target server where no Oracle client is installed. Therefore, on the target server or the server hosting APPLY process,TNS_ADMIN directory and tnsnames.ora files must be created to enable APPLY process to communicate with source Oracle database. 

 

To configure the APPLY process properly, pay attention to the following:

When running the Setup Wizard - Step 4 - Process configuration, many settings are pre-filled with defaults:

Following settings were pre-filled with defaults or your reloaded settings:
----------------------------------------
[APPLY_REMOTE_INTERFACE]: Network remote interface: mysqlsrv:7902 
[APPLY_DATABASE]: Database MySQL connection string: database=dbvrep456;host=mysqlsrv 
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/10.2.0/db_1/network/admin 
[APPLY_USER]: Dbvisit Replicate database username: root 
[APPLY_PASSWORD]: Dbvisit Replicate database password: ****** 
[APPLY_SCHEMA]: Dbvisit Replicate database (schema): dbvrep456 
[APPLY_STAGING_DIR]: Directory for received plogs: /home/mysql/mysql_test_repl/apply 
[LOG_FILE]: General log file: /home/mysql/mysql_test_repl/log/dbvrep_%N_%D.%E 
[LOG_FILE_TRACE]: Error traces: /home/mysql/mysql_test_repl/log/trace/dbvrep_%N_%D_%I_%U.%E
Checking that these settings are valid...
Do you want change any of the settings? [no] yes

You can either set correct TNS_ADMIN in setup wizard or by manually editing APPLY.ddc file later. You have to create a new tnsnames.ora file and placed it to the directory specified by the TNS_ADMIN parameter and add an entry for in the tnsnames.ora file pointing to the source oracleÂ