Upgrading from version 5.2.x, 5.3.x , 6.0.x, 7.0.x to 7.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 5.1, 5.2, 5.3 and 6.0 license keys are NOT valid for 7.0. Contact Dbvisit Sales to obtain 6.0 license keys if you have current Dbvisit support.
5. Your current Dbvisit Database Configuration (DDC) configurations will be saved.
Primary and Standby Servers
Step 1: Stop Schedules and Dbvisit Standby Services
Stop the Dbvisit Standby schedule(s) (If using the Dbvserver schedule, these will be automatically stopped).
It is recommended to stop the Dbvserver and Dbvnet (if previously installed) Windows Services prior to starting the upgrade process
Step 2: Start the Installer
Double click on the Dbvisit Standby installation executable. Click on Next when the Welcome screen is presented:
Step 3: Review and Accept the license terms.
Step 4: Review Installation Owner
Please ensure that the account that is used to install Dbvisit Standby is the same account that installed the Oracle software.
For Windows 2008 and higher it is recommended that the User Account Control (UAC) be turned off.
Step 5: Choose Components to Install
For new Installations and Upgrades it is recommended to select all components in the list (Dbvnet, Dbvserver and Standby)
Step 6: Installation Location
You will be prompted for the installation location for all components, known as the DBVISIT_BASE location in version 7.
Please ensure it is the same location as where the current Dbvisit Standby you would like to upgrade is installed.
Step 7: Installer will pickup if previous version was installed
Important
It is important to state YES to this question as Dbvisit Standby will then automatically upgrade the DDC files.
If you specify NO, you will have to create new version 7 DDC files for your configuration.
Step 8: Creating the Dbvserver Windows Service
The Dbvisit Standby installer will ask you for the password of the currently connected user.
This user you are using to install the Dbvisit Software must be in the ORA_DBA Windows Group
Provide the password as requested and the Service creation will start:
Windows 2003 and 2008 has a 30second limit for services to be started. If the Dbvserver Service does not start within this 30seconds the startup will be terminated and an message similar to the one below will be displayed:
Press <ENTER> to continue. Note that the Dbvisit Standby Installer will attempt a restart of this service.
The installer will attempt a second restart of the service and will display an update on the status of the service.
Step 9: Creating the Dbvnet Windows Service
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.
=========================================================
Dbvisit Standby Database Technology
http://www.dbvisit.com
Dbvisit Database setup
Default values will be shown in []
Options:
1) New Dbvisit Database setup (combines options 2,3,4)
1a) New Dbvisit RAC Instance setup (combines options 2,3,4)
2) New Dbvisit Database configuration (DDC) file setup
3) New Dbvisit Archive Management Module (AMM) setup
4) New Dbvisit Database repository (DDR) setup
5) Manage Dbvisit Database repository (DDR)
6) Update Dbvisit Database configuration (DDC) file
7) Create Standby Database
9) Uninstall Dbvisit Database repository (DDR)
E) Exit
=========================================================
Please enter choice : 6
26. Choose for which database the updated applies.
=>Updating Dbvisit Database configuration (DDC) file.
For which database do you want to update the Dbvisit Database configuration
(DDC) file?
The following Oracle database(s) have a Dbvisit Database configuration (DDC)
file on this server:
SID
===
1) w102n
2) Return to menu
Please enter choice : 1
Where w120n is the database to be upgraded.
27. Dbvisit Standby give the option to review all the variables. Choose No.
------------------------------------------------------------------------------
Would you like to review all the variables? <Yes/No> [Yes]: No
28. The new DDC file will now be created. The old DDC file will be renamed.
------------------------------------------------------------------------------
=>Writing Dbvisit Database configuration (DDC) file.
Dbvisit Database configuration (DDC) file
c:\program files\dbvisit\dbv_w12p0n.env already exists. Are you sure you want to
override? (a backup copy will be make) <Yes/No> [Yes]:
=>Dbvisit Database configuration (DDC) file
/usr/local/dbvisit/standby/dbv_w120n.env updated.
Please press <Enter> to continue...
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).
Options:
1) Upgrade Dbvisit Database repository (DDR)
2) Downgrade Dbvisit Database repository (DDR)
3) Check version of Dbvisit Database repository (DDR)
r) Return to main menu
32. Choose for which database the check applies.
------------------------------------------------------------------------------
=>Checking Dbvisit Database repository (DDR) version.
For which database do you want to check the Dbvisit Database repository (DDR)
version?
The following Oracle database(s) have a Dbvisit Database configuration (DDC) file
on this server:
SID
===
1) w120n
2) Return to menu
Please enter choice : 1
Is this correct? <Yes/No> [Yes]: Yes
Where w120n is the database to be upgraded.
33. Dbvisit Standby will now indicate if the DDR is up to date.
Database w120n is up.
Dbvisit Database repository (DDR) version: 5.7
Dbvisit software version: 5.7
Dbvisit Database repository (DDR) up to date. No need to upgrade.
Please press <Enter> to continue...
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:
i. primary servers (including RAC nodes).
ii. standby server (or secondary server). However the DDC and DDR does not need to be upgraded on the standby servers.
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
41. Restart the Dbvisit Standby schedule (if using Dbvserver and this has been started, then the schedule will be automatically started).
Upgrade is complete.