We're here to help!

Step 1 - Specify Databases

Follow

During this step information on the databases used in the replication is collected. The result is a SQL*Plus scripts that recreates the schema user and grants it required privileges.

More information about step 1 is available here

Please note that being a SQL*Plus script, the resulting file contains plain text passwords.


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 its type, connectivity, user names etc.
What type of database is this? (Oracle/MySQL/Google Cloud SQL/SQL Server/Oracle AWS RDS/CSV/Hadoop): [Oracle]             
Please enter database TNS alias: [] orcl_src                                                                                 
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 SDB11 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_src, 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]                                                
Let's configure the database, describing its type, connectivity, user names etc.
What type of database is this?
(Oracle/MySQL/Google Cloud SQL/SQL Server/Oracle AWS RDS/CSV/Hadoop): [Oracle]             
Please enter database TNS alias: [] orcl_tgt                                                                                
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_tgt 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_src, SYS/***, SYSTEM/***, dbvrep/***, DATA/TEMP, dbvrep/, ASM:No, TZ: +00:00
2: Oracle orcl_tgt, 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]                                                                      

At this stage specific details about which are the source and target databases are not yet required.

Have more questions? Submit a request

Comments