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:

  1.  Run the list obsolete redo command to check if the redo is not pointing to a redo which is way back.
  2.  Run the list transactions command to check if there are any open transactions which is pointing to days older than the current date, if it is showing old transactions check below. 

                  1. Check for any open transactions in the source database which is still running , if so wait for the transactions to complete. 

                  2. If no open transactions are running in the source database , you can either commit or rollback the transactions from the dbvrep console.

     3.  If is Recommended that MINE and APPLY are in sync , if the APPLY is lagging , pause the MINE process and wait for the APPLY to catchup before proceeding with the upgrade process.

    4. Login as privileged user and grant the below to dbvrep repository user

SQL> grant execute on dbms_system to dbvrep;
In the above example dbvrep is the repository user.

    5. If your source or target is 12.2 linux please use Dbvisit Replicate versions for OEL6 and OEL7 when installing , the oracle 12.2 client libraries are included in this build .

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. Please remove the par directory (/tmp in unix environments and temp directories in windows) before starting the MINE and APPLY.

7. Start the MINE and APPLY processes. 
8. 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

  • Avatar
    John Grove

    Hi,

    Repository successfully upgraded.

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

    MINE and APPLy started.

    Dbvisit Replicate 2.9.02(XTD edition) - Fully Licensed
    MINE is running. Currently at plog 114265 (redo sequence 175793 [1] 166825 [2]) and SCN 5449674618 (11/06/2017 08:50:06).
    APPLY is running. Currently at plog 114257 and SCN 5449579835 (11/06/2017 08:18:52).
    Progress of replication OASLIVE:MINE->APPLY: total/this execution
    ---------------------------------------------------------------------

  • Avatar
    John Grove

    It seems apply is progressing, however, when i tested support package MINE command, it crashed again.

  • Avatar
    John Grove

    support package still crashing but MINE and APPLY are in SYNC now

  • Avatar
    John Grove

    Hi Petr,
    are you there?

  • Avatar
    John Grove

    Hi Petr,
    are you there?

  • Avatar
    John Grove

    Hi Petr,

    Please respond. after upgrade we do not see any issue with apply and mine process, however, the original isssue of segmentation dump with package mine command is still there, I have updated the case with all the errors.
    We need to inform the client about the status of upgrade, so need to know why the above error is happening.

    Thanks

  • Avatar
    John Grove

    I havent got any response yet

  • Avatar
    John Grove

    HI

    \ Dbvisit Replicate 2.9.02(XTD edition) - Fully Licensed
    MINE is running. Currently at plog 114545 (redo sequence 176013 [1] 166885 [2]) and SCN 5450725669 (11/06/2017 09:14:04).
    APPLY is running. Currently at plog 114542 and SCN 5450715458 (11/06/2017 09:13:56).

    It seems APPLY and MINE are stuck, they have not progressed for last 2 hours!!!!!

  • Avatar
    John Grove

    Hi, i need a webex call urgently

  • Avatar
    John Grove

    Hi Petr,

    I am facing a new situation where apply is waiting on a create external table conflict
    / Dbvisit Replicate 2.9.02(XTD edition) - Fully Licensed
    MINE is running. Currently at plog 114642 (redo sequence 176052 [1] 166943 [2]) and SCN 5452585943 (11/06/2017 12:33:39).
    APPLY is running. Currently at plog 114639 and SCN 5452491857 (11/06/2017 12:17:17) and 327 apply conflicts so far (last at 06/11/2017 12:33:38) and WAITING on manual resolve of apply conflict id 114639010004895
    Progress of replication OASLIVE:MINE->APPLY: total/this execution
    -----------------------------------------------------------------------------------------

    I have dropped that table in oasrepv ie target database and set resolve conflict as retry, however, conflict is not going and apply is still waiting