Page Comparison

cd ~oracle/dbvrep_orcl

XE

./dbvrep_orclXE-all.sh

Setting up Dbvisit Replicate configuration
Configure database ttorcl_src...
This check fails if the DBID is not the expected one...

Ok, check passed.
Configure database ttorcl_trg...
This check fails if the DBID is not the expected one...

Ok, check passed.
Object grants for database ttorcl_src...
Object grants for database ttorcl_trg...
Setting up the configuration
Initializing......done
WARN-1850: No DDC DB available, dictionary table does not exist.
DDC loaded from database (0 variables).
Dbvisit Replicate version 2.67.00.3735
Copyright (C) Dbvisit Software Limited.  All rights reserved.
DDC file /u01/homeapp/oracle/dbvrep_orclXE/config/dbvrep_orclXE-onetime.ddc loaded.
MINE: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists)
APPLY: Cannot determine Dbvisit Replicate dictionary version. (no dictionary exists)
dbvrep> #clear the no-DDC-DB-available warning
dbvrep> engineprocess clear previous warnings
dbvrep> set ON_WARNING SKIP
Variable ON_WARNING set to SKIP for process *.
dbvrep> set ON_ERROR EXIT
Variable ON_ERROR set to EXIT for process *.
dbvrep> ENGINEPROCESS SWITCH_REDOLOG
dbvrep> ENGINEPROCESS SETUP MINE DROP DICTIONARY
0 dictionary objects dropped.
dbvrep> ENGINEPROCESS SETUP MINE CREATE DICTIONARY
dbvrep> ENGINEPROCESS SETUP MINE LOAD DICTIONARY
Supplemental logging on database set.
Loading dictionary table DBRSCOL$
Loading dictionary table DBRSIND$
Loading dictionary table DBRSOBJ$
Loading dictionary table DBRSTAB$
Loading dictionary table DBRSUSER$
Loading dictionary table DBRSV_$DATABASE
ID of mine proces is 86E1BF73-6BAB-11E3-BF96-B392B0702394. If not using
DDC in database, set MINE_UNIQUE_ID to this value.
dbvrep> ENGINEPROCESS SETUP APPLY DROP DICTIONARY
0 dictionary objects dropped.
dbvrep> ENGINEPROCESS SETUP APPLY CREATE DICTIONARY
dbvrep> ENGINEPROCESS SETUP APPLY LOAD DICTIONARY
dbvrep> ENGINEPROCESS PREPARE_DP SETUP CLEAR
dbvrep> ENGINEPROCESS SETUP PAIR MINE AND APPLY
WARN-1381: Looks like table 114274 is not an IOT after all. No data
found in SQL ' select obj_ from DBRSIND$ where bo_ = ? and
bitand(type_,4) != 0  and ? between valid_from_scn and valid_to_scn and
DDC_ID = ? and MINE_PROCESS_NAME = ? '
WARN-1381: Looks like table 114334 is not an IOT after all. No data
found in SQL ' select obj_ from DBRSIND$ where bo_ = ? and
bitand(type_,4) != 0  and ? between valid_from_scn and valid_to_scn and
DDC_ID = ? and MINE_PROCESS_NAME = ? '
WARN-1381: Looks like table 114338 is not an IOT after all. No data
found in SQL ' select obj_ from DBRSIND$ where bo_ = ? and
bitand(type_,4) != 0  and ? between valid_from_scn and valid_to_scn and
DDC_ID = ? and MINE_PROCESS_NAME = ? '
1 applier SCN set.
dbvrep> SET APPLY.INSTANTIATE_SCN NOW
Variable INSTANTIATE_SCN set to NOW for process APPLY.
dbvrep> ENGINE SUPPLEMENTAL LOGGING SCHEMA OEApplier SCN set (start=513646, current=513646).
dbvrep> SET APPLY.INSTANTIATE_SCN NOW
Variable INSTANTIATE_SCN set to NOW for process APPLY.
dbvrep> EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_UNCMP #Ignore tables created by Compression Advisor
Exclude rule created.
dbvrep> EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_CMP #Ignore tables created by Compression Advisor
Exclude rule created.
dbvrep> SET PREPARE_SCHEMA_EXCEPTIONS none
Variable PREPARE_SCHEMA_EXCEPTIONS set to none for process *.
dbvrep> PROCESS SUPPLEMENTAL LOGGING SCHEMA "REPOE" ENABLE PRIMARY KEY
dbvrep> ENGINEPROCESS SWITCH_REDOLOG
dbvrep> ENGINEPROCESS WAIT_SCN_FLIP
Waited 2 seconds until scn_to_timestamp changed.
dbvrep> #single-scn instantiation: lock all tables and schemas
dbvrep> ENGINEPROCESS LOCK SCHEMAS OE"REPOE"
Locking all schemas.
Lock done.
dbvrep> #single-scn instantiation: unlock all tables and schemas, but keep the SCN
dbvrep> ENGINEPROCESS LOCK RELEASE LOCKS
dbvrep>

