Installing Dbvisit Standby

Follow

1. Introduction

This section will cover the prerequisites for installing Dbvisit Standby version 10, and take you through the detail steps of installing the Dbvisit Standby version 10 software.

2.  Installation Prerequisites

Before installing Dbvisit Standby it is important to make sure that all prerequisites are met.  If you fail to meet these prerequisites, Dbvisit Standby might not function as expected.  It is therefore recommended to make sure you review this section in detail.

First, review the new Dbvisit Standby Architecture before you continue.  As mentioned, Dbvisit Standby version 10 uses new architecture, with newly introduced components.  For example, it is recommended that the new Web-Based user interface (dbvserver) is installed on its own system. (This may be a Physical server, Virtual Machine or even a Docker image.  However, please note persistent storage is required for the Dbvserver installation folder where a repository is kept).  More on the Dbvserver requirements will be covered in this section.

2.1.  General Requirements

Before getting into the specific requirements for the primary and standby server, it is important to cover the requirements that apply to both the primary and standby server installations.

Below are a few key points to take into account with regards to the Primary Server configuration:

  • The location of the Oracle software is called the ORACLE_HOME.  In the Dbvisit Standby configuration, this variable is also called ORACLE_HOME.
  • It is recommended that the database is listed in the /etc/oratab file if using UNIX installations.
  • Dbvisit Standby should be installed as the same user that was used to install the Oracle Database Software.
  • Using a local account on UNIX based systems are recommended - in most cases, this will be the "oracle" UNIX user account.
  • If using Windows Based installations, the user account used to install and run Dbvisit Standby must be in the ORA_DBA windows group.
  • Dbvisit Standby does support role separation, where the Oracle Database software is installed as one user - usually "oracle" and the Grid Infrastructure (ASM) software is installed as a different user - usually the "grid" user.
  • If role separation is used, where the Grid Infrastructure software is installed and owned by the “grid” user, and the Oracle Database software is owned by the “oracle” use, Dbvisit Standby should be installed as the “oracle” user.
  • NOTE: Avoid using passwords with the double-quote character in it: "
  • NFS: When using NFS based storage, it is recommended to review the supported options by Oracle - see MOS note 359515.1 for more details.  

On this page:


2.1.1.  Recommended Operating System Packages

Before installing the Dbvisit Standby it is recommended that the following operating system package (if using Linux) be installed prior to installing Dbvisit Standby version 10 Dbvserver component.  In most installations, the packages would already be installed and no additional software would be required.

  • glibc 
  • zlib
  • libaio

Confirming if these packages are installed can be done using the "rpm -qa" command, example on Oracle Linux 7.2.

[root@dbv103 dbvserver]# rpm -qa|egrep 'zlib|glibc|libaio'
zlib-1.2.7-15.el7.x86_64
glibc-2.17-106.0.1.el7_2.8.x86_64
...
...

2.1.2.  The Dbvisit Standby Base (DBVISIT_BASE) 

The location into which Dbvisit Standby software is installed into is referred to as the Dbvisit Standby base, also known as the DBVISIT_BASE.

The default location is as follow:

Unix Based SystemsWindows Based Systems
/usr/dbvisit

C:/Program Files/Dbvisit


It is strongly recommended that you make use of the default location when installing Dbvisit Standby. 

On Unix, it is important to pre-create this directory and make sure the owner and group used for this directory are the same as what was used for the Oracle Database Software installation. In most cases, this will be the Unix user "oracle" and group "oinstall" or "dba" 

Note:  It is recommended you have a minimum of 512MB of free space in this location to cater to the installation.

DBVISIT_BASE is also used to store active redolog during the switchover. Make sure, that there is also additional space available equal to the size of your redolog file

2.1.3.  Network Connectivity

IPV6 is not supported. Please, ensure you are using only IPV4 protocol.

It is recommended to make sure that the primary and standby servers are aware of the others name and IP address.  Using DNS entries or using entries in the “hosts” file can be used to do this.

The central web server (Dbvserver) should also be installed on a central location (its own server if possible) and this system must also be able to connect to the primary and standby servers.

Example entries in host file (note that xxx.xxx.xxx.xxx is IP addresses):

xxx.xxx.xxx.xxx     your_primary_server_name
xxx.xxx.xxx.xxx     your_standby_server_name

Dbvisit Standby version 10 makes use of Dbvnet by default for network communication between the primary and standby database servers, however, it is still possible (and fully supported) to make use of SSH for communication if required.  Using SSH is only allowed and supported on UNIX based systems.

It is recommended that you make sure the following ports are open on each of the servers to allow for communication between them, as well as to allow the end-user to connect to the Dbvisit Web GUI:

  • Dbvisit Networking (Dbvnet)
    • The default port used is 7890

  • Dbvisit Agent (Dbvagent)
    • The default port used is 7891

  • Dbvisit GUI (Dbvserver)
    • The default port used for HTTPS is 4433
    • Note that HTTP is not an option and that HTTPS must be used.
  • If SSH is used instead of Dbvnet, the default SSH port 22, should also be open and passwordless authentication (SSH equivalence) must already be configured.  If SSH is used, the account running Dbvisit Standby must be the same as the Oracle database software owner.

The below figure should explain this as well.

Note: in most cases, you will need to allow these ports to be open in your IPTABLES or any other local firewall configuration if you are using Linux, or you will have to update your Windows firewall settings if a Windows is used.

2.1.4.  Network Connectivity when using Oracle RAC

Note that in Dbvisit Standby version 10, Oracle RAC configurations are treated the same as version 9 and 8 which is different from earlier versions.

If you want to upgrade from version 7 to version 10, we recommend you perform a clean new version 10 installation and create a new DDC file. This is due to a large number of changes Dbvisit Standby version 10 brings with regards to Oracle RAC configurations.

In Dbvisit Standby version 10, we recommend that you run Dbvisit Standby only on one of the Oracle RAC nodes and make use of shared storage.

For more detail please see these sections:

When installing Dbvisit Standby version 10 in an Oracle RAC configuration, the following will be required:

A new Virtual IP and Name for each of the Primary and Standby database clusters (if both are Oracle RAC, otherwise if the standby server is a single instance - single node server, no Virtual IP and Name will be required for the standby as the standby server details will be used as is).

Example,  you have a 2 node Oracle RAC cluster with node1 and node2 with the following example IP configuration (extract from /etc/hosts)

192.168.1.11    node1.demo.net node1
192.168.1.12    node2.demo.net node2
192.168.1.13    node1-vip.demo.net node1-vip
192.168.1.14    node2-vip.demo.net node2-vip
10.0.1.11       node1-priv.demo.net node1-priv
10.0.1.12       node2-priv.demo.net node2-priv

# 192.168.1.15    racdb-scan.demo.net  racdb-scan  ## note these SCAN addresses should be in the DNS not hosts file
# 192.168.1.16    racdb-scan.demo.net  racdb-scan ## note these SCAN addresses should be in the DNS not hosts file
# 192.168.1.17    racdb-scan.demo.net  racdb-scan ## note these SCAN addresses should be in the DNS not hosts file

You will now configure Dbvisit Standby version 10 on this cluster which will run on only one of the nodes at a time - no need to run Dbvisit Standby on both RAC nodes.  

Shared storage for the Dbvisit Standby installation will be used - example /usr/dbvisit might be using a shared ACFS filesystem.

To allow appropriate communication from the standby to the correct primary RAC node that is running the Dbvisit Standby version 10 software, a Virtual IP (name) is created, an example in the case above configuration the following can be added:  

192.168.1.18     dbvracdb-vip.demo.net   dbvracdb-vip

For more detail on creating this Virtual IP, please see the Oracle Documentation with regards to the command "appvipcfg"

Below is an example of the steps to create the Virtual IP on a Linux based RAC configuration and starting it on node1 (These commands are only executed on one of the nodes - example node 1 and is done as the "root" user)

appvipcfg create -network=1 -ip=192.168.1.18 -vipname=dbvracdb-vip -user=root
crsctl status resource dbvracdb-vip -p
crsctl setperm resource dbvracdb-vip -u user:oracle:r-x
crsctl setperm resource dbvracdb-vip -u user:grid:r-x
crsctl start resource dbvracdb-vip -n node1

2.1.5.  Default TEMP Directory

When installing Dbvisit Standby and you may get the following error "Error: Can't locate libperl.so"

Example:

oracle@dbvlin103[/home/oracle/8.0/dbvisit/installer]: ./install-dbvisit
Error: Can't locate libperl.so
...........

Background Information:

When Dbvisit Standby is executing, including Dbvnet and Dbvserver, temporary files are extracted and used from the default system temp location. 

