We're here to help!

Upgrade Dbvisit Standby

Follow

1.  Introduction


The Dbvisit Standby upgrade process in Version 9 will be similar to the process in earlier versions.  There are a number of pre-requisites before upgrading:

  • Dbvisit Standby version to be upgraded MUST be at least version 8 (latest update recommended).
  • The Operating System and Database Version requirements are met.  
  • Dbvisit Standby version 9 will not work with Oracle versions lower than 10.2.0.5

Prior to performing any upgrades, it is recommended to make sure you have sufficient backups.  This is good practice for any software upgrade.

This can easily be done by just backing up the DBVISIT_BASE folder prior to installing the new version.

Before starting the upgrade process, please make sure all Dbvisit Standby schedules are stopped.

Central Console (dbvserver) must be the same version as all the other components. We can not run dbvserver on a lower or higher version than dbvnet, dbvagent, and core.


The rest of this section will take you through the upgrade process from Dbvisit Standby version 8.0.x to 9.0.x


Important Notes:

  1. If you are using Dbvisit Standby version 5 or 6, you can either first install version 7 and then upgrade to version 8 then version 9, or install a new version 9 (in a separate location) and re-create your DDC configurations. You will not be required to recreate standby databases. 
  2. IMPORTANT: Before performing the upgrade process it is important to make sure that all pre-requisite checks were performed and met. Ignoring these can lead to Dbvisit Standby version 9 installation failure as well as Dbvisit Standby not behaving as expected. For more detail please see Installation Prerequisites
  3. If you are upgrading from version 7.0.x in an Oracle RAC configuration, please note the following:
    1. Dbvisit Standby version 8 and 9 handles Oracle RAC configurations different.
    2. You MUST create a new DDC file from scratch - you cannot perform an upgrade as when using version 8 or 9 in an Oracle RAC configuration, the RAC settings in the DDC file is totally different. The upgrade process will not upgrade these old DDC files to the correct format - you must run the NEW DDC file creation.
    3. In Version 8 and above, Dbvisit Standby is more Oracle RAC aware and it is recommended to run Dbvisit Standby from only one node in the RAC cluster instead of running it on each of the nodes.
    4. There is no more RAC_TAKEOVER or RAC_TAKEOVER_FORCE settings in the DDC File and if set they will be ignored.
    5. Dbvisit Standby version 8 and above, will detect all Threads in the cluster and ship all archive logs, no need to set the takeover settings or have Dbvisit Standby run on both RAC nodes.
    6. We recommend the use of shared storage for the Dbvisit Standby installation - example the use of ACFS, which is then shared between the RAC nodes. This will allow Dbvisit Standby components such as Dbvnet, Dbvserver and Dbvagent to be added as cluster resources.
    7. If you do not have the option to create shared storage, you will have to use local storage. This does have some challenges, as if the node you are running on fail, you do not have shared storage that can fail over. To accommodate this, you can use a tool such as "rsync" to sync this folder between the RAC nodes. Then in the case of failure on the one node, you have the other node where you can then start Dbvisit Standby - note that we still recommend the use of a Virtual IP to be used.
      For more detail on Oracle RAC configurations, please see the advance Oracle RAC configuration section in the documentation

For creating a new Oracle RAC DDC files see the examples here

  1. Oracle RAC primary to Single Instance standby - The Dbvisit Standby Configuration (DDC) File#2.5.CreateaDDCFile-OracleRACprimarytoSingleInstanceStandby
  2. Oracle RAC primary to Oracle RAC standby - The Dbvisit Standby Configuration (DDC) File#2.4.CreatingaDDC-OracleRACprimarytoOracleRACstandby



2.  Linux - Upgrade from Dbvisit Standby version 7.0.x

If you are using Dbvisit Standby 7.0.x you must first upgrade to Dbvisit Standby version 8 before you can upgrade to version 9.0.x. You can directly move to Version 9.0 by doing a fresh install and creating a fresh DDC file. Remember you don't have to re-create your standby database for moving Version 7.0.x to Version 9.0 if your standby already exists and is in sync.

For more details on upgrading from version 7.0.x to version 8.0.x please see the Dbvisit Standby version 8 documentation. 


3.  Linux - Upgrade from Dbvisit Standby version 8.0.x or 9.0.x


It is recommended to be on the latest update of Dbvisit Standby version 8 prior to upgrading to version 9.

