Page Comparison

...

More information about step - 1 is available here

...

Describe the first database:

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]                                                                      

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]

 
 Please enter database TNS alias: []

 orcl_dbvisit210

 
 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 orcl_dbvisit210 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: DATA, USERS

.

Please enter default permanent tablespace for this user: [

DATA] 
 
 Temporary tablespaces detected on the database: TEMP.

 Please enter default temporary tablespace for this user: [TEMP]

Following databases are now configured:

 1: Oracle orcl_dbvisit210, SYS/***, SYSTEM/***, dbvrep/***, 

DATA/TEMP, dbvrep/, ASM

:NO, TZ: +00:00
 Enter the number of the database to modify it, or "add", or "done": [add] 

Adding the second database:

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]

                                                                      
Please enter database TNS alias: []

 orcl_dbvisit230                                                                                                                                  
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 orcl_dbvisit230 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: 

DATA, 

USERS.
Please enter default permanent tablespace for this user: [

DATA]                                                                                                               
Temporary tablespaces detected on the database: TEMP.

Please enter default temporary tablespace for this user:

[TEMP]                                                                                                               
Following databases are now configured:

1: Oracle orcl_dbvisit210, SYS/***, SYSTEM/***, dbvrep/***, 

DATA/TEMP,
dbvrep/, ASM:

NO, TZ: +00:00
2: Oracle orcl_dbvisit230, SYS/***, SYSTEM/***, dbvrep/***, 

DATA/TEMP,
dbvrep/, ASM

:NO, TZ: +00:00
Enter the number of the database to modify it, or
"add", or "done": [done]