Upgrading – Linux/Unix
Upgrading from version 5.2.x, 5.3.x or 6.0.x to 6.0.x
Please note:
1. Upgrading of Dbvisit Standby software needs to be done on both 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 (or RAC nodes)
1. Unzip the dbvisit-standby6.0_<os>.zip file to a temporary directory. This can be done on a local PC.
(where <os> is the Operating System - linux, hpux, aix, solaris etc)
2. Copy the installation file dbvisit-standby6.0.x.tar to a temporary directory on the primary server (eg /usr/tmp).
3. Change directory to the temporary directory (/usr/tmp).
4. Untar the file.
5. A new directory dbvisit will be created.
6. Change directory into the dbvisit directory.
7. Ensure dbvisit_installhas the correct privileges to be executed.
8. Run dbvisit_installto install Dbvisit Standby and Dbvserver (providing the web interface to Dbvisit Standby).
9. All the defaults can be accepted.
10. The Dbvisit Standby and Dbvserver software have now been upgraded.
11. The Dbvisit Standby configuration is next to be upgraded. Both the Dbvisit Database Configuration (DDC) file and Dbvisit Database Repository (DDR) needs to be upgraded. This can be done through the command line interface (CLI) indicated by or web based interface (GUI) indicated by
12. Start browser and specify the URL given. Note the port number.
13. The Dbvisit Standby login screen will be displayed. The default username/password is admin/admin.
14. 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.
15. 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.
16. If the DDR needs to be upgraded, select Upgrade Dbvisit Repository
17. Repeat upgrade of DDC and DDR for all databases on this primary server.
18. 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.
19. To update the DDC and DDR through the command line interface, run dbvisit_setup.
20. Choose options 6 to ensure all the latest parameters (or variables) are available in the Dbvisit Standby Database Configuration (DDC) file.
21. Choose for which database the updated applies.
22. Dbvisit Standby will give the option to review all the variables. Choose No.
23. The new DDC file will now be created. The old DDC file will be renamed.
24. The main menu will be displayed again.
25. Choose option 5) Manage Dbvisit Standby Database repository (DDR).
26. Choose option 3) Check version of Dbvisit Standby Database repository (DDR).
27. Choose for which database the check applies.
28. Dbvisit Standby will now indicate if the DDR is up to date.
29. If Dbvisit Standby indicates that the DDR should be upgraded, then choose option 1 to upgrade.
30. Return to the main menu.
31. Repeat upgrade of DDC and DDR for all databases on this primary server.
32. Once the main menu is displayed again, choose e to exit out of main menu.
Completing the upgrade
33. Repeat above steps on all:
i. primary servers (including RAC nodes)
ii. standby (or secondary servers). However the DDC and DDR does not need to be upgraded on the standby servers.
34. Run Dbvisit Standby manually on the primary and standby server with the command to ensure correct functionality:
Through the command line interface (CLI) :
dbvisit <DDC>
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
35. Restart the Dbvisit Standby schedule (if using Dbvserver and this has been started, then the schedule will be automatically started).
Upgrade completed.