The upgrade process consists of two key steps:

  1. Upgrade (install) the new version 9 software.
  2. Upgrade the DDC files and repository to reflect the latest release.

When upgrading from version 8.0.x, the process is easy and should only take a few minutes.

The high level recommended steps are:

  1. Stop your Dbvisit Schedules if you have any running.
  2. Stop or wait for any Dbvisit processes that might still be executing.
  3. Backup the Dbvisit Base location where your software is installed.
  4. Download the latest version from www.dbvisit.com
  5. Extract the install files into a temporary folder, example /home/oracle/9.0
  6. Start the Installer and select to install the required components.
  7. Once the update is complete, you can remove the temporary install folder where the installer was extracted.
  8. Apply the new version 9 license key.
  9. It is recommended to run a manual send/apply of logs once an upgrade is complete.
  10. Re-enable any schedules

The section below will show you a detailed example of the upgrade process.

3.1.  Example 1 - Upgrading Dbvisit Standby Core Components

The first example shows the upgrade process for the Dbvisit Standby version 8 core components which include - Dbvnet, Dbvagent and the Standby Core CLI.

The steps followed below are:

3.1.1.  Prerequisite Steps

  1. Stop all schedules if used - on Unix systems if schedules are used it would be via the UNIX "CRON" schedule.  You can use the "crontab -l" command to list any schedules and if you want to edit them use "crontab -e
  2. Stop the Dbvisit components. Check the processes running and by running ps -ef |grep dbv which would list out processes that are running and you can stop them. Below is the example for stopping the Dbvisit components from both primary and standby. We have our dbvserver installed in the standby server in this example.

Primary: dbvel71 Standby: dbvel72

Stopping the components in Primary:
[oracle@dbvel71 standby]$ ps -ef |grep dbv
oracle    4620     1  0 18:33 ?        00:00:00 ./dbvnet -d start
oracle    4629     1  0 18:33 ?        00:00:00 ./dbvagent -d start
oracle    6374     1  0 18:46 ?        00:00:00 ./dbvctl -d ORCLCDB -D start
oracle    6681  3951  0 18:51 pts/0    00:00:00 grep --color=auto dbv
[oracle@dbvel71 standby]$ pwd
/usr/dbvisit/standby
[oracle@dbvel71 standby]$ ./dbvctl -d ORCLCDB -D stop
Stopping Dbvisit Daemon...
Successfully stopped.
[oracle@dbvel71 standby]$ cd ../dbvnet/
[oracle@dbvel71 dbvnet]$ ./dbvnet -d stop
Stop signal has been sent to pid: 4620
[oracle@dbvel71 dbvnet]$ cd ../dbvagent/
[oracle@dbvel71 dbvagent]$ ./dbvagent -d stop
Stop signal has been sent to pid: 4629
[oracle@dbvel71 dbvagent]$ cd ../standby/
[oracle@dbvel71 standby]$ ps -ef |grep dbv
oracle    6760  3951  0 18:52 pts/0    00:00:00 grep --color=auto dbv
[oracle@dbvel71 standby]$

Stopping the components in the Standby:

