Versions Compared

Key

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

...

No Format
Please enter database TNS alias: [] source

Enter the username and password of a user with SYSDBA. Accept the default of SYS and change_on_install.

No Format
Please enter SYSDBA user name: [SYS]

SYS password is change_on_install:

No Format

Please enter password for this user: [change_on_install] 

Enter the username and password of a user with the DBA role. Accept the default of SYSTEM and manager.

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

SYSTEM password is manager:

No Format
Please enter password for this user: [manager]

7. Specify the defaults to create the Dbvisit Replicate schema in the source database. The Accept the default username is dbvrepof dbvrep and the default password of dbvpasswd.

No Format
Connecting to database source 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] 

Specify the USERS tablespace as the default tablespace for the dbvrep user.

No Format
Permanent tablespaces detected on the database: REPOE_DATA, USERS. 

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

Specify the TEMP tablespace as the temporary tablespace for the dbvrep user.

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

...

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

...

No Format
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]

9. The TNS alias is TTORCL_TRGis target.

No Format
Please enter database TNS alias: [] ttorcl_trgtarget                                                                                                          

Enter the username and password of a user with SYSDBA. Accept the default of SYS and change_on_install.

No Format
Please enter SYSDBA user name: [SYS]
Please enter password for this user: [change_on_install]

Enter the username and password of a user with the DBA role. Accept the default of SYSTEM and manager.

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

SYS password is oracle

No Format
Please enter password for this user: [change_on_install] ******
No Format
Please enter user with DBA role: [SYSTEM]            

 Specify the defaults to create the Dbvisit Replicate schema in the target database. Accept the default username of dbvrep and the default password of dbvpasswd.

No Format
Connecting to database target                                                                                                                  

SYSTEM password is oracle

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

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

No Format
Connecting to database ttorcl_trg 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]                                             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] 

Specify the USERS tablespace as the default tablespace for the dbvrep user.

No Format
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 for the dbvrep user.

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

...

No Format
Following databases are now configured:
1: Oracle ttorcl_srcsource, SYS/***, SYSTEM/***, dbvrep/***, USERS/TEMP, dbvrep/, ASM:NO, TZ: +00:00
2: Oracle ttorcl_trgtarget, SYS/***, SYSTEM/***, dbvrep/***, USERS/TEMP, dbvrep/, ASM:NO, TZ: +00:00
Enter the number of the database to modify it, or "add", or "done": [done] 

...