Versions Compared

Old Version 14

changes.mady.by.user KrupeshD

Saved on

compared with

New Version Current

changes.mady.by.user Arjen Visser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

Panelnoformat
bgColorCCC
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

...