/
Step 1- Describe Databases

Step 1- Describe Databases

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: [ ] SOURCEDB

 

 

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 SOURCEDB 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: 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 SOURCEDB, SYS/***, SYSTEM/***, dbvrep/***, USERS/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 it's type, connectivity, user names etc.
What type of database is this? (Oracle/MySQL/SQL Server/Oracle AWS RDS/CSV/Hadoop): [Oracle] Oracle AWS RDS

 

 

Please enter database TNS alias: [] RDSTGT

 

 

Specify AWS RDS instance DBA user Account [] rds_admin

 

 

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

 

 

Connecting to database RDSTGT as rds_admin to query list of tablespaces and to detect ASM (by looking whether any redo logs or archived logs
are stored in ASM).
WARN-1877: This database is not in Archivelog mode; set it before starting Replicate scripts if this is a source database.
Enter the Dbvisit Replicate owner (this user will be created by this script): [dbvrep] dbvrepf

 

 

Please enter password for this user: [dbvpasswd]

 

 

Permanent tablespaces detected on the database: RDSADMIN, USERS.
Please enter default permanent tablespace for this user: [RDSADMIN] USERS

 

 

Temporary tablespaces detected on the database: TEMP.
Please enter default temporary tablespace for this user: [TEMP]

 

 

Following databases are now configured:
1: Oracle SOURCEDB, SYS/***, SYSTEM/***, dbvrep/***, USERS/TEMP, dbvrep/, ASM:NO, TZ: +00:00
2: Oracle AWS RDS RDSTGT, rds_admin/***, rds_admin/***, dbvrepf/***, USERS/TEMP, dbvrepf/, ASM:NO, TZ: +00:00
Enter the number of the database to modify it, or "add", or "done": [done]

Related content

Step 1- Describe Databases
Step 1- Describe Databases
More like this
Step 1 - Specify Databases
Step 1 - Specify Databases
More like this
Step 1 - Specify Databases
Step 1 - Specify Databases
More like this
Dbvisit Replicate: Back to Basics Part II
Dbvisit Replicate: Back to Basics Part II
More like this
Step 1 - Describe Databases
Step 1 - Describe Databases
More like this
Step 1 - Describe Databases
Step 1 - Describe Databases
More like this