...
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] |
...