...
| Note |
|---|
Please ensure the following pre-requisites checks have been tested. Otherwise the replication will not function. |
Starting the dbvrep setup wizard
The following is a step-by-step guide of configuring a replication using the setup wizard. To accept the default answer for a question, just press the Return key.
...
| No Format |
|---|
Network configuration files were detected on this system in these locations: [/u01/app/oracle/product/11.2.0/xe/network/admin] (TNS_ADMIN) - Please enter TNS configuration directory for this machine: [/u01/app/oracle/product/11.2.0/xe/network/admin] |
Step 1 - Describe databases
Describe the first database. This will be the source database and will be the Oracle database on the machine called source.
...
| No Format |
|---|
Following databases are now configured: 1: Oracle source, SYS/***, SYSTEM/***, dbvrep/***, USERS/TEMP, dbvrep/, ASM:NO, TZ: +00:00 2: Oracle target, 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] |
Step 2 - Replication Pairs
12. Set source and targets for each replication pair. Select 1 as the source database (default) and 2 as the target database.
...
| No Format |
|---|
Following replication pairs are now configured: 1: ttorcl_src (Oracle) ==> ttorcl_trg (Oracle), DDL: yes, fetcher: no, process suffix: (no suffix), compression: no, encryption: no, network timeout: 60, prepare type: single-scn, data load: dp_networklink Enter number of replication pair to modify it, or "add", or "done": [done] |
Step 3 - Replicated Tables
17 Add the schemas or tables to be replicated.
...
| No Format |
|---|
Following tables are defined for replication pairs: 1: source (Oracle) ==> target (Oracle), DDL: yes, suffix: (no suffix), prepare: single-scn REPOE(tables) Enter number of replication pair to modify it, or "done": [done] |
Step 4 - Process Configuration
23. Specify information about the processes and where they are going to run. Press Return to accept the default values.
...