[oracle@dbvel72 standby]$ ps -ef |grep dbv
oracle    4899     1  0 18:34 ?        00:00:00 ./dbvnet -d start
oracle    4907     1  0 18:34 ?        00:00:00 ./dbvagent -d start
oracle    4982     1  0 18:35 ?        00:00:02 ./dbvserver -d start
oracle    7878     1  0 18:46 ?        00:00:00 ./dbvctl -d ORCLCDB -D start
oracle    8510  3902  0 18:53 pts/0    00:00:00 grep --color=auto dbv
[oracle@dbvel72 standby]$ ./dbvctl -d ORCLCDB -D stop
Stopping Dbvisit Daemon...
Successfully stopped.
[oracle@dbvel72 standby]$ cd ../dbvnet/
[oracle@dbvel72 dbvnet]$ ./dbvnet -d stop
Stop signal has been sent to pid: 4899
[oracle@dbvel72 dbvnet]$ cd ../dbvagent/
[oracle@dbvel72 dbvagent]$ ./dbvagent -d stop
Stop signal has been sent to pid: 4907
[oracle@dbvel72 dbvagent]$ cd ../dbvserver/
[oracle@dbvel72 dbvserver]$ ./dbvserver -d stop
Stop signal has been sent to pid: 4982
[oracle@dbvel72 dbvserver]$ ps -ef |grep dbv
oracle    8550  3902  0 18:54 pts/0    00:00:00 grep --color=auto dbv
[oracle@dbvel72 dbvserver]$


  1. Backup the Dbvisit Standby installation directory (optional - but recommended)

    In this example, we will backup the /usr/dbvisit directory using the "tar" command to create a backup in a backup folder called /home/oracle/backup.  You can use the "du -sh" command to confirm the /usr/dbvisit directory size prior to backup.  The "tar" command used in this case will use the -z option to enable compression.

    [oracle@dbvel71 dbvisit]$ pwd
    /usr/dbvisit
    [oracle@dbvel71 dbvisit]$ du -sh .
    232M	.
    [oracle@dbvel71 dbvisit]$ tar czf /home/oracle/backup/dbvisit_backup_29May2019.tar.gz .
    [oracle@dbvel71 dbvisit]$ ls -lrt /home/oracle/backup/dbvisit_backup_29May2019.tar.gz
    -rw-r--r--. 1 oracle oinstall 68702946 May 28 18:57 /home/oracle/backup/dbvisit_backup_29May2019.tar.gz
    [oracle@dbvel71 dbvisit]$



If you have a regular backup schedule the above backup process might not be required.

Backing up the full directory is not strictly required, the most important files are located in /usr/dbvist/standby/conf/ which is the DDC files and their respective repositories. It is recommended to have at minimum at least a backup of this folder.


Now that the required process is stopped and a backup is created, you can continue with the upgrade process.


3.1.2.  Start The Upgrade Process

  1. Download the latest installation package and placed it in /home/oracle/9.0 folder - which was empty 
  2. A listing of the install file is shown
  3. The install package is then extracted using the "unzip <package-name>.zip" command followed by the extracting of the archive file with the command "tar -xf <package-name>.tar"
  4. You will now have a subfolder called dbvisit with the install files located inside.
  5. Navigate to the dbvisit/installer subdirectory with cd dbvisit/installer 
  6. The installer is then started with the command: ./install-dbvisit 
  7. The first question that will be asked is the destination installation path also known as the Dbvisit Base directory, in the example, the default is used "/usr/dbvisit" as this is where the previous version was installed, that we want to upgrade.
  8. The next screen will display a summary of the options installed as well as the new installer version.  (The major or minor version numbers may be different)
  9. You will be asked to confirm if you want to Install, Uninstall components or Terminate the installer.  In this case, we want to select "Install" which is option "1"
  10. The following menu option will display the 6 possible options.  In this case, we have the Core components installed - dbvnet, dbvagent and standby (CLI) and we would like to upgrade them.  We select option "1" to continue upgrading these 3 components.
  11. The installer will now start updating the Standby Core (CLI) first, followed by Dbvnet and then the Dbvisit Agent (dbvagent).  
  12. Once the update is complete, you will be presented with a menu showing you the installed components and their versions.
  13. Select the option "3" to Terminate the installer as we are not complete with this step.


The example below shows you the steps as discussed above:


[oracle@dbvel71 9.0]$ pwd
/home/oracle/9.0
[oracle@dbvel71 9.0]$ ls
dbvisit-standby9.0.0_1399_gf162ef6c-el6.zip
[oracle@dbvel71 9.0]$ unzip dbvisit-standby9.0.0_1399_gf162ef6c-el6.zip
Archive:  dbvisit-standby9.0.0_1399_gf162ef6c-el6.zip
  inflating: dbvisit-standby9.0.0_1399_gf162ef6c-el6.tar
[oracle@dbvel71 9.0]$ tar xf dbvisit-standby9.0.0_1399_gf162ef6c-el6.tar
[oracle@dbvel71 9.0]$ ls
dbvisit  dbvisit-standby9.0.0_1399_gf162ef6c-el6.tar  dbvisit-standby9.0.0_1399_gf162ef6c-el6.zip  INSTALL.txt  README.txt
[oracle@dbvel71 9.0]$ cd dbvisit
[oracle@dbvel71 dbvisit]$ cd installer/
[oracle@dbvel71 installer]$ ls
install-dbvisit
[oracle@dbvel71 installer]$ ./install-dbvisit

-----------------------------------------------------------
    Welcome to the Dbvisit software installer.