On most Unix system this will be /tmp  The problem, in this case, is that the /tmp mount point was mounted using the "noexec" option.  

Using the mount command you can quickly review the settings:

oracle@dbvlin103[/home/oracle/10.0/dbvisit/installer]: mount |grep tmp
tmpfs on /dev/shm type tmpfs (rw,size=2G,rootcontext="system_u:object_r:tmpfs_t:s0")
tmpfs on /tmp type tmpfs (rw,noexec,size=2G)

In some cases where environments are locked down, this might be seen.


Solution:

There are two possible options to get past this.


1.  Ask the system administrator to mount the /tmp filesystem without the "noexec" option.

2.  Create a new temporary directory and set the TMPDIR environment variable to point to this location, for example:

oracle@dbvlin103[/home/oracle/10.0/dbvisit/installer]: mkdir /home/oracle/tmp
oracle@dbvlin103[/home/oracle/10.0/dbvisit/installer]: export TMPDIR=/home/oracle/tmp
oracle@dbvlin103[/home/oracle/10.0/dbvisit/installer]: ./install-dbvisit
...

 If using TMPDIR option you will need to make sure you update the .bash_profile or.profile or other environment configuration files to ensure that this path is set before you execute Dbvisit Standby processes.



2.2.  Primary Server Requirements

When looking at installing the Dbvisit Standby product, you need to make sure that the required supported Oracle Database software is already installed and configured with a primary database running (started in an open read/write mode).

No outage is required for the installation of Dbvisit Standby.

It is however required that the primary database is in "archivelog" mode. If not you will need to enable this first - which will require an outage - as a restart of the database is required to enable this option.

For Oracle RAC environments, all the RAC instances must be running during the initial Dbvisit Standby installation and configuration.

Below are a few key points to take into account with regards to the Primary Server configuration:

  • It is recommended that the database is listed in the /etc/oratab file if using UNIX installations.
  • When using Windows-based installations, the Primary Database will be listed in the registry is created using the DBCA (Oracle Database Configuration Assistant).  If the database was created manually with scripts, it might not be listed in the registry and will have to be manually added in Dbvisit Standby's configuration - more on this in the Creation of the Dbvisit Standby configuration file (DDC file).
  • Dbvisit Standby does not make use of the Oracle Listener for database connections. All connections to the database are local connections, for example:

    SQL> connect / as sysdba
    Connected.

    The sys database account can also be used by Dbvisit, for example:

    SQL> connect sys/syspassword as sysdba
    Connected.

    If operating system authentication is not allowed and user (sys) authentication is used, the credentials should be specified in the Dbvisit Database Configuration (DDC) file.

    NOTE: In case of either primary or standby databases use ASM storage, the user that installed Dbvisit Standby should be able to connect to the ASM instance as sysdba. 

2.2.1.  Archivelog Mode

To enable the use of a standby database, your primary database must be in archivelog mode.  To determine if the database is in archive log mode run SQL command: "sql> archive log list"

Example:

SQL> archive log list;

 Database log mode Archive Mode
 Automatic archival Enabled
 Archive destination USE_DB_RECOVERY_FILE_DEST
 Oldest online log sequence 21568
 Next log sequence to archive 21571
 Current log sequence 21571


If the database is not in archivelog mode, you can use the following to enable it.  Please note this requires an outage.  Also, make sure you have sufficient space in your fast/flash recovery area:

SQL > connect / as sysdba
SQL > shutdown immediate
SQL > startup mount
SQL > alter database archivelog;
SQL > shutdown immediate;
SQL > startup

For more details on enabling/disabling archivelog mode, please see the Oracle Documentation.

2.3.  Standby Server Requirements

When looking at installing the Dbvisit Standby on the standby server, you need to make sure that the required supported Oracle Database software is already installed and configured. 

Dbvisit Standby can be used to create the standby database for you once it is configured.  But if you already have a standby database in place, you can configure Dbvisit Standby to update and maintain the standby database going forward - there will be no need to recreate this standby database.

Below are a few key points to take into account with regards to the Standby Server configuration:

  • It is recommended that the database is listed in the /etc/oratab file.  If you are looking at creating a new standby database, you may add its detail to the /etc/oratab file prior to using Dbvisit Standby to start the configuration.
  • Dbvisit Standby should be installed as the same user that was used to install the Oracle Database Software.
  • If you are planning on using ASM storage for the standby database and you are using role separation (meaning Oracle Database software is installed as the "oracle" Unix account and the Grid Infrastructure software is installed as the "grid" Unix account) you will need to make sure that the Oracle executable in the Oracle Database software home has the correct permissions. If you do not have the correct permissions you will potentially get ORA-15025 errors, as you will not be able to see the ASM storage when creating a new database manually. For more details see this the Oracle Support note: 1084186.1.  The steps below can be followed to ensure the executable has the correct permission. These steps include running the setasmgidwrap command as the "grid" user:


root@dbvlin101[/u01/app/oracle/product/12.1.0/db_1/bin]: ls -altr oracle
-rwsr-s--x 1 oracle oinstall 282183593 Jul 28 17:49 oracle
root@dbvlin101[/u01/app/oracle/product/12.1.0/db_1/bin]: cd


root@dbvlin101[/root]: su - grid
grid@dbvlin101[/home/grid]: . oraenv
ORACLE_SID = [grid] ? +ASM
The Oracle base remains unchanged with value /u01/app/grid

grid@dbvlin101[/home/grid]: setasmgidwrap o=/u01/app/oracle/product/12.1.0/db_1/bin/oracle
grid@dbvlin101[/home/grid]: cd /u01/app/oracle/product/12.1.0/db_1/bin/


grid@dbvlin101[/home/grid]: ls –al oracle
-rwsr-s--x 1 oracle asmadmin 282183593 Jul 28 17:49 oracle

2.4.  Central Console Requirements 

In Dbvisit Standby version 10 the Web-Based Interface (GUI) is designed to manage multiple standby database configurations from one central location.

It is recommended that the Central Console be installed on a standalone server - ideally running Oracle Linux version 6 or higher.  This can either be a physical server, Virtual Machine or even a Docker image (as long as persistent storage is used for the configuration folder).  

The key requirements for the system running the central console are:

  1. The system must be able to access all the servers that will take part in the Dbvisit Standby configuration (Primary and Standby servers)
  2. The default port 4433 will be used and must be allowed / accessible between all the systems.
  3. The Central Console will be accessing/managing the remote hosts (primary or standby servers) via the Dbvisit Agent which will be running on Port 7891 by default.
  4. Using the default recommended ports are recommended.
  5. The default protocol used by the Web Server is HTTPS and cannot be modified to HTTP.
  6. The recommended browsers for use with the Central Console are:
    1. Firefox
    2. Chrome
    3. Safari 
  7. If configuring dbvserver on a Windows standalone server, the user account that will be used for installation must be granted a "Log on as a Service" permission and is a part of the Local Administrators group.

The latest versions of the browsers are recommended.

Please note that local virus software, security policies and configurations may interfere with the web-based interface - it is recommended that you review your settings if the central console is not displaying correctly.

Dbvisit Standby central console is tested with the latest base releases of the above browsers without any special add-ons or virus software configurations or security policies applied.

2.4.1.  Recommended Operating System Packages

Before installing the Dbvisit Standby central console it is recommended that the following operating system packages (if using Linux) are installed prior to installing Dbvisit Standby version 10 Dbvserver component:

  • glibc 
  • zlib
  • libaio

2.5.  E-Mail Notifications

Dbvisit Standby version 10 have E-Mail notifications turned off by default.  (SEND_MAIL_FLAG=N and SEND_MAIL_FLAG_DR=N)

Enabling email can easily be done.  For more detail please see the E-Mail Notification Configuration.




2.6.  Windows Environment Pre-requisites

If installing Dbvisit Standby onto a Windows Based environment (Microsoft Windows 2008 and above - 64bit) the following pre-requisite checks should be performed:

  • The user installing Dbvisit Standby may be a Local or a Domain user.
  • The user must be part of the following Local Groups
    • Local Administrators
    • ORA_DBA
    • Users
    • If using Oracle 12c - Oracle Home DBA group 
  • It is recommended that User Account Control be turned off - not strictly required, but highly recommended.
  • The user will be granted the "Log On As Service" policy to allow the user to run the Dbvisit Standby Services
  • When the Installer asks for the user that will be running the Dbvisit Services (Dbvnet, Dbvserver and Dbvagent) it is important that this user is in the Local Administrators and ORA_DBA Groups.  
    • If you are using Oracle 12c and during the Oracle Software installation you selected the option for Oracle to create a local account to own the Oracle Home and run the services - do not specify this user as the user to run the Dbvisit Standby services.  Rather create a new local account with the above-mentioned permission and use it to then run Dbvisit Standby services.
  • When using temporary backup directories (example d:\temp) during the Create Standby Database (CSD) or Synchronize Standby Database (SYNC) options, you need to make sure that these directories allow for FULL read/write permission for the user running Dbvisit Services as well as for the user that is running the Oracle Database services.  