dbvrep> #prepare the tables (we use OFFLINE as neither MINE not APPLY is running; with OFFLINE we won't wait on network timeout)
dbvrep> PREPARE OFFLINE SCHEMA OE "REPOE"
Table REPOE.ADDRESSES instantiated at SCN 515210
Table REPOE.CARD_DETAILS instantiated at SCN 515210
Table REPOE.CUSTOMERS instantiated at SCN 515210
Column SYS_NC00017$ is special: virtual column. Excluding.
Column SYS_NC00017$ is special: hidden column. Excluding.
Column SYS_NC00017$ is special: system-generated column. Excluding.
Column SYS_NC00017$ is special: virtual column. Excluding.
Column SYS_NC00018$ is special: virtual column. Excluding.
Column SYS_NC00018$ is special: hidden column. Excluding.
Column SYS_NC00018$ is special: system-generated column. Excluding.
Column SYS_NC00018$ is special: virtual column. Excluding.
Table REPOE.INVENTORIES instantiated at SCN 515210
Table REPOE.LOGON instantiated at SCN 515210
Table REPOE.ORDERENTRY_METADATA instantiated at SCN 515210
Table REPOE.ORDERS instantiated at SCN 515210
Table REPOE.ORDER_ITEMS instantiated at SCN 515210
Table REPOE.PRODUCT_DESCRIPTIONS instantiated at SCN 515210
Table REPOE.PRODUCT_INFORMATION instantiated at SCN 515210
Table REPOE.WAREHOUSES instantiated at SCN 515210
dbvrep>
dbvrep> #single-scn instantiation: unlock all tables and schemas, forget the SCN (so it does not affect any further PREPARE statements)
dbvrep> ENGINEPROCESS LOCK CLEAR SCN
dbvrep> ENGINEPROCESS SWITCH_REDOLOG
dbvrep> #prepare script for instantiation
dbvrep> ENGINEPROCESS PREPARE_DP WRITE DP_NETWORKLINK DIRECTORY DATA_PUMP_DIR
FILE /u01/homeapp/oracle/dbvrep_orclXE/APPLY.sh DBLINK ttorcl_src USERID
SYSTEM/oracle@ttorcl_trgmanager@target
Created Data Pump script /u01/homeapp/oracle/dbvrep_orclXE/APPLY.sh, using network import.
dbvrep> create ddcdb from ddcfile
DDC loaded into database (312346 variables).
dbvrep> set ON_WARNING SKIP
Variable ON_WARNING set to SKIP for process *.
dbvrep> set ON_ERROR SKIP
Variable ON_ERROR set to SKIP for process *.
OK-0: Completed, but some operation(s) raised warnings and/or errors successfully.

These steps are required after the dbvrep_orclXE-all.sh script runs:
1) Create the necessary directory(ies) on the servers:
target: /u01/homeapp/oracle/dbvrep_orclXE

2) Copy the DDC files to the server(s) where the processes will run:
target: /u01/homeapp/oracle/dbvrep_orclXE/dbvrep_orclXE-APPLY.ddc
source: /homeu01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-MINE.ddc

3) Review that path to dbvrep executable is correct in the run scripts:
/u01/homeapp/oracle/dbvrep_orclXE/dbvrep_orclXE-run-source.sh
/u01/homeapp/oracle/dbvrep_orclXE/dbvrep_orclXE-run-target.sh

4) Copy the run script to the server(s) where the processes will run:
source: /u01/homeapp/oracle/dbvrep_orclXE/dbvrep_orclXE-run-source.sh
target: /u01/homeapp/oracle/dbvrep_orclXE/dbvrep_orclXE-run-target.sh

5) Ensure firewall is open for listen interfaces 0.0.0.0:7902, 0.0.0.0:7901 used by the processes.

6) Make sure the data on apply are in sync as of time when setup was run.
Scripts for Data Pump/export/DDL were created as requested:
/u01/homeapp/oracle/dbvrep_orclXE/APPLY.sh
Create referenced database links (if any) before running the scripts.

7) Start the replication processes on all servers:
source: /u01/homeapp/oracle/dbvrep_orclXE/dbvrep_orclXE-run-source.sh
target: /homeu01/app/oracle/dbvrep_orclXE/dbvrep_orclXE-run-target.sh

8) Start the console to monitor the progress:
/homeu01/app/oracle/dbvrep_orclXE/start-console.sh
The above list is stored in /u01/homeapp/oracle/dbvrep_orclXE/Nextsteps.txt.

[oracle@target ~]$ mkdir /u01/homeapp/oracle/dbvrep_orcl
[oracle@target ~]$ 

XE

                                         100%  522     0.5KB/s   00:00

[oracle@source dbvrep_orcl]$ scp /u01/homeapp/oracle/dbvrep_orclXE/dbvrep_orclXE-run-target.sh oracle@target-int:/u01/homeapp/oracle/dbvrep_orcl/

The word "target" in dbvrep_orclXE-run-target.sh is dependent on your target hostname. In this case, the target hostname is called target