We're here to help!

Upgrade Replicate 2.7 to 2.9

Follow

Read our docs The steps in this article apply when you want to upgrade Dbvisit Replicate from version 2.7 to 2.9


Problem Details

Problem Statement

What is the correct process to upgrade from Replicate version 2.7 to 2.9

Applicable Error Code

N/A

Affected Versions

2.7

Affected Platforms

ALL

 

Description

When upgrading Dbvisit Replicate 2.7 to 2.9, please make sure the following are done:


Steps Performed
Status of replication running on version 2.7

/ Dbvisit Replicate 2.7.22(MAX edition) - Evaluation License expires in 30 days
MINE IS running. Currently at plog 58 and SCN 992266 (07/14/2017 11:11:24).
APPLY IS running. Currently at plog 58 and SCN 992233 (07/14/2017 11:11:21).
Progress of replication dbvrep_test:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
TEST.DEPT: 100% Mine:1/1 Unrecov:0/0 Applied:1/1 Conflicts:0/0 Last:14/07/2017 11:11:15/OK
TEST.EMP: 100% Mine:1/1 Unrecov:0/0 Applied:1/1 Conflicts:0/0 Last:14/07/2017 11:10:35/OK
--------------------------------------------------------------------------------------------------------------------------------------------
2 tables listed.
dbvrep>

  1. Shutdown MINE and APPLY

    dbvrep> shutdown all
    Dbvisit Replicate APPLY process shutting down.
    Dbvisit Replicate MINE process shutting down.
    dbvrep>
  2. Install 2.9 on SOURCE and TARGET

https://dbvisit.atlassian.net/wiki/spaces/ugd9/pages/128739277/Installing+and+Upgrading

3. Start the Console - ./start_console

| Dbvisit Replicate 2.9.00(MAX edition) - Evaluation License expires in 30 days
DDC file /u01/app/oracle/dbvrep_test/dbvrep_test-MINE.ddc loaded.
MINE: Your Dbvisit Replicate dictionary version 2.7.00 is not supported by this executable, 2.9.00 is required. Please run "upgrade repository".
APPLY: Your Dbvisit Replicate dictionary version 2.7.00 is not supported by this executable, 2.9.00 is required. Please run "upgrade repository".
Try "help"
dbvrep>

4. Upgrade MINE and APPLY repository to 2.9.00 

dbvrep> upgrade repository mine 2.9.00
Status: Upgrade to 2.8.00 done.
Status: Upgrade to 2.8.02 done.
Status: Upgrade to 2.9.00 done.
MINE: Upgrade done.
dbvrep> upgrade repository apply 2.9.00
Status: Upgrade to 2.8.00 done.
Status: Upgrade to 2.8.02 done.
Status: Upgrade to 2.9.00 done.
APPLY: Upgrade done.
dbvrep>

5. Exit the Console
6. Start the MINE and APPLY processes
7. Start the Console - ./start_console 

/ Dbvisit Replicate 2.9.00(MAX edition) - Evaluation License expires in 30 days
MINE is running. Currently at plog 58 and SCN 1000921 (07/14/2017 11:20:38).
APPLY is running. Currently at plog 58 and SCN 1000907 (07/14/2017 11:20:37).
Progress of replication dbvrep_test:MINE->APPLY: total/this execution
---------------------------------------------------
TEST.DEPT:  100%  Mine:1/1  Unrecov:0/0  Applied:1/0      Conflicts:0/0     Last:--/--
TEST.EMP:  100%  Mine:1/1  Unrecov:0/0  Applied:1/0      Conflicts:0/0    Last:--/--
----------------------------------------------
2 tables listed.
dbvrep>

 

 

 

Have more questions? Submit a request

Comments