...

Starting the dbvrep setup wizard

The following is a step-by-step guide of configuring a replication using the setup wizard. To accept the default answer for a question, just press the Return key.

1. Connect to the source (dbv01) server  server as oracle.

su - oracle

...

Initializing......done
Dbvisit Replicate version 2.7.02.4333
Copyright (C) Dbvisit Software Limited.  All rights reserved.
No DDC file loaded.
Run "setup wizard" to start the configuration wizard or try "help" to see all commands available.
dbvrep> 

...

dbvrep> setup wizard
This wizard configures Dbvisit Replicate.
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.


                                                                                     
This wizard configures Dbvisit Replicate.
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 Run the wizard now? [yes] yes

Accept end-user license agreement? (view/yes/no) [view] yes	

3. Follow the steps and give the name of the replication. Name it dbvrep_orclXE.

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): [] dbvrep_orclXE 	

4. For the next questions, leave the defaults as they are Use the trial license key included with Dbvisit Replicate and select the MAX edition of the product.

(LICENSE_KEY) - Please enter your license key: [(trial)]

 
Which Replicate edition do you want to trial (LTD/XTD/MAX): [MAX]

Enter the location of the directory where the Setup Wizard will place the configuration files.

(SETUP_SCRIPT_PATH) - Please enter a directory for location of configuration scripts on this machine: [/u01/app/oracle/dbvrep_orclXE]                                          

Enter the location where Dbvisit Replicate will find the Oracle network configuration files.

Network configuration files were detected on this system in these locations:
[/u01/app/oracle/product/1211.12.0/dbhome_1xe/network/admin

]
(TNS_ADMIN) - Please enter TNS configuration directory for this machine: [/u01/app/oracle/product/1211.12.0/dbhome_1xe/network/admin]

...

Step 1 - Describe databases

Describe the first database. This will be the source database and will be the Oracle database on the machine called source. 

Step 1 - Describe databases
========================================
The first step is to describe databases used in the replication. There are usually two of them (source and target).
Store SYSDBA and DBA passwords? Passwords only required during setup and initialization? (yes/no) [yes]                                                                   ) [yes]

Specify the default database which is Oracle.

Let's configure the database, describing it's type, connectivity, user names etc.
What type of database is this? (Oracle/MySQL/SQL Server/Oracle AWS RDS/CSV/Hadoop): [Oracle]   

6. The TNS alias is TTORCL_SRCis source

Please enter database TNS alias: [] ttorcl_srcsource

Please enter SYSDBA user name: [SYS]

SYS password is oracle change_on_install:

Please enter password for this user: [change_on_install] ******

Please enter user with DBA role: [SYSTEM]                                                                                                                                 

SYSTEM password is oracle manager:

Please enter password for this user: [manager] ******

7. Specify the defaults to create the Dbvisit Replicate schema in the source database. The default username is dbvrep.

Connecting to database ttorcl_srcsource 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 (this user will be created by this script): [dbvrep]
Please enter password for this user: [dbvpasswd] 

...

Permanent tablespaces detected on the database: APEXREPOE_1930613455248703, APEX_2041602962184952, APEX_2610402357158758, APEX_2611417663389985, APEX_2614203650434107,
EXAMPLE, USERS.DATA, USERS. 

Please enter default permanent tablespace for this user: [APEXREPOE_1930613455248703DATA] USERS                                                                                    

Specify the TEMP tablespace as the temporary tablespace.

...

The first database is now configured. Add the next database. This will be the target database and will be the Oracle database on the machine called target.

Following databases are now configured:
1: Oracle ttorcl_src, SYS/***, SYSTEM/***, dbvrep/***, USERS/TEMP, dbvrep/, ASM:NO, TZ: +00:00

...