2.6.1.  Log on as a Service  

Important - when you install Dbvisit Standby and you specify the Windows user and password that will be used to run the Dbvisit Services, this user must have "Log on as a service" permission.  Otherwise, you might end up with an error message "specify valid username and password".   You can double check the permission as follow:

2.6.2.  Directory Permissions

It is important to make sure that the directories used to store temporary backups - an example where the backups are stored during Create Standby Database (CSD) and Synchronise Standby Database (SYNC) have the Windows Oracle Homeowner added to have full read/write permission.

This also counts for the ARCHSOURCE and ARCHDEST locations.  If these directories do not have correct permission, the CSD, SYNC or Graceful Switchover processes could fail with errors similar to:

Below is an extract from a trace file indicating the permission on the TEMP folder was not correct - the Oracle 12c Database Home Owner on Windows which in this example was the "oracle" user did not have sufficient permission on the temporary backup folder which was C:\Temp in this case. 

20170116 18:43:54 main::cmn_cat: RMAN-00571: ===========================================================
20170116 18:43:54 main::cmn_cat: RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
20170116 18:43:54 main::cmn_cat: RMAN-00571: ===========================================================
20170116 18:43:54 main::cmn_cat: RMAN-03002: failure of restore command at 01/16/2017 18:43:54
20170116 18:43:54 main::cmn_cat: ORA-19963: error getting logical block size of file C:\TEMP\DBV_DEV_CSD_STDBY.CTL
20170116 18:43:54 main::cmn_cat: ORA-27041: unable to open file
20170116 18:43:54 main::cmn_cat: OSD-04002: unable to open file
20170116 18:43:54 main::cmn_cat: O/S-Error: (OS 5) Access is denied.



3.  Installing Dbvisit Standby Core Components - Unix

When Installing Dbvisit Standby version 10, using the default location is recommended:  /usr/dbvisit.  You can however still install version 10 into any other custom location, example /usr/dbvisit10.  

It is recommended not to install Dbvisit Standby in the home directory of the Oracle Unix account (/home/oracle).

3.1.  The Dbvisit Standby Repository Overview

As with previous versions of Dbvisit Standby, version 10 makes use of a repository to store some key information.  Making changes to this repository is not supported unless instructed by the Dbvisit Support Team.

Note: From version 8, Dbvisit Standby does not store the repository inside the Oracle database - as was done in previous versions.  

In version 10 the repository is stored in an SQLite database which is created as part of the Dbvisit Standby Configuration (DDC) file creation and is located in the DBVISIT_BASE/standby/conf directory.  The file will take the format of DB_NAME.db.  If you have multiple standby databases, there will only be one repository per primary database.  

It is possible to install a Dbvisit Standby version 10 into a new base directory, create a new DDC file and repository and once everything is up and running, disable and remove the older version.  

3.2.  Installation Steps (non-RAC configurations)

You can follow these basic steps discussed in this section to install Dbvisit Standby version 10.  This section covers the installation of Dbvisit Standby on a Non-RAC environment (Single Instance configuration).

The Dbvisit Standby version 10 installation uses approximately 200MB of disk space, but as trace files and log files will be stored in this location, 512MB free space is the recommended minimum.  

In version 10 the default installation location is /usr/dbvisit, it is also known and referred to as the Dbvisit Base (DBVISIT_BASE) directory.

Step 1:  Create a "Dbvisit Base" Directory

The first step is to create the Dbvisit Base directory.  This is the directory into which Dbvisit Standby will be installed into.  The default location is /usr/dbvisit

This directory should be owned by the Oracle Database software owner.  

The following steps can be executed as the "root" user to create the directory and set correct permission:

oracle@dbvlin101[/root]:# cd /usr
oracle@dbvlin101[/usr]# mkdir dbvisit
oracle@dbvlin101[/usr]# chown -R oracle:oinstall dbvisit
oracle@dbvlin101[/usr]# ls -ald /usr/dbvisit
drwxr-xr-x 2 oracle oinstall 6 Jun 24 11:46 /usr/dbvisit
 

Step 2:  Download Latest Software

The first step is to download the latest available version from the Dbvisit web site http://www.dbvisit.com 


Note - if you are part of the Beta program, the software will be supplied to you via a different method.


Once the software is downloaded, you can copy it to a temporary location on your server.  

Important:

  • Do not install Dbvisit Standby as the Unix "root" user.  
  • When you download the installer, please make sure you download it into a temporary folder and that the installer is run from there.  Do not extract and run the installer from the location where you want the files to be installed.


In this example, we create a temporary directory called 10.0 in /home/oracle and copy the software download into this directory. 

[oracle@dbvel71 ~]$ mkdir 10.0
[oracle@dbvel71 ~]$ cd 10.0/
[oracle@dbvel71 10.0]$ pwd
/home/oracle/10.0


Now copy the installer file into the /home/oracle/10.0 location and continue with the steps below.


We now have the following structure:

[oracle@dbvel71 10.0]$ ls -al *.zip
-rw-r--r--. 1 oracle oinstall 167040960 Nov 25 18:07 dbvisit-standby-10.0.0RC_15_g81628a5f-el6.zip
[oracle@dbvel71 10.0]$
 

Step 3:  Extract Software Install Package

The next step is to extract the software downloaded in the previous step as well as updating the install-dbvisit file permission to allow the execution option.

First use "unzip" to uncompress the downloaded software package, followed by using the "tar -xf" command to extract the archive. The steps are shown below:


[oracle@dbvel71 10.0]$ unzip dbvisit-standby-10.0.0RC_15_g81628a5f-el6.zip
Archive:  dbvisit-standby-10.0.0RC_15_g81628a5f-el6.zip
  inflating: dbvisit-standby-10.0.0RC_15_g81628a5f-el6.tar
[oracle@dbvel71 10.0]$ ls -al
total 627428
drwxr-xr-x.  2 oracle oinstall      4096 Nov 25 18:07 .
drwx------. 10 oracle oinstall      4096 Nov 25 18:04 ..
-rw-r--r--.  1 oracle oinstall 475432960 Nov 17 18:55 dbvisit-standby-10.0.0RC_15_g81628a5f-el6.tar
-rw-r--r--.  1 oracle oinstall 167040960 Nov 25 18:07 dbvisit-standby-10.0.0RC_15_g81628a5f-el6.zip
[oracle@dbvel71 10.0]$ tar -xf dbvisit-standby-10.0.0RC_15_g81628a5f-el6.tar
[oracle@dbvel71 10.0]$ ls -al
total 627520
drwxr-xr-x.  3 oracle oinstall      4096 Nov 25 18:07 .
drwx------. 10 oracle oinstall      4096 Nov 25 18:04 ..
drwxr-xr-x.  9 oracle oinstall      4096 Nov 17 18:50 dbvisit
-rw-r--r--.  1 oracle oinstall 475432960 Nov 17 18:55 dbvisit-standby-10.0.0RC_15_g81628a5f-el6.tar
-rw-r--r--.  1 oracle oinstall 167040960 Nov 25 18:07 dbvisit-standby-10.0.0RC_15_g81628a5f-el6.zip
-rw-r--r--.  1 oracle oinstall      4877 Nov 17 18:50 INSTALL.txt
-rw-r--r--.  1 oracle oinstall     78963 Nov 17 18:50 README.txt
[oracle@dbvel71 10.0]$
 

Step 4:  Start The Dbvisit Installer

The next step in the process is to start the Dbvisit Standby installer.  Once you have extracted the tar archive, you will notice a new "dbvisit" directory.

In this directory, you will find an "installer" directory which contains the installation script to be executed.

[oracle@dbvel71 10.0]$ cd dbvisit
[oracle@dbvel71 dbvisit]$ ls -lrt
total 4
drwxr-xr-x.  2 oracle oinstall    6 Nov 17 18:50 doc
drwxr-xr-x.  3 oracle oinstall   40 Nov 17 18:55 installer
drwxr-xr-x.  5 oracle oinstall   54 Nov 17 18:55 dbvnet
drwxr-xr-x.  5 oracle oinstall   59 Nov 17 18:55 observer
drwxr-xr-x.  6 oracle oinstall   68 Nov 17 18:55 dbvserver
drwxr-xr-x.  6 oracle oinstall   67 Nov 17 18:55 dbvagent
drwxr-xr-x. 14 oracle oinstall 4096 Nov 17 18:55 standby
[oracle@dbvel71 dbvisit]$ cd installer/
[oracle@dbvel71 installer]$ ls -lrt
total 5676
drwxr-xr-x. 2 oracle oinstall      25 Nov 17 18:50 doc
-rwxr-xr-x. 1 oracle oinstall 5808230 Nov 17 18:55 install-dbvisit
[oracle@dbvel71 installer]$

