Page Comparison

A setup wizard is included to generate the required commands to configure the environment and start the replication.The wizard does not make changes to the database, it creates text-based scripts (for SQL*Plus, dbvrep and shell/cmd.exe) that do the actual work. These scripts can be edited to tailor it for specific needs before running them. More information on setup wizard is available here

The setup wizard is logically split into four parts: 

1. Describing the individual databases that are taking part in the replication.
2. Setting up the replication pairs to determine which are the source and target databases.
3. Choosing what to replicate, this can be tables and schemas.
4. Process configuration which includes hostnames, port numbers and notification settings.

Starting the wizard

Login as the user that is going to run Dbvisit Replicate On Windows, the Dbvisit Replicate processes are by default installed as services and run as LOCAL SYSTEM. and start the Dbvisit Replicate Command Console and start the setup wizard:

On Windows:

Start > Dbvisit Replicate Command Console
dbvrep> setup wizard

On Linux/UNIX (tar file): 
(do not run as root) 

cd /usr/dbvisit/replicate (this may be different)
./dbvrep
dbvrep> setup wizard

On Linux (rpm file):
(do not run as root)

cd /home/oracle/dbvrep (this maybe different)
dbvrep
dbvrep> setup wizard 

The setup wizard is usually run on the source server, although this is not strictly necessary. However, it makes the built-in checking of directories and auto-detection of tnsnames.ora more useful. The setup scripts are created in user home directory (My Documents) – a subdirectory DDC_NAME is created. In this directory, sub-directories mine, mine_stage, apply, log and ddc_backup are created. These are used as defaults for various variable settings in DDC file and can be changed if needed.