-----------------------------------------------------------

    It is recommended to make a backup of our current Dbvisit software
    location (Dbvisit Base location) for rollback purposes.

    Installer Directory /home/oracle/9.0/dbvisit

>>> Please specify the Dbvisit installation directory (Dbvisit Base).

    The various Dbvisit products and components - such as Dbvisit Standby,
    Dbvisit Dbvnet will be installed in the appropriate subdirectories of
    this path.

    Enter a custom value or press ENTER to accept default [/usr/dbvisit]:
     > /usr/dbvisit
    DBVISIT_BASE = /usr/dbvisit

    -----------------------------------------------------------
    Component      Installer Version   Installed Version
    -----------------------------------------------------------
    standby        9.0.0_1399_gf162ef6c                              8.0.26_0_g3fdeaadd
    dbvnet         9.0.0_1399_gf162ef6c                              8.0.26_0_g3fdeaadd
    dbvagent       9.0.0_1399_gf162ef6c                              8.0.26_0_g3fdeaadd
    dbvserver      9.0.0_1399_gf162ef6c                              not installed

    -----------------------------------------------------------

    What action would you like to perform?
       1 - Install component(s)
       2 - Uninstall component(s)
       3 - Exit

    Your choice: 1

    Choose component(s):
       1 - Core Components (Dbvisit Standby Cli, Dbvnet, Dbvagent)
       2 - Dbvisit Standby Core (Command Line Interface)
       3 - Dbvnet (Dbvisit Network Communication)
       4 - Dbvagent (Dbvisit Agent)
       5 - Dbvserver (Dbvisit Central Console) - Not available on Solaris/AIX
       6 - Exit Installer

    Your choice: 1

-----------------------------------------------------------
    Summary of the Dbvisit STANDBY configuration
-----------------------------------------------------------
    DBVISIT_BASE /usr/dbvisit

    Press ENTER to continue

-----------------------------------------------------------
    About to install Dbvisit STANDBY
-----------------------------------------------------------
    NTF repo installed.
    Component standby installed.

-----------------------------------------------------------
    About to install Dbvisit DBVNET
-----------------------------------------------------------
Copied file /home/oracle/9.0/dbvisit/dbvnet/dbvnet to /usr/dbvisit/dbvnet/dbvnet
Copied file /usr/dbvisit/dbvnet/conf/dbvnetd.conf to /usr/dbvisit/dbvnet/conf/dbvnetd.conf.201905281908
    DBVNET config file updated

-----------------------------------------------------------
    About to install Dbvisit DBVAGENT
-----------------------------------------------------------
Copied file /home/oracle/9.0/dbvisit/dbvagent/dbvagent to /usr/dbvisit/dbvagent/dbvagent
Copied file /usr/dbvisit/dbvagent/conf/dbvagent.conf to /usr/dbvisit/dbvagent/conf/dbvagent.conf.201905281908
    DBVAGENT config file updated

    -----------------------------------------------------------
    Component      Installer Version   Installed Version
    -----------------------------------------------------------
    standby        9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvnet         9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvagent       9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvserver      9.0.0_1399_gf162ef6c                              not installed

    -----------------------------------------------------------

    What action would you like to perform?
       1 - Install component(s)
       2 - Uninstall component(s)
       3 - Exit

    Your choice: 3

>>> Installation completed
    Install log /tmp/dbvisit_install.log.201905281900.
[oracle@dbvel71 installer]$

3.1.3.  Upgrade The DDC File


IMPORTANT

Before you upgrade any DDC files - please make sure that you have upgraded both the Primary and Standby Dbvisit Standby software and that if you are using Dbvnet and the Dbvagent components that you start them prior to performing the upgrade. To test the status of network connectivity please see this section Dbvisit Standby Networking - Dbvnet#Dbvnet-5.TestingDbvnetCommunication

The next step is to update the Dbvisit Standby Configuration (DDC) files which are located in DBVISIT_BASE/standby/conf directory. Before doing the below step please start all components from both primary and standby.

From Primary:
[oracle@dbvel71 installer]$ cd /usr/dbvisit/
[oracle@dbvel71 dbvisit]$ cd dbvnet/
[oracle@dbvel71 dbvnet]$ ./dbvnet -d start
Dbvnet daemon started.
[oracle@dbvel71 dbvnet]$ cd ../dbvagent/
[oracle@dbvel71 dbvagent]$ ./dbvagent -d start
Dbvagent daemon started.