To preview the full help of the installer and the arguments (parameters) that can be passed for automated installations - run ./install-dbvisit -h 

[oracle@dbvel71 installer]$ ./install-dbvisit -h


>>> Installs Dbvisit products and components.

        Option to install product with all default values accepted:

            --batch-install

        Force option to reconfigure components and recreate configuration files:

            --force

        Available options and default values for batch installation:

            Installation directory? (default: /usr/dbvisit)
                --dbvisit-base /usr/dbvisit

            Components to install? (default: core)
                --components standby,dbvnet,dbvagent,dbvserver|all|core

            Oracle Instant Client Version? (default: 12.2)
                --instant-client-version 12.1|12.2

            Local server to run Dbvnet? (default OS hostname)
                --dbvnet-local-host dbvlin1

            Dbvnet listening port number on local server? (default: 7890):
                --dbvnet-local-port 7890

            Dbvnet passphrase to encrypt network data transfers? (mandatory):
                --dbvnet-passphrase abcdef

            Dbvnet debug level? (default: 3):
                --devnet-debug 3

            Local server to run Dbvagent? (default OS hostname)
                --dbvagent-local-host dbvlin1

            Dbvagent listening port number on local server? (default: 7891):
                --dbvagent-local-port 7891

            Dbvagent passphrase to encrypt network data transfers? (mandatory):
                --dbvagent-passphrase abcdef

            If Dbvserver is behind a firewall set to external (firewall) address (optional):
                --dbvagent-webserver-host <address>
                --dbvagent-webserver-port <port#>

            Dbvagent debug level? (default: 3):
                --devagent-debug 3

            Local server to run Dbvserver? (default OS hostname)
                --dbvserver-local-host dbvlin1

            Dbvserver listening port number on local server? (default: 4433):
                --dbvserver-local-port 4433

            Server used for Dbvserver public interface? (default: dbvserver-local-host)
                --dbvserver-public-host dbvlin1

            Port used for Dbvserver public interface? (default: dbvserver-local-port)
                --dbvserver-public-port 4433

            Dbvserver debug level? (default: 3):
                --devserver-debug 3

*** Exit code -1
[oracle@dbvel71 installer]$

Note - the dbvisit-install script must have the execute permission for the Oracle Unix software owner - which in this example is the "oracle" Unix account.


Below is the detailed output of the installation process.  

In summary, the following are performed:

  1. Start the installer using -./install-dbvisit command
  2. Provide the DBVISIT_BASE directory - /usr/dbvisit (default)
    1. This location is important when upgrading an existing installation (discussed in the next section) - if upgrading a version 8 or 9 installations make sure you select the same base folder into which Dbvisit Standby version is installed, example if it was installed in /usr/dbvisit and you want to upgrade it - make sure to select /usr/dbvisit here.  
    2. It is possible to install into any new Dbvisit Base location, but the recommended default value of /usr/dbvisit is recommended.
    3. Note - Do not attempt to upgrade version 5, 6 or 7 installations - you must first upgrade them to version 8 before you can update to version 10 - or the recommended method, in this case, is to perform a clean new installation.
  3. Once the Dbvisit Base location is provided, the installer will review the currently installed software versions - if already installed.  A summary screen is displayed showing if any current version is already installed in this base location and if so what the version number is.  For new installations such as the example below, the Installed version will show "not installed"
    1. The first menu is displayed provides 3 options - Install, Uninstall and Terminate.  Enter "1" to start the installation process.
    2. The second option would be asked for Oracle instant client libraries if you are not sure please leave it to default 12.2 (The older 12.1 is used for older versions of Oracle databases like 11g or 10g).
    3. The second menu is now displayed with 6 options.  The default is to select option 1 which will install the Dbvisit Standby Core components which include - Dbvisit Standby CLI, Dbvnet and the Dbvagent.  This is the recommended option to select.  
    4. Note - if you are looking at using the Dbvserver (Web Based) user interface it is recommended that you install this as a separate component on its own server.  It is, however, possible to install it on the same location as the other components, but please note that as of version 8 the web-based interface is considered a central console to manage multiple Dbvisit Standby configurations and having it installed on any of the Database servers where Dbvisit Standby is configured is not recommended.  This is due to the fact that in case of a disaster this system might be usable - which means you web-based front-end is not available.  Therefore having it installed on a separate configuration (host) is recommended.
    5. In the example below only the 3 core components are installed.  The next section will cover the installation of the Web-Based interface (GUI - Dbvserver).
  4. Once option 1 is selected the installation will continue to the next step
  5. Dbvnet is configured first and the following information is required:
    1. The localhost where you are currently installing - hostname should be provided, this could be a hostname alias, but it must be able to resolve to an IP address located on the local server
    2. The local dbvnet port - The default recommended value is 7890 
    3. The last question is for a passphrase.  This is an Alphanumeric string which will be used to secure connections (encrypt) between the Dbvnet components (servers)
      1. The passphrase used must be the same on all Dbvnet installations that will be communicating.
  6. The next set of questions related to the Dbvagent.
    1. This is the component that will allow the Web-Based Interface (GUI) or also known as Dbvserver to interact with the Dbvisit Standby Core API.  Each host that will be running Dbvisit Standby must have the dbvagent installed.  The installer will ask for the following:
      1. The agent hostname:  this is the local hostname which can be a host alias that resolves to a local IP address on the server.
      2. The agent port: This is the port on which the agent will listen for secure connections from the web-based interface.  The default and recommended value is 7891
      3. The agent passphrase:  The passphrase to be used for the agent is Alphanumeric and will be used by the GUI to establish a secure connection to the agent.
      4. Webserver hostname: This is an optional parameter to specify the IPv4 address or hostname to be used for the Dbvserver Return Address. If unsure, please accept the default value, which is blank.
      5. Webserver port: This is an optional parameter to specify the port number to be used as the Dbvserver Return Port. If unsure, please accept the default value, which is blank.
  7. Once all values are provided the installation will continue.
    1. If you have version 7 installed, the old executables will be replaced (removed) once the new ones are installed.
    2. A log file of the installation is created and may be requested by support if required.

In most cases just accepting the default values are recommended

Step 4.1.  Example Installation 

Below is an example installation process.  

