Versions Compared

Key

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

...

Server/DatabaseName
Source databasereptest2 (Oracle)
Source serverdbvldemo102 (Linux)
Target databasew420g (SQL Server)
Target serverdbvisit420 (Windows 2008)
TNS alias for source database   reptest2
System DSNmstest

First of all open the Dbvisit Reporting command console from the start menu and execute 'setup wizard' command.

Note

Throughout the wizard, defaults are shown in [brackets]. Just press enter to accept them. The replication name in this example is "reptest2".

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
dbvrep> setup wizard
This wizard configures Dbvisit Replicate to start a replication process.
The setup wizard creates configuration scripts, which need to be run after the wizard ends. No changes to the databases are
made before that.
The progress is saved every time a list of databases, replications, etc. is shown. It will be re-read if wizard is restarted
and the same DDC name and script path is selected.
Run the wizard now? [yes] yes
Accept end-user license agreement? (view/yes/no) [view] yes
Before starting the actual configuration, some basic information is needed. The DDC name and script path determines where
all files created by the wizard go (and where to reread them if wizard is rerun) and the license key determines which
options are available for this configuration.
(DDC_NAME) - Please enter a name for this replication (suggestion: use the name of the source database): [] reptest2
(LICENSE_KEY) - Please enter your license key (or just enter "(trial)"): [(trial)]
(SETUP_SCRIPT_PATH) - Please enter a directory for location of configuration scripts on this machine:
[C:\Users\oracle\Documents\reptest2]

...

During this step information on the databases used in the replication is collected. The result is a SQL*Plus  SQLCMD scripts that recreates the schema user and grants it required privileges.Please note that being a SQL*Plus/SQLCMD script, the resulting file contains plain text passwords. 

Describe the first database:

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
Step 1 - Describe databases
========================================
The first step is to describe databases used in the replication. There are usually two of them (source and target); however,
there can be just one (when source and target is the same) or more than two (one-to-many or other complex configurations.)
Let's configure the database, describing it's type, connectivity, user names etc.
What type of database is this? (Oracle/MySQL/MSSQL): [Oracle]
Please enter database TNS alias: [] reptest2
Please enter SYSDBA user name: [SYS]
Please enter password for this user: [change_on_install] ******

Please enter user with DBA role: [SYSTEM]
Please enter password for this user: [manager] ******

Connecting to database reptest2 as SYSTEM to query list of tablespaces and to detect ASM (by looking whether any redo logs
or archived logs are stored in ASM).
Enter the Dbvisit Replicate owner and apply user (this user will be created by this script): [dbvrep]
Please enter password for this user: [dbvpasswd]

Permanent tablespaces detected on the database: USERS.
Please enter default permanent tablespace for this user: [USERS]
Temporary tablespaces detected on the database: TEMP.
Please enter default temporary tablespace for this user: [TEMP]
Following databases are now configured:
1: Oracle reptest2, SYS/***, SYSTEM/***, dbvrep/***, USERS/TEMP, dbvrep/, ASM:NO, TZ: +00:00
Enter number of database to modify it, or "add", or "done": [add]

...

Following is the reptest2 replication console showing current status of replication. Initialization of APPLY process may take 5 to 7 minutes

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
-MINE IS running. Currently at plog 425 and SCN 12377134 (09/05/2012 21:58:15).
APPLY IS running. Currently at plog 425 and SCN 12377168 (09/05/2012 21:58:27).
Progress of replication reptest1:MINE->APPLY: total/this execution
---------------------------------------------------------------------------------------------------------------------------------
AVI.SAMPLE:                   100%  Mine:1/1             Unrecov:0/0         Applied:1/1         Conflicts:0/0       Last:05/09/2012 21:58:30/OK
---------------------------------------------------------------------------------------------------------------------------------
1 tables listed.
Note

Initialization of APPLY process can take 5 to 7 minutesScitps generated by setup wizard contains plain text passwords. You can delete these scripts once replication is configured and running.