From Standby:
[oracle@dbvel72 installer]$ cd /usr/dbvisit/
[oracle@dbvel72 dbvisit]$ cd dbvnet/
[oracle@dbvel72 dbvnet]$ ./dbvnet -d start
Dbvnet daemon started.
[oracle@dbvel72 dbvnet]$ cd ../dbvagent/
[oracle@dbvel72 dbvagent]$ ./dbvagent -d start
Dbvagent daemon started.
[oracle@dbvel72 dbvagent]$ cd ../dbvserver/
[oracle@dbvel72 dbvserver]$ ./dbvserver -d start
Dbvserver daemon started.
[oracle@dbvel72 dbvserver]$


During this upgrade process, the original DDC file will automatically be backed up with a date-timestamp suffix.

The command to upgrade the DDC files is:  ./dbvctl -d <DDC> -o upgrade 

The Below command must be run from the Primary Database Server

[oracle@dbvel71 standby]$ ./dbvctl -d ORCLCDB -o upgrade
=============================================================
Dbvisit Standby Database Technology (9.0.0_1399_gf162ef6c) (pid 8729)
dbvctl started on dbvel71: Tue May 28 19:22:37 2019
=============================================================


>>> DDC file ORCLCDB version: 8.0.26

>>> DDC file ORCLCDB upgraded to version 9.0.0.

>>> Dbvisit Database repository (DDR) ORCLCDB upgraded.

=============================================================
dbvctl ended on dbvel71: Tue May 28 19:22:37 2019
=============================================================

[oracle@dbvel71 standby]$ ls -lrt conf/
total 144
-rw-r--r--. 1 oracle oinstall 23130 May 28 19:18 dbv_ORCLCDB.env.201905281922
-rw-r--r--. 1 oracle oinstall  8876 May 28 19:20 dbv_message.html
-rw-r--r--. 1 oracle oinstall  8872 May 28 19:20 dbv_error.html
-rw-r--r--. 1 oracle oinstall 28672 May 28 19:20 dbv_notify.db
-rw-r--r--. 1 oracle oinstall 24709 May 28 19:22 dbv_ORCLCDB.env
-rw-r--r--. 1 oracle oinstall 37888 May 28 19:22 orclcdb.db
[oracle@dbvel71 standby]$


After the upgrade is completed you have to apply the version 9.0 license from the Primary before we can start sending and applying logs.

[oracle@dbvel71 standby]$ ./dbvctl -d ORCLCDB -l 4jo70-qwp4l-7gplh-g1cld-0ozd6-0tacd-k5q01
=============================================================
Dbvisit Standby Database Technology (9.0.0_1399_gf162ef6c) (pid 8907)
dbvctl started on dbvel71: Tue May 28 19:25:25 2019
=============================================================

=>Update with license key: 4jo70-qwp4l-7gplh-g1cld-0ozd6-0tacd-k5q01? <Yes/No> [Yes]: yes
>>> Dbvisit Standby License
License Key     : 4jo70-qwp4l-7gplh-g1cld-0ozd6-0tacd-k5q01
customer_number : 0
dbname          :
expiry_date     : 2019-06-12
os              :
sequence        : 1
software_features : 00000000
status          : VALID
updated         : YES
version         : 9

=============================================================
dbvctl ended on dbvel71: Tue May 28 19:25:28 2019
=============================================================

[oracle@dbvel71 standby]$


3.2.  Example 2 - Upgrade Central Console (Dbvserver)

This section will show you the upgrade process for the Dbvisit Standby version 9 Central Console (Dbvserver).  

The process is similar to the upgrading of the core components, but in this case, the Dbvserver component will be selected for installation (upgrade).

Prior to upgrading the Dbvserver component, it is required to first stop Dbvserver if it is already running followed by a backup of the installation destination (Dbvisit Base). 

3.2.1.  Prerequisite Steps