[oracle@dbvel71 installer]$ pwd
/home/oracle/10.0/dbvisit/installer
[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/10.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        10.0.0RC_15_g81628a5f                             not installed
    dbvnet         10.0.0RC_15_g81628a5f (dbvnet v1.5.0-301-g3896e54)not installed
    dbvagent       10.0.0RC_15_g81628a5f                             not installed
    dbvserver      10.0.0RC_15_g81628a5f                             not installed
    observer       10.0.0RC_15_g81628a5f                             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 - Dbvisit Observer (Automatic Failover Option) - Not available on Solaris/AIX
    Press ENTER to exit Installer

    Your choice: 1

>>> Please specify the Oracle Instant Client version.

    The Oracle Instant Client is a required library for Dbvisit products.
    You may choose 12.1 or 12.2, however the default version is 12.2.

    Enter a custom value or press ENTER to accept default [12.2]:
     >

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

    Press ENTER to continue

-----------------------------------------------------------
    About to configure DBVISIT DBVNET
-----------------------------------------------------------

>>> Please specify the Local host name to be used by Dbvnet on this server.

    Dbvnet will be listening on the local IP Address on this server which
    resolve to the host name specified here.
    If using a cluster or virtual IP make sure the host name or alias
    specified here resolve to the IP address local to where dbvnet is
    installed.  The host name should resolve to IPv4 address, if not
    you can use an IPv4 IP address instead of host name.

    Enter a custom value or press ENTER to accept default [dbvel71]:
     >

>>> Please specify the Local Dbvnet PORT to be used.

    Dbvnet will be listening on the specified port for incoming connections
    from remote dbvnet connections.  Please make sure that this port is not
    already in use or blocked by any firewall.  You may choose any value
    between 1024 and 65535, however the default of 7890 is recommended.

    Enter a custom value or press ENTER to accept default [7890]:
     >


>>> Please specify the Dbvnet Passphrase to be used for secure connections.

    The passphrase provided must be the same in both the local and remote
    Dbvnet installations.  It is used to establish a secure (encrypted)
    Dbvnet connections

    Enter a custom value:
     > demo123

-----------------------------------------------------------
    Summary of the Dbvisit DBVNET configuration
-----------------------------------------------------------
    DBVISIT_BASE /usr/dbvisit
    DBVNET_LOCAL_HOST dbvel71
    DBVNET_LOCAL_PORT 7890
    DBVNET_PASSPHRASE demo123

    Press ENTER to continue

-----------------------------------------------------------
    About to configure DBVISIT DBVAGENT
-----------------------------------------------------------


>>> Please specify the IPv4 address or host name to be used for the Dbvisit Agent.

    The Dbvisit Agent (Dbvagent) will be listening on this local address.
    Connections from Dbvserver (GUI) will be established to this Dbvagent,
    thus the address must be visible from the Dbvserver location.
    If using a cluster or virtual IP, make sure the host name or alias
    specified here resolves to the IP address local to where the Dbvagent
    is installed.
    The host name should resolve to an IPv4 address, otherwise you can use
    an IPv4 IP address instead of a host name.

    Enter a custom value or press ENTER to accept default [dbvel71]:
     >


>>> Please specify the listening PORT number for Dbvagent.

    The Dbvisit Agent (Dbvagent) will be listening on the specified port for
    incoming requests from Dbvserver (GUI). Please make sure that this
    port is not already in use, and is not blocked by any firewall. You may choose
    any value between 1024 and 65535, however the default of 7891 is recommended.

    Enter a custom value or press ENTER to accept default [7891]:
     >


>>> Please specify the passphrase for Dbvagent

    Each Dbvisit Agent must have a passphrase specified. Think of this passphrase
    as the password for Dbvserver (GUI) to access each Dbvagent securely.
    The passphrase can be unique to each Dbvagent. It will be used to establish a
    secure connection between Dbvserver and the Dbvisit Agent.

    Enter a custom value:
     > demo123


>>> Please specify the IPv4 address or host name to be used for the
      Dbvserver Return Address (OPTIONAL)

    This is an advanced, and OPTIONAL parameter. If unsure, please accept
    the default value, which is blank.

    If necessary, you can use this parameter to specify a fixed IPv4 address
    for the Dbvisit Dbvserver (GUI). In the overwhelming majority of cases,
    our software will handle this for you automatically, and setting
    this parameter should NOT be necessary.

    If, however, your Dbvserver's externally-visible address differs from
    the locally-resolved address, you can specify it here. The most common
    scenario where this can happen is if you have address forwarding set up
    on a cloud-deployed environment. If set, Dbvagent will use this address
    instead of any other to connect to Dbvserver.

    Enter a custom value or press ENTER to accept default [ ]:
     >


>>> Please specify the port number to be used as the
      Dbvserver Return Port (OPTIONAL)

    This is an advanced, and OPTIONAL parameter.

    This is the port value to match the OPTIONAL Dbvserver Return Address
    parameter immediately above. If unsure, please accept the default value,
    which is blank.

    Enter a custom value or press ENTER to accept default [ ]:
     >

-----------------------------------------------------------
    Summary of the Dbvisit DBVAGENT configuration
-----------------------------------------------------------
    DBVISIT_BASE /usr/dbvisit
    DBVAGENT_LOCAL_HOST dbvel71
    DBVAGENT_LOCAL_PORT 7891
    DBVAGENT_PASSPHRASE demo123
    DBVAGENT_WEBSERVER_HOST
    DBVAGENT_WEBSERVER_PORT

    Press ENTER to continue

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

-----------------------------------------------------------
    About to install Dbvisit DBVNET
-----------------------------------------------------------
    Component dbvnet installed.

-----------------------------------------------------------
    About to install Dbvisit DBVAGENT
-----------------------------------------------------------
    Component dbvagent installed.

    -----------------------------------------------------------
    Component      Installer Version   Installed Version
    -----------------------------------------------------------
    standby        10.0.0RC_15_g81628a5f                             10.0.0RC_15_g81628a5f
    dbvnet         10.0.0RC_15_g81628a5f (dbvnet v1.5.0-301-g3896e54)10.0.0RC_15_g81628a5f (dbvnet v1.5.0-301-g3896e54)
    dbvagent       10.0.0RC_15_g81628a5f                             10.0.0RC_15_g81628a5f
    dbvserver      10.0.0RC_15_g81628a5f                             not installed
    observer       10.0.0RC_15_g81628a5f                             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.202011251832.
[oracle@dbvel71 installer]$

3.3.  Starting Standby Core Components (Dbvagent and Dbvnet) 

Following the installation of Dbvisit Standby Core components (dbvnet, dbvagent and the standby core - command line interface), you need to start the two components:  Dbvnet and Dbvagent.  

This can easily be done by running the following commands:

  • For Dbvnet: ./dbvnet -d start from the DBVISIT_BASE/dbvnet directory.  
  • For Dbvagent:  ./dbvagent -d start from the DBVISIT_BASE/dbvagent directory.  

Once the command is executed, you can use the "ps -ef|egrep 'dbvagent|dbvnet' | grep -v grep" command to show the process running.

Example - Starting Dbvnet:

[oracle@dbvel71 installer]$ cd /usr/dbvisit/
[oracle@dbvel71 dbvisit]$ cd dbvnet/
[oracle@dbvel71 dbvnet]$ ls
conf  dbvnet  doc  log
[oracle@dbvel71 dbvnet]$ ./dbvnet -d start
Dbvnet daemon started with pid 6503.
[oracle@dbvel71 dbvnet]$ ps -ef |grep dbvnet|grep -v grep
oracle    6503     1  0 18:36 ?        00:00:00 ./dbvnet -d start
[oracle@dbvel71 dbvnet]$

Example - Starting Dbvagent:

[oracle@dbvel71 dbvisit]$ cd dbvagent/
[oracle@dbvel71 dbvagent]$ ls
conf  dbvagent  doc  log  tmp
[oracle@dbvel71 dbvagent]$ ./dbvagent -d start
Dbvagent daemon started.
[oracle@dbvel71 dbvagent]$ ps -ef |grep dbvagent|grep -v grep
oracle    6600     1  0 18:38 ?        00:00:00 ./dbvagent -d start
[oracle@dbvel71 dbvagent]$

3.4.  Stopping Standby Core Components (Dbvagent and Dbvnet) 

Stopping the core components Dbvnet and Dbvagent can easily be done by running the following commands:

  • For Dbvagent:  ./dbvagent -d stop from the DBVISIT_BASE/dbvagent directory.  
  • For Dbvnet: ./dbvnet -d stop from the DBVISIT_BASE/dbvnet directory.  

Once the command is executed, you can use the "ps -ef|egrep 'dbvagent|dbvnet' | grep -v grep" command to show the process running.


Example - Stopping Dbvagent:

[oracle@dbvel71 dbvisit]$ cd dbvagent/
[oracle@dbvel71 dbvagent]$ ls
conf  dbvagent  doc  log  tmp
[oracle@dbvel71 dbvagent]$ ./dbvagent -d stop
Stop signal has been sent to pid: 6600
[oracle@dbvel71 dbvagent]$ ps -ef |grep dbvagent |grep -v grep
[oracle@dbvel71 dbvagent]$


Example - Stopping Dbvnet:

[oracle@dbvel71 dbvisit]$ cd dbvnet/
[oracle@dbvel71 dbvnet]$ ls
conf  dbvnet  doc  log
[oracle@dbvel71 dbvnet]$ ./dbvnet -d stop
Stop signal has been sent to pid: 6503
[oracle@dbvel71 dbvnet]$ ps -ef |grep dbvnet |grep -v grep
[oracle@dbvel71 dbvnet]$

4.  Installing Dbvisit Standby Central Console (Dbvserver) and Observer (Automatic Failover component)

This section will cover the installation process for the Dbvisit Standby Central Console (Dbvserver) or web-based user interface - also referred to as the Graphical User Interface (GUI).

From Dbvisit Standby version 9 it is recommended that the GUI be installed on its own server - Oracle Linux 6 or 7 is recommended.  

Important

The Dbvisit Standby version Central Console will not be able to manage Dbvisit Standby version 6,7, 8 or 9 configurations. Only version 10.0.x is supported.

4.1.  Examples

4.1.1.  Installing Dbvserver (GUI)

Make sure that the glibc and libaio packages are installed on the Linux system - for more detail see the pre-requisite checks.

The example below will show the installation of the Dbvserver (Dbvisit Standby version 10.0.x Web-Based Interface) onto a standalone system.  

No other Dbvisit Standby components need to be installed on this system - only the Dbvserver component.

During the installation 4 key questions are asked:

  1. The Dbvisit Base (DBVISIT_BASE) or default location for the installation is required - the default value of /usr/dbvisit is recommended
  2. The next menu option will ask which options you want to install, select "5" to install Dbvserver 
  3. You will be asked for the server name to use (the default value provided should be sufficient unless you use multiple network interfaces and want to specify a specific alias - note it must be in the /etc/hosts file - Note: do not specify IP address but a hostname or alias.
  4. The default Port for Dbvserver to run on  - the default is HTTPS on port 4433 (using the default is recommended)
  5. Once the installation is completed, you can choose the option "6" for installing Observer component. There are no user inputs needed for observer installation.


The example below highlight the steps for installing Dbvisit Standby version 10 central console:


[oracle@dbvel72 10.0]$ ls -la
total 163132
drwxr-xr-x.  2 oracle oinstall        59 Nov 25 18:42 .
drwx------. 11 oracle oinstall      4096 Nov 25 18:41 ..
-rw-r--r--.  1 oracle oinstall 167040960 Nov 25 18:42 dbvisit-standby-10.0.0RC_15_g81628a5f-el6.zip
[oracle@dbvel72 10.0]$ unzip dbvisit-standby-10.0.0RC_15_g81628a5f-el6.zip
Archive:  dbvisit-standby-10.0.0RC_15_g81628a5f-el6.zip
  inflating: dbvisit-standby-10.0.0RC_15_g81628a5f-el6.tar
[oracle@dbvel72 10.0]$ tar -xf dbvisit-standby-10.0.0RC_15_g81628a5f-el6.tar
[oracle@dbvel72 10.0]$ ls -la
total 627520
drwxr-xr-x.  3 oracle oinstall      4096 Nov 25 18:42 .
drwx------. 11 oracle oinstall      4096 Nov 25 18:41 ..
drwxr-xr-x.  9 oracle oinstall      4096 Nov 17 18:50 dbvisit
-rw-r--r--.  1 oracle oinstall 475432960 Nov 17 18:55 dbvisit-standby-10.0.0RC_15_g81628a5f-el6.tar
-rw-r--r--.  1 oracle oinstall 167040960 Nov 25 18:42 dbvisit-standby-10.0.0RC_15_g81628a5f-el6.zip
-rw-r--r--.  1 oracle oinstall      4877 Nov 17 18:50 INSTALL.txt
-rw-r--r--.  1 oracle oinstall     78963 Nov 17 18:50 README.txt
[oracle@dbvel72 10.0]$ cd dbvisit
[oracle@dbvel72 dbvisit]$ ls -la
total 12
drwxr-xr-x.  9 oracle oinstall 4096 Nov 17 18:50 .
drwxr-xr-x.  3 oracle oinstall 4096 Nov 25 18:42 ..
drwxr-xr-x.  6 oracle oinstall   67 Nov 17 18:55 dbvagent
drwxr-xr-x.  5 oracle oinstall   54 Nov 17 18:55 dbvnet
drwxr-xr-x.  6 oracle oinstall   68 Nov 17 18:55 dbvserver
drwxr-xr-x.  2 oracle oinstall    6 Nov 17 18:50 doc
drwxr-xr-x.  3 oracle oinstall   40 Nov 17 18:55 installer
drwxr-xr-x.  5 oracle oinstall   59 Nov 17 18:55 observer
drwxr-xr-x. 14 oracle oinstall 4096 Nov 17 18:55 standby
[oracle@dbvel72 dbvisit]$ cd installer/
[oracle@dbvel72 installer]$ ls
doc  install-dbvisit

[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/10.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        10.0.0RC_15_g81628a5f                             not installed
    dbvnet         10.0.0RC_15_g81628a5f (dbvnet v1.5.0-301-g3896e54)not installed
    dbvagent       10.0.0RC_15_g81628a5f                             not installed
    dbvserver      10.0.0RC_15_g81628a5f                             not installed
    observer       10.0.0RC_15_g81628a5f                             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 - Dbvisit Observer (Automatic Failover Option) - Not available on Solaris/AIX
    Press ENTER to exit Installer

    Your choice: 5

-----------------------------------------------------------
    About to configure DBVISIT DBVSERVER
-----------------------------------------------------------


>>> Please specify the IPv4 address to be used for Dbvserver

    The Dbvisit Web Server (Dbvserver) will be listening on this local
    address. If using a cluster or virtual IP, make sure that the host name
    or alias specified here resolve to the IP address local to where Dbvserver
    is installed.

    It is recommended that you set this parameter to an IP address,
    as opposed to a host name.

    If you are unsure about the remote host name during installation, use
    the default value, which will be the current local hostname.

    Enter a custom value or press ENTER to accept default [dbvel72]:
     > 192.168.56.10


>>> Please specify the listening port number for Dbvserver on the local server

    You may choose any value between 1024 and 65535.  The default recommended
    value is 4433.

    Note: if you can not access this port after the installation has
    finished, then please double-check your server firewall settings
    to ensure the selected port is open.
    Enter a custom value or press ENTER to accept default [4433]:
     >


>>> Please specify the IPv4 address to be used for the Dbvserver public interface

    The public interface address will be used by Dbvagents
    for sending back information, e.g. Task progress.
    This should be set to the externally-visible IP address of the local host.

    Enter a custom value or press ENTER to accept default [192.168.56.10]:
     >


>>> Please specify a publicly-available port number for Dbvserver.
    Like the Public Address setting previously, this port should be remotely accessible,
    and can potentially be different from the Dbvserver Listening Port, especially
    if your server is behind a DMZ. If you are unsure of the correct value for this parameter,
    it is usually fine to leave it the same as the Listener Port setting.

    You may choose any value between 1024 and 65535.  The default recommended
    value is 4433.

    Note: if you can not access this port after the installation has
    finished, then please double-check your server firewall settings
    to ensure the selected port is open.

    Enter a custom value or press ENTER to accept default [4433]:
     >

-----------------------------------------------------------
    Summary of the Dbvisit DBVSERVER configuration
-----------------------------------------------------------
    DBVISIT_BASE /usr/dbvisit
    DBVSERVER_LOCAL_HOST 192.168.56.10
    DBVSERVER_LOCAL_PORT 4433
    DBVSERVER_PUBLIC_HOST 192.168.56.10
    DBVSERVER_PUBLIC_PORT 4433

    Press ENTER to continue

-----------------------------------------------------------
    About to install Dbvisit DBVSERVER
-----------------------------------------------------------
    Component dbvserver installed.

    -----------------------------------------------------------
    Component      Installer Version   Installed Version
    -----------------------------------------------------------
    standby        10.0.0RC_15_g81628a5f                             not installed
    dbvnet         10.0.0RC_15_g81628a5f (dbvnet v1.5.0-301-g3896e54)not installed
    dbvagent       10.0.0RC_15_g81628a5f                             not installed
    dbvserver      10.0.0RC_15_g81628a5f                             10.0.0RC_15_g81628a5f
    observer       10.0.0RC_15_g81628a5f                             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 - Dbvisit Observer (Automatic Failover Option) - Not available on Solaris/AIX
    Press ENTER to exit Installer

    Your choice: 6

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

    Press ENTER to continue

-----------------------------------------------------------
    About to install Dbvisit OBSERVER
-----------------------------------------------------------
    Component observer installed.

    -----------------------------------------------------------
    Component      Installer Version   Installed Version
    -----------------------------------------------------------
    standby        10.0.0RC_15_g81628a5f                             not installed
    dbvnet         10.0.0RC_15_g81628a5f (dbvnet v1.5.0-301-g3896e54)not installed
    dbvagent       10.0.0RC_15_g81628a5f                             not installed
    dbvserver      10.0.0RC_15_g81628a5f                             10.0.0RC_15_g81628a5f
    observer       10.0.0RC_15_g81628a5f                             10.0.0RC_15_g81628a5f

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

    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.202011251844.


Once Dbvserver (The Central Console) is installed you will have the following directory structure in the /usr/dbvisit directory (the example below is using the Unix "tree" command to show the directory structure and files):


[oracle@dbvel72 installer]$ cd /usr/dbvisit/
[oracle@dbvel72 dbvisit]$ cd dbvserver/
[oracle@dbvel72 dbvserver]$ tree .
.
├── conf
│   ├── ca.pem
│   ├── cert.pem
│   ├── dbvserver.conf
│   ├── dbvserver.db
│   ├── dbvserver.db.20201117185529
│   ├── dbvserver-stat.db
│   ├── dbvserver-stat.db.20201117185529
│   └── prikey.pem
├── dbvserver
├── doc
│   ├── README.CONFIG.txt
│   └── README.txt
├── log
└── www

4 directories, 11 files

[oracle@dbvel72 dbvserver]$ cd ../observer/
[oracle@dbvel72 observer]$ tree .
.
├── conf
│   ├── observer.conf
│   ├── sample_userscript.bat
│   └── sample_userscript.sh
├── doc
├── log
└── observersvc

3 directories, 4 files
[oracle@dbvel72 observer]$

4.1.2.  Starting Dbvserver and Observer

Following the installation of the Web-Based Interface - Dbvserver, you can start it.  

This can easily be done by running: ./dbvserver -d start from the DBVISIT_BASE/dbvserver directory.  

Once the command is executed, you can use the "ps -ef|grep dbvserver|grep -v grep" command to show the process running.

[oracle@dbvel72 ~]$ cd /usr/dbvisit/dbvserver/
[oracle@dbvel72 dbvserver]$ ls
conf  dbvserver  doc  log  www
[oracle@dbvel72 dbvserver]$ ./dbvserver -d start
Dbvserver daemon started.
[oracle@dbvel72 dbvserver]$ ps -ef |grep dbvserver |grep -v grep
oracle    7212     1  0 18:48 ?        00:00:00 ./dbvserver -d start
[oracle@dbvel72 dbvserver]$

[oracle@dbvel72 ~]$ cd /usr/dbvisit/observer/
[oracle@dbvel72 observer]$ ls
conf  doc  log  observersvc
[oracle@dbvel72 observer]$ nohup ./observersvc -f ./conf/observer.conf &
[1] 7270
[oracle@dbvel72 observer]$ nohup: ignoring input and appending output to ‘nohup.out’

[oracle@dbvel72 observer]$ ps -ef |grep observer|grep -v grep
oracle    7270  4604  0 18:49 pts/0    00:00:00 ./observersvc -f ./conf/observer.conf
[oracle@dbvel72 observer]$
 

4.1.3.  Testing Access to the GUI

By default, Dbvserver will be configured to use PORT 4433 using HTTPS.  

Navigate to the login screen using the URL of format https://<your-server-name>:4433. 

In this case, the URL would https://192.168.56.10:4433

It is important to make sure that port 4433 is not blocked by your local firewall

The login screen should now be visible in your browser

The default username is "admin" and the password "admin"  

It is recommended to change this after the first login

Once you have logged in the main Dbvisit Standby version 10 screen will be displayed as seen in the example below:

As you have not configured anything yet, most of the options will be disabled and will appear "greyed out" as seen above.


4.1.4.  Next Steps

To allow you to manage Primary-Standby configurations with the Dbvisit Standby version 10 web-based interface, you must have the Dbvisit Standby version 10 Core options (Dbvnet, Dbvagent and Standby Core) installed on both the primary and standby database servers.

Once they are installed, the Dbvagent must be started which will listen on the default port 7891 for incoming connections from the web-based interface (dbvserver).  

If you have the Dbvisit Agents running on the primary and standby servers, you can navigate to the "Manage Hosts" option in the GUI to add these hosts to the web interface.  Once they are known to the web interface, you will be able to either import, upgrade or create Dbvisit Standby configuration files - DDC files.  Once you have a DDC file registered with the Web interface, you will be allowed to perform other functions such as "Create Standby Database (CSD)".

4.1.5.  Testing Network Connectivity

When installing Dbvisit Standby, it is important that once the installation on the Primary and the Standby servers are complete and all required processes are started (Dbvnet, Dbvagent and Dbvserver) that we then test the network connectivity between the primary and standby.

This process can help confirm that network communication is working before you continue creating DDC files or if upgrading - performing the DDC file upgrade.

The command to test connectivity is: dbvctl -f system_readiness

A series of questions will be asked, for example, the remote server name.  We recommend you run this command on the primary as well as the standby to ensure network connectivity is working prior to continuing with creating or upgrading DDC files. 

Example:

Below is an example using the "system readiness" function:

[oracle@dbvel71 standby]$ ./dbvctl -f system_readiness

Please supply the following information to complete the test.
Default values are in [].

Enter Dbvisit Standby location on local server: [/usr/dbvisit]:
Your input: /usr/dbvisit

Is this correct? <Yes/No> [Yes]:

Enter the name of the remote server: []: dbvel72
Your input: dbvel72

Is this correct? <Yes/No> [Yes]:

Enter Dbvisit Standby location on remote server: [/usr/dbvisit]:
Your input: /usr/dbvisit

Is this correct? <Yes/No> [Yes]:

Enter the name of a file to transfer relative to local install directory
/usr/dbvisit: [standby/doc/README.txt]:
Your input: standby/doc/README.txt

Is this correct? <Yes/No> [Yes]:

Choose copy method:
1)   /usr/dbvisit/dbvnet/dbvnet
2)   /usr/bin/scp
Please enter choice [1] : 1

Is this correct? <Yes/No> [Yes]:

Enter port for method /usr/dbvisit/dbvnet/dbvnet: [7890]:
Your input: 7890

Is this correct? <Yes/No> [Yes]:
-------------------------------------------------------------
Testing the network connection between local server and remote server dbvel72.
-------------------------------------------------------------
Settings
========
Remote server                                          =dbvel72
Dbvisit Standby location on local server               =/usr/dbvisit
Dbvisit Standby location on remote server              =/usr/dbvisit
Test file to copy                                      =/usr/dbvisit/standby/doc/README.txt
Transfer method                                        =/usr/dbvisit/dbvnet/dbvnet
port                                                   =7890
-------------------------------------------------------------
Checking network connection by copying file to remote server dbvel72...
-------------------------------------------------------------
Trace file /usr/dbvisit/standby/trace/7545_dbvctl_f_system_readiness_202011251854.trc

File copied successfully. Network connection between local and dbvel72
correctly configured.

[oracle@dbvel71 standby]$


5.  Installing Dbvisit Standby on Windows

Dbvisit Standby version 10 is fully supported on MS Windows 2008 and above (64bit).  

Before installing the software, please make sure you have reviewed the prerequisite steps in the section Installing Dbvisit Standby#2.5.WindowsEnvironmentPre-requisites discussed earlier in this document.

The steps for Installing Dbvisit Standby version 10 on Windows is easy and no outage is required.

We do recommend that before you install software into a production environment, that you always test it first in your development or test environment to make sure you are familiar with the process and required pre-requisite steps.

In this section, we will now review the installation process.

5.1.  Step 1 - Download the latest version

We recommend that you stay up to date with the latest versions being released.  Updates for Dbvisit Standby software is released on a regular basis to make sure enhancements and fixes are available quickly.

To download the latest version please see the Dbvisit website - www.dbvisit.com 

5.2.  Step 2 - Start the Installer

Before you start the installer it is again important to make sure that the user account you are running the installer as and that will be used to run the Dbvisit Standby software must be in the Local Administrators, Users and ORA_DBA Windows Groups.  Failing to do this can lead to errors during installation.  Disabling User Access Control is also recommended.

We recommend you create a new Local Windows account that have the above-mentioned permissions and that this account is used to run the Dbvisit Standby software (it's Services and Windows Schedules).  

In the example we will discuss below a new Local account called "dbvisit" is created with the relevant groups assigned.  UAC was also disabled.

Before you continue, review the following checklist:

  1. Is the port 4433 open for the Central Console
  2. Is port 7890 used by Dbvnet open and available
  3. Is port 7891 used by the Dbvisit Agent (dbvagent) open and available.

The above ports should be added to the Windows Firewall to allow the Dbvisit Standby components to communicate.  If you have a firewall between your Primary and Standby (DR) datacenter please make sure that these ports can be used - especially the Dbvnet port 7890.

Also, review any AntiVirus software application installed and make sure these do not block the Dbvisit Standby software components.

The recommended method for installing Dbvisit Standby version 10 is to install the core components (Dbvnet, Dbvagent and Dbvisit Standby CLI) on the Database Servers and then install the Central Console (Dbvserver) onto its own small system (Virtual Machine or Physical Hardware or even a Docker container).  This allows you then to manage one or more primary/standby configurations from one central location.  You may however still install the Central Console together with the Core components for small environments. 


Once the installer is launched the following screen will be displayed.  As highlighted, please make sure you have stopped your schedules prior to running the installer.

5.3.  Step 3 - Accept the license agreement


5.4.  Step 4 - Select components to install

In this example, the Dbvisit Standby Core components are selected for installation.

These include: Dbvnet, Dbvagent and Dbvisit Standby CLI

You can install the Central Console (Dbvserver) on this system if required - but it is recommended not to use multiple Central Console installations for the same configuration.

If you do install the Central Console on the Database Server - we recommend you install it onto the Standby Database server.  

This way if the primary server is unavailable during a disaster, you can still access the Central Console from the standby server.


5.5.  Step 5 - Select Dbvisit Base (Installation Destination)

The next step is to select the destination for the Dbvisit Standby installation - also known as the DBVISIT BASE location.

The default location on Windows is C:\Program Files\Dbvisit

From Dbvisit Standby V10 we provide the option of using Oracle 12.2 instant client of Oracle 12.2. If you are not sure please leave it to default. This is useful when you are using an older version of Oracle which is not compatible with the Instant client libraries.


5.6.  Step 6 - Provide the Windows user account

During step 6 you will be requested to provide the Windows user account that will run Dbvisit Standby.

We recommend you create a dedicated local or domain account that has the required permission on the primary and standby servers as mentioned earlier.

This user must have Local Administrator, Users and ORA_DBA group assigned.

If you are using Oracle 12c do not specify the Oracle Home user here, rather use another account that has the correct groups assigned.

The Database Services will still be created to run under the Oracle Home user.


5.7.  Step 7 - Provide the Windows user Password

Please make sure you enter this password correctly.  The value cannot be empty.

If this password is not entered correctly, the Dbvserver, Dbvnet and Dbvagent services will fail to start.


5.8.  Step 8 - A progress indicator 

The installation will now start and should take only a few seconds to a minute to complete.


5.9.  Step 9 - Software installed confirmation

Once all the software is installed, a confirmation window will be displayed.


5.10.  Step 10 - Installer script is executed

The installer script will automatically be executed.  During this process, the configuration files for Dbvnet, Dbvagent and Dbvserver will be reviewed.

If no software has been installed before the installer script will prompt the user for input.  If the installer detects an earlier installation, depending on the version no questions may be asked.

tmp=C:\Users\ADMINI~1\AppData\Local\Temp


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

    Installing dbvnet dbvagent standby...

    Default cert.pem is found, replace certificates with new files
    New cert.pem is not found, skipped
    New ca.pem is not found, skipped
    New prikey.pem is not found, skipped

-----------------------------------------------------------
    About to configure DBVISIT DBVNET
-----------------------------------------------------------

>>> Please specify the Local host name to be used by Dbvnet on this server.

    Dbvnet will be listening on the local IP Address on this server which
    resolve to the host name specified here.
    If using a cluster or virtual IP make sure the host name or alias
    specified here resolve to the IP address local to where dbvnet is
    installed.  The host name should resolve to IPv4 address, if not
    you can use an IPv4 IP address instead of host name.

    Enter a custom value or press ENTER to accept default [kiwi2016b]:
     >

>>> Please specify the Local Dbvnet PORT to be used.

    Dbvnet will be listening on the specified port for incoming connections
    from remote dbvnet connections.  Please make sure that this port is not
    already in use or blocked by any firewall.  You may choose any value
    between 1024 and 65535, however the default of 7890 is recommended.

    Enter a custom value or press ENTER to accept default [7890]:
     >


>>> Please specify the Dbvnet Passphrase to be used for secure connections.

    The passphrase provided must be the same in both the local and remote
    Dbvnet installations.  It is used to establish a secure (encrypted)
    Dbvnet connections

    Enter a custom value:
     > kiwi123

-----------------------------------------------------------
    Summary of the Dbvisit DBVNET configuration
-----------------------------------------------------------
    DBVISIT_BASE C:\Program Files\Dbvisit
    DBVNET_LOCAL_HOST kiwi2016b
    DBVNET_LOCAL_PORT 7890
    DBVNET_PASSPHRASE kiwi123

    Press ENTER to continue
    Default cert.pem is found, replace certificates with new files
    New cert.pem is not found, skipped
    New ca.pem is not found, skipped
    New prikey.pem is not found, skipped

-----------------------------------------------------------
    About to configure DBVISIT DBVAGENT
-----------------------------------------------------------


>>> Please specify the IPv4 address or host name to be used for the Dbvisit Agent.

    The Dbvisit Agent (Dbvagent) will be listening on this local address.
    Connections from Dbvserver (GUI) will be established to this Dbvagent,
    thus the address must be visible from the Dbvserver location.
    If using a cluster or virtual IP, make sure the host name or alias
    specified here resolves to the IP address local to where the Dbvagent
    is installed.
    The host name should resolve to an IPv4 address, otherwise you can use
    an IPv4 IP address instead of a host name.

    Enter a custom value or press ENTER to accept default [kiwi2016b]:
     >


>>> Please specify the listening PORT number for Dbvagent.

    The Dbvisit Agent (Dbvagent) will be listening on the specified port for
    incoming requests from Dbvserver (GUI). Please make sure that this
    port is not already in use, and is not blocked by any firewall. You may choose
    any value between 1024 and 65535, however the default of 7891 is recommended.

    Enter a custom value or press ENTER to accept default [7891]:
     >


>>> Please specify the passphrase for Dbvagent

    Each Dbvisit Agent must have a passphrase specified. Think of this passphrase
    as the password for Dbvserver (GUI) to access each Dbvagent securely.
    The passphrase can be unique to each Dbvagent. It will be used to establish a
    secure connection between Dbvserver and the Dbvisit Agent.

    Enter a custom value:
     > kiwi123


>>> Please specify the IPv4 address or host name to be used for the
      Dbvserver Return Address (OPTIONAL)

    This is an advanced, and OPTIONAL parameter. If unsure, please accept
    the default value, which is blank.

    If necessary, you can use this parameter to specify a fixed IPv4 address
    for the Dbvisit Dbvserver (GUI). In the overwhelming majority of cases,
    our software will handle this for you automatically, and setting
    this parameter should NOT be necessary.

    If, however, your Dbvserver's externally-visible address differs from
    the locally-resolved address, you can specify it here. The most common
    scenario where this can happen is if you have address forwarding set up
    on a cloud-deployed environment. If set, Dbvagent will use this address
    instead of any other to connect to Dbvserver.

    Enter a custom value or press ENTER to accept default [ ]:
     >


>>> Please specify the port number to be used as the
      Dbvserver Return Port (OPTIONAL)

    This is an advanced, and OPTIONAL parameter.

    This is the port value to match the OPTIONAL Dbvserver Return Address
    parameter immediately above. If unsure, please accept the default value,
    which is blank.

    Enter a custom value or press ENTER to accept default [ ]:
     >

-----------------------------------------------------------
    Summary of the Dbvisit DBVAGENT configuration
-----------------------------------------------------------
    DBVISIT_BASE C:\Program Files\Dbvisit
    DBVAGENT_LOCAL_HOST kiwi2016b
    DBVAGENT_LOCAL_PORT 7891
    DBVAGENT_PASSPHRASE kiwi123
    DBVAGENT_WEBSERVER_HOST
    DBVAGENT_WEBSERVER_PORT

    Press ENTER to continue
    A custom cert.pem is found, leave user files
    No need to configure standby, skipped.
Copied file C:\Program Files\Dbvisit\dbvnet\conf\dbvnetd.conf to C:\Program Files\Dbvisit\dbvnet\conf\dbvnetd.conf.202012011531
    DBVNET config file updated
Copied file C:\Program Files\Dbvisit\dbvagent\conf\dbvagent.conf to C:\Program Files\Dbvisit\dbvagent\conf\dbvagent.conf.202012011531
    DBVAGENT config file updated

    -----------------------------------------------------------
    Component      Installed Version
    -----------------------------------------------------------
    standby        10.0.0RC_24_g94ba1d85
    dbvnet         10.0.0RC_24_g94ba1d85 (dbvnet v1.5.0-301-g3896e54)
    dbvagent       10.0.0RC_24_g94ba1d85
    dbvserver      not installed
    observer       not installed

    -----------------------------------------------------------
    NTF repo installed.

-----------------------------------------------------------
    About to start service DBVISIT DBVNET
-----------------------------------------------------------
    Successfully started service DBVISIT DBVNET

-----------------------------------------------------------
    About to start service DBVISIT DBVAGENT
-----------------------------------------------------------
    Successfully started service DBVISIT DBVAGENT

>>> Installation completed
    Install log C:\Users\ADMINI~1\AppData\Local\Temp\dbvisit_install.log.202012011529.

    Press ENTER to continue

5.11.  Step 11 - Installation Complete

Once the installer script has finished, the installation process is complete.

You can now click on Finish.

Repeat the same process on the secondary (standby or primary) system.

It is important that the Dbvisit Standby software on both the primary and standby systems match.


5.12.  Next Steps

The next step once the software is installed on both primary and standby systems is to configure the Dbvisit Standby Configuration (DDC) file.


6. Videos 

6.1 How to Install Dbvisit Standby v10 in Linux 

6.2 How to Install Dbvisit Standby v10 in Windows


Have more questions? Submit a request

Comments

  • Avatar
    Norbert Falkenstein

    We are using DBvisit V8 with oracle 12C on oda servers, now we like to use DVisit V11 and oracle 19C also on oda servers, I'm not able to create a standby database on the seconds node, we are using the storge type ACFS instead of ASM.