Upgrading - Windows

Upgrading from version 5.2.x, 5.3.x or 6.0x to 6.0.x

Upgrading is very similar to installation. Individual components of Dbvisit Standby can be upgraded.
Please note:

1. Upgrading of Dbvisit Standby software needs to be done on the primary server and standby servers.

2. For Oracle RAC, the upgrade needs to be done for each primary node.

3. You may want to create a backup of the Dbvisit Standby install directory for rollback purposes (all Dbvisit software is contained within the main directory).

4. Existing 6.0 license keys are automatically applied to the new software.

5. Existing 5.1, 5.2 and 5.3 license keys are NOT valid for 6.0. Contact Dbvisit Sales to obtain 6.0 license keys if you have current Dbvisit support.

6. Your current Dbvisit Database Configuration (DDC) configurations will be saved.

Primary and Standby Servers (and RAC nodes)

1. Stop the Dbvisit Standby schedule(s) (If using the Dbvserver schedule, these will be automatically stopped).

2. Double click on the Dbvisit Standby installation executable. Click on Run.

3. Click on Next.

4. Accept the license terms.

5. Please ensure that the account that is used to install Dbvisit Standby is the same account that installed the Oracle software.

6. The components to upgrade can be chosen. To only upgrade the Dbvisit software select Dbvisit Standby and Dbvisit Dbvserver in the components list.

If you already have WinSSH and Tunnelier installed from a previous version, do not install them again and DO NOT select the option "Configure SSH2".

If this is the first installation, not an upgrade, then select all components.

 

7. Follow the on-screen instructions. You will be prompted for the installation location for all components. Please ensure it is the same location as where it is currently installed for the component you are upgrading. For the other components this can be ignored.

8. Specify if this is the primary server. Answer "Yes" if this is the primary server.

9. The previous Dbvisit Standby and Dbvserver software will be removed.

10. If the following message is displayed, it means Windows has not released all the locks on the previous installed software. Please wait for 20 seconds and click on Retry. Retry can be repeatedly clicked until the message is gone.

11. The Dbvisit Dbvserver software has been installed.

12. The Dbvisit Dbvserver Windows service will be re-created. The current Windows account password is needed to start the service.

13. The Dbvisit Dbvserver Windows service has been created and started.

14. (Only displayed on the primary server). Please answer Yes to "Do you want to configure Dbvisit Standby through a browser".

15. Dbvisit will display the URL that the browser should be pointed to start configuration of Dbvisit Standby.

16. The Dbvisit Standby Setup Wizard can be closed.

17. Start browser and specify the URL given. Note the port number.

18. The Dbvisit Standby login screen will be displayed. The default username/password is admin/admin

19. To update the Dbvisit Database Configuration (DDC) file go to Home > Setup > Update Dbvisit > Update Configuration > select Database from drop-down menu and click Save Configuration.

20. To update the Dbvisit Database Repository (DDR) file go to Home > Setup > Update Dbvisit > Manage Dbvisit Repository > select Database from drop-down menu and click Check Dbvisit Repository.

21. If the DDR needs to be upgraded, select Upgrade Dbvisit Repository

22. Repeat upgrade of DDC and DDR for all databases on this primary server.

23. Installation and upgrade complete. Please continue to Completing the upgrade below.

Alternative - command line interface (CLI)

If it is not possible to access Dbvisit Standby through a browser, the command line interface (CLI) can also be used to upgrade the Dbvisit configurations.

24. Answer "Yes" to Do you want to configure and setup Dbvisit Standby through the command line wizard.

25. The Dbvisit Standby setup utility will be started. Choose option 6 to ensure all the latest parameters (or variables) are available in the Dbvisit Standby Database Configuration (DDC) file.

26. Choose for which database the updated applies.

27. Dbvisit Standby give the option to review all the variables. Choose No.

28. The new DDC file will now be created. The old DDC file will be renamed.

29. The main menu will be displayed again.

30. Choose option 5) Manage Dbvisit Standby Database repository (DDR).

31. Choose option 3) Check version of Dbvisit Standby Database repository (DDR).

32. Choose for which database the check applies.

33. Dbvisit Standby will now indicate if the DDR is up to date.

34. If Dbvisit Standby indicates that the DDR should be upgraded, then choose option 1 to upgrade.

35. Return to the main menu.

36. Execute any other steps that the update process may indicate.

37. Repeat upgrade of DDC and DDR for all databases on this primary server.

38. Once the main menu is displayed again, choose e to exit out of main menu.

Completing the upgrade

39. Repeat above steps on all:

40. Run Dbvisit Standby manually on the primary and standby server to ensure correct functionality:

Through the command line interface (CLI) :

 dbvisit <DDC>

Where DDC is the name of the Dbvisit Database Configuration. In most cases this is the same as the database name. The DDC refers to the DDC file name which is in the form: dbv_DDC.env and contains the Dbvisit Standby settings for a particular primary and standby configuration

Through the web based graphical user interface (GUI)

 :

Home > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Default from Run Action drop-down menu > Run

Home > Run > Run Interactive > Standby Server tab > select Database from drop-down menu > select Default from Run Action drop-down menu > Run