The steps are similar to what we have used earlier for Dbvnet and Dbvagent, the steps for Dbvserver is shown below:

  1. Stop Dbvserver:

    First, we confirm if the process is running, if it is we stop it using the "./dbvserver -d stop", followed by confirming no dbvserver processes are running.

    [oracle@dbv103 dbvisit]$ pwd
    /usr/dbvisit
    [oracle@dbv103 dbvisit]$ ps -ef|grep dbvserver|grep -v grep
    oracle   26664     0  0 22:25 ?        00:00:00 ./dbvserver -d start
    [oracle@dbv103 dbvisit]$
    [oracle@dbv103 dbvisit]$ cd dbvserver
    [oracle@dbv103 dbvserver]$ ./dbvserver -d stop
    dbvserver attempt to stop pid: 26664
    [oracle@dbv103 dbvserver]$
    [oracle@dbv103 dbvserver]$ ps -ef|grep dbvserver|grep -v grep
    [oracle@dbv103 dbvserver]$



  2. Backup the Dbvisit Standby installation directory (optional - but recommended)

    In this example, we will backup the /usr/dbvisit directory using the "tar" command to create a backup in a backup folder called /backup.  You can use the "du -sh" command to confirm the /usr/dbvisit directory size prior to backup.  The "tar" command used in this case will use the -z option to enable compression.

    [oracle@dbv103 dbvisit]$ pwd
    /usr/dbvisit
    [oracle@dbv103 dbvisit]$ tar czf /backups/usr_dbvisit.tar.gz .
    [oracle@dbv103 dbvisit]$ ls -al /backups/usr_dbvisit*
    -rw-r--r-- 1 oracle oinstall 3755257 Sep  5 22:27 /backups/usr_dbvisit.tar.gz
    [oracle@dbv103 dbvisit]$

3.2.2.  Upgrade Dbvserver

We are now ready to perform the upgrade of the Central Console (Dbvserver).

Below are the example steps followed to upgrade the Dbvserver component:


[oracle@dbvel72 installer]$ ./install-dbvisit

-----------------------------------------------------------
    Welcome to the Dbvisit software installer.
-----------------------------------------------------------

    It is recommended to make a backup of our current Dbvisit software
    location (Dbvisit Base location) for rollback purposes.

    Installer Directory /home/oracle/9.0/dbvisit

>>> Please specify the Dbvisit installation directory (Dbvisit Base).

    The various Dbvisit products and components - such as Dbvisit Standby,
    Dbvisit Dbvnet will be installed in the appropriate subdirectories of
    this path.

    Enter a custom value or press ENTER to accept default [/usr/dbvisit]:
     >
    DBVISIT_BASE = /usr/dbvisit

    -----------------------------------------------------------
    Component      Installer Version   Installed Version
    -----------------------------------------------------------
    standby        9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvnet         9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvagent       9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvserver      9.0.0_1399_gf162ef6c                              8.0.26_0_g3fdeaadd

    -----------------------------------------------------------

    What action would you like to perform?
       1 - Install component(s)
       2 - Uninstall component(s)
       3 - Exit

    Your choice: 5

    -----------------------------------------------------------
    Component      Installer Version   Installed Version
    -----------------------------------------------------------
    standby        9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvnet         9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvagent       9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvserver      9.0.0_1399_gf162ef6c                              8.0.26_0_g3fdeaadd

    -----------------------------------------------------------

    What action would you like to perform?
       1 - Install component(s)
       2 - Uninstall component(s)
       3 - Exit

    Your choice: 1

    Choose component(s):
       1 - Core Components (Dbvisit Standby Cli, Dbvnet, Dbvagent)
       2 - Dbvisit Standby Core (Command Line Interface)
       3 - Dbvnet (Dbvisit Network Communication)
       4 - Dbvagent (Dbvisit Agent)
       5 - Dbvserver (Dbvisit Central Console) - Not available on Solaris/AIX
       6 - Exit Installer

    Your choice: 5

-----------------------------------------------------------
    About to install Dbvisit DBVSERVER
-----------------------------------------------------------
Copied file /home/oracle/9.0/dbvisit/dbvserver/dbvserver to /usr/dbvisit/dbvserver/dbvserver
Copied file /usr/dbvisit/dbvserver/conf/dbvserver.conf to /usr/dbvisit/dbvserver/conf/dbvserver.conf.201905281921
    DBVSERVER config file updated

    -----------------------------------------------------------
    Component      Installer Version   Installed Version
    -----------------------------------------------------------
    standby        9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvnet         9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvagent       9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c
    dbvserver      9.0.0_1399_gf162ef6c                              9.0.0_1399_gf162ef6c

    -----------------------------------------------------------

    What action would you like to perform?
       1 - Install component(s)
       2 - Uninstall component(s)
       3 - Exit

    Your choice: 3

