Upgrade Replicate 2.7 to 2.9
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
7
Affected Platforms
ALL
Description
When upgrading Dbvisit Replicate 2.7 to 2.9, please make sure the following are done:
Run the list obsolete redo command to check if the redo is not pointing to a redo which is way back.
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.
Check for any open transactions in the source database which is still running , if so wait for the transactions to complete.
If no open transactions are running in the source database , you can either commit or rollback the transactions from the dbvrep console.
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.
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.
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>
Shutdown MINE and APPLY
dbvrep> shutdown all Dbvisit Replicate APPLY process shutting down. Dbvisit Replicate MINE process shutting down. dbvrep>
Install 2.9 on SOURCE and TARGET
https://dbvisit.atlassian.net/wiki/spaces/ugd9/pages/128739277
Start the Console - ./start_console
Upgrade MINE and APPLY repository to
9.00
Exit the Console.
Please remove the par directory (/tmp in unix environments and temp directories in windows) before starting the MINE and APPLY.
Start the MINE and APPLY processes.
Start the Console - ./start_console