>>> Installation completed
    Install log /tmp/dbvisit_install.log.201905281921.


4.0.  Windows - Upgrading from Dbvisit Standby version 8.0.x to 9.0.x

Important: Prior to installing Dbvisit Standby version 9 on Windows, please make sure you have performed the pre-requisite steps prior to starting the installer - Installing Dbvisit Standby#2.5.WindowsEnvironmentPre-requisites

In this section, we will review the process to upgrade an existing Dbvisit Standby version 8 installation to the latest version 9.  It is recommended that before you perform the upgrade process that you have the Dbvisit Standby version 8 already at the latest version 8 update.  

When upgrading a Windows-based installation, there are only a few key steps to follow.  In summary, the installer will ask for the Dbvisit Base location to install the Dbvisit Software.  If you already have an installation, please make sure you select the existing installation folder as the destination.  The installer will detect that a version is already installed and will perform the upgrade - replacing the version 8 executable files with the new version 9.

4.1.   Prerequisites

The first step to stop any schedules if you have any configured.

The example below shows the disabling of a Windows scheduled task.  Select the task, right click and select disable.


If you are using Daemon service, Please stop the daemon process in both Primary and Standby

  1. Click on Daemon Actions
  2. Select the host for which you want to stop the daemon service
  3. Click stop to completely stop the daemon service.


Below screenshot will provide the status of the daemon service.

4.2.  Step 2: Installing the latest version 9.0.x software

  1. Download the latest Dbvisit Standby version 9 software, the install file will be a compressed zip file, example:  dbvisit-standby9.0.0-win64.zip
  2. Extract the downloaded install file into a temporary folder, example D:\Software\dbvisit-standby9.0.0-win64.exe
  3. Make sure that you have stopped the Dbvisit Standby schedules and that you are not running any Dbvisit processes during the upgrade process.  Stop the dbvagent and dbvnet services in both Primary and Standby. Also, stop the dbvserver service before proceeding with the installation. In this example the Primary server has dbvagent and dbvnet service and the standby has dbvagent,dbvnet and dbvserver services running. We also have the daemon service running which was stopped in the previous step.


4. Start the Installer by running (double click) the dbvisit-standby9.0.0-win64.exe file

The installer will start shortly. By default the installer will have the Dbvagent, Dbvnet and Standby CLI selected.  Note that the Dbvserver (Central Console) is not selected.  This is intentional as it is recommended to have the Dbvserver component installed on its own system.  However, if required you can install the central console as part of the installation, but be advised that this is not recommended(We need to select it for this example as we have installed the dbvserver in standby).  If the primary or standby system running the Central Console is down due to a disaster, you will not be able to access the Dbvisit Standby version 9 GUI. The installation process is similar to the Dbvisit Version 8.0.x installation process. The Dbvnet, Dbvagent and the Dbvserver configurations are updated and the services are started.


5. Once the above step is completed. Run the upgrade command from the Primary dbvctl.exe -d <DDC> -o upgrade . This has to be done before starting the daemon process in both primary and standby.

6. Apply the version 9 license key before starting the daemon service from Primary.

7. Now run the Archivelog send/apply manually and then start the daemon process for the automatic process to take over.


5.  Steps performed post upgrade in the central console.

The steps performed are common for both Linux and Windows, After the CLI upgrade the GUI repository needs to updated with the latest DDC information.

1. Open the browser and type in the console address to view the version 9.0 GUI interface and to check the DDC file go to Manage Configurations page.

2. The DDC should still show the old version and allow you to click on the status to upgrade to the Version 9.0 release.

3. After the above step, you should see the current version of Dbvisit Standby and also the status showing a tick mark.

4. Post upgrade the Database Actions screen with Time Gap displayed between Primary and Standby (This will be displayed only after the first send and apply of archivelogs).


IMPORTANT:  Please make sure that you have upgraded both primary and standby Dbvisit Standby software prior to upgrading the DDC files.  This includes making sure Dbvnet is running on both systems.

For more detail on network communication please see - Dbvisit Standby Networking - Dbvnet#Dbvnet-5.TestingDbvnetCommunication

In Windows, you may have to delete the old daemon service, install it and start it,  please see Dbvisit Standby Scheduling



Have more questions? Submit a request

Comments