We're here to help!

Installing Dbvisit Standby

Follow


1. Introduction

This section will cover the prerequisites for installing Dbvisit Standby version 8, and take you through the detail steps of installing the Dbvisit Standby version 8 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 8 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 be 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.

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 8 Dbvserver component.  In most installations these 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 is 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 minimum 512MB free space in this location to cater for the installation.

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 8 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)
    • Default port used is 7890

  • Dbvisit Agent (Dbvagent)
    • Default port used is 7891

  • Dbvisit GUI (Dbvserver)
    • 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.

Note: in most cases you will need to allow these ports to be open in your IPTABLES 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 8, Oracle RAC configurations are treated different.

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

In Dbvisit Standby version 8, 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 8 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 8 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 8 software, a Virtual IP (name) is created, 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 my 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/8.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, example:

oracle@dbvlin103[/home/oracle/8.0/dbvisit/installer]: mkdir /home/oracle/tmp
oracle@dbvlin103[/home/oracle/8.0/dbvisit/installer]: export TMPDIR=/home/oracle/tmp
oracle@dbvlin103[/home/oracle/8.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 be 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 be listed in the /etc/oratab file if using UNIX installations.
  • When using Windows based installations, the Primary Database will be listed in the registry if 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, 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 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 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 be 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.3.  Central Console Requirements 

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

From version 8 when talking about the Central Console, we will refer to the Dbvisit Standby GUI also known as Dbvserver.  

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

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 

The latest versions of the browsers are recommended.

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

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.3.1.  Recommended Operating System Packages

Before installing the Dbvisit Standby central console it is recommended that the following operating system package - if using Linux be installed prior to installing Dbvisit Standby version 8 Dbvserver component:

  • glibc 
  • zlib
  • libaio


2.4.  E-Mail Notifications

Dbvisit Standby version 8 will 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 E-Mail Notification Configuration.



2.5.  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 be 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.  


IMPORTANT

In the Dbvisit Standby version 8.0.02 initial release there is only one way to schedule Dbvisit to send and apply logs, and this is using the Windows Scheduler.

An update will be released that will enable the option to create a new Windows service for each DDC which will then run as a kind of "background" process, which will then monitor the Oracle database if a primary and if logs are generated they will be detected and send to the standby. On the Standby a service will be created per DDC and when started, will review the ARCHDEST locations and if new logs arrive, they will automatically be applied.

Values will be configurable via the DDC file.

This new feature is available in Linux based installations from 8.0.02 (see dbvctl -d -D start|stop|status) and is expected to be included in Windows as either the first or the second update.


2.5.1.  Logon 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.5.2.  Directory Permissions

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

This also counts for the ARCHSOURCE and ARCHDEST locations.  If these directories does 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

Dbvisit Standby version 8 uses the same directory structure as was introduced in version 7.  This directory structure is different in comparison to the previous version 5 and 6.

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

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

On Linux it is possible to have both version 7 and 8 installed side by side, but only one should be run at a time.  

3.1.  The Dbvisit Standby Repository Overview

As with previous versions of Dbvisit Standby, version 8 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.

Version 8 of Dbvisit Standby does not store the repository inside the Oracle database - as was done in previous versions.  

In version 8 the repository is stored in a 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 8 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 8.  This section cover the installation of Dbvisit Standby on a Non-RAC environment (Single Instance configuration).

The Dbvisit Standby version 8 installation uses approximately 170MB 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 8 the default installation location is /usr/dbvisit, it is also known and referred to as the Dbvisit Base (DBVISIT_BASE) directory.

Step 1:  Create "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 

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

The Dbvisit Standby software is available for different Operating Systems and versions as noted on the download web page.

In summary:

  • Files with -el5- in the name can be used for Oracle Linux and Red Had Enterprise Linux 5 (example - dbvisit-standby8.0.04-el4.zip)
  • Files with -el6- in the name can be used for Oracle Linux and Red Had Enterprise Linux 6 (example - dbvisit-standby8.0.04-el5.zip)
  • Files with -el7- in the name can be used for Oracle Linux and Red Had Enterprise Linux 7 (example - dbvisit-standby8.0.04-el6.zip)

Unless specified all installation files are for 64bit installations (x86_64)


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 8.0 in /home/oracle and copy the software download into this directory. 

oracle@kiwi101[/home/oracle]: mkdir 8.0
oracle@kiwi101[/home/oracle]: cd 8.0
oracle@kiwi101[/home/oracle/8.0]:


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


We now have the following structure:

oracle@kiwi101[/home/oracle/8.0]: ls -al *.zip
-rw-r--r-- 1 oracle oinstall 73135790 Jun 24 11:06 /home/oracle/8.0/dbvisit-standby8.0.01-el7.zip
 

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@dbvlin101[/home/oracle/8.0]:
oracle@dbvlin101[/home/oracle/8.0]: unzip dbvisit-standby8.0.01-el7.zip
Archive:  dbvisit-standby8.0.01-el7.zip
  inflating: dbvisit-standby8.0.01-el7.tar
 
oracle@dbvlin101[/home/oracle/8.0]: ls -al
total 271080
drwxr-xr-x   2 oracle oinstall        78 Jun 24 11:45 .
drwx------. 11 oracle oinstall      4096 Jun 10 10:41 ..
-rw-r--r--   1 oracle oinstall 204441600 Jun 24 11:05 dbvisit-standby8.0.01-el7.tar
-rw-r--r--   1 oracle oinstall  73135790 Jun 24 11:06 dbvisit-standby8.0.01-el7.zip

oracle@dbvlin101[/home/oracle/8.0]: tar xf dbvisit-standby8.0.01-el7.tar
oracle@dbvlin101[/home/oracle/8.0]: ls -al
total 271088
drwxr-xr-x   3 oracle oinstall       127 Jun 24 11:45 .
drwx------. 11 oracle oinstall      4096 Jun 10 10:41 ..
drwxr-x---   7 oracle oinstall        80 Jun 24 11:05 dbvisit
-rw-r--r--   1 oracle oinstall 204441600 Jun 24 11:05 dbvisit-standby8.0.01-el7.tar
-rw-r--r--   1 oracle oinstall  73135790 Jun 24 11:06 dbvisit-standby8.0.01-el7.zip
-rw-r--r--   1 oracle oinstall        37 Jun 24 11:05 INSTALL.txt
-rw-r--r--   1 oracle oinstall      3811 Jun 24 11:05 README.txt
 


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@dbvlin101[/home/oracle/8.0]: cd dbvisit
oracle@dbvlin101[/home/oracle/8.0/dbvisit]: ls -l
total 0
drwxr-x---  6 oracle oinstall  62 Jun 24 11:05 dbvagent
drwxr-x---  6 oracle oinstall  60 Jun 24 11:05 dbvnet
drwxr-x---  6 oracle oinstall  63 Jun 24 11:05 dbvserver
drwxr-xr-x  2 oracle oinstall  28 Jun 24 11:05 installer
drwxr-x--- 10 oracle oinstall 101 Jun 24 11:05 standby

oracle@dbvlin101[/home/oracle/8.0/dbvisit]: cd installer
oracle@dbvlin101[/home/oracle/8.0/dbvisit/installer]: ls -l
total 2688
-rwxr-x--- 1 oracle oinstall 2749132 Jun 24 11:05 install-dbvisit



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

oracle@dbvlin101[/home/oracle/8.0/dbvisit/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

            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

            Remote server to run Dbvnet? (mandatory)
                --dbvnet-remote-host dbvlin2

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

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

            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 passfrase to encrypt network data transfers? (mandatory):
                --dbvagent-passphrase abc123

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

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


*** Exit code -1
>>> Install log

Note - the dbvisit-install script must have 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 7 installation make sure you select the same base folder into which Dbvisit Standby version 7 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 or 6 installations - you must first upgrade them to version 7 before you can update to version 8 - or 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 being displayed provides 3 options - Install, Uninstall and Terminate.  Enter "1" to start the installation process.
    2. 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.  
    3. 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 disaster this system might be usable - which means you web based front-end is not available.  Therefor having it installed on a separate configuration (host) is recommended.
    4. 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 are required:
    1. The local host where you are currently installing - hostname should be provided, this could be an 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 remote server (example the standby server if this host is the primary) - hostname should be provided, this could be an hostname alias, but it must be able to resolve to an IP address of the remote server to be used.
    4. The remote dbvnet port - The default recommended value is 7890 
    5. The last question is for a passphrase.  This is a 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 relate 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 host name:  this is the local host name which can be a host alias that resolve 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.
  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@dbv103 8.0]$ ls
dbvisit-standby8.0.01-el7.zip

[oracle@dbv103 8.0]$ unzip dbvisit-standby8.0.01-el7.zip
Archive:  dbvisit-standby8.0.01-el7.zip
  inflating: dbvisit-standby8.0.01-el7.tar

[oracle@dbv103 8.0]$ tar xf dbvisit-standby8.0.01-el7.tar
[oracle@dbv103 8.0]$ ls -l
total 275360
-rw-r--r-- 1 oracle oinstall        37 Sep  5 04:45 INSTALL.txt
-rw-r--r-- 1 oracle oinstall      3811 Sep  5 04:45 README.txt
drwxr-x--- 7 oracle oinstall      4096 Sep  5 04:45 dbvisit
-rw-r--r-- 1 oracle oinstall 208005120 Sep  5 04:45 dbvisit-standby8.0.01-el7.tar
-rw-r--r-- 1 oracle oinstall  73948821 Sep  5 04:48 dbvisit-standby8.0.01-el7.zip

[oracle@dbv103 8.0]$ cd dbvisit/installer/

[oracle@dbv103 installer]$ ls
install-dbvisit

[oracle@dbv103 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.

>>> 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        8.0.01.17287        not installed
    dbvnet         1.0.01.17319        not installed
    dbvagent       1.0.01.17319        not installed
    dbvserver      1.0.01.17319        not installed

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

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

    Your choice: 1

    Which component do you want to install?
       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)
       6 - Exit Installer

    Your choice: 1


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

    Press ENTER to proceed 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.

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

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

    Dbvnet will be listening on the specified port for incomming 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]:
     > 7890


>>> Please specify the Remote host name to be used by Dbvnet.

    By default Dbvnet will use this remote hostname for any remote
    connections.  Dbvnet must be installed and configured on the specified
    remote host. 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.
    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 [dbv103]:
     > dbv104


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

    Dbvnet will connect to the remote server on this specified port.
    On the remote host Dbvnet will be listening on the specified port for incomming
    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]:
     > 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 /usr/dbvisit
    DBVNET_LOCAL_HOST dbv103
    DBVNET_LOCAL_PORT 7890
    DBVNET_REMOTE_HOST dbv104
    DBVNET_REMOTE_PORT 7890
    DBVNET_PASSPHRASE kiwi123

    Press ENTER to proceed to continue

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


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

    The Dbvisit Agent (Dbvagent) will be listening on this local address. If you are
    using the Dbvserver (GUI) - connections from the GUI will be established to the
    Dbvisit Agent. The Dbvisit Agent address must be visible from the Dbvserver (GUI)
    installation.
    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.

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


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

    The Dbvisit Agent (Dbvagent) will listening on the specified port for incomming
    requests from the GUI (Dbvserver).  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 7891 is recommended.

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


>>> Please specify passphrase for Dbvagent

    Each Dbvisit Agent must have a passpharse specified.  This passphrase does not have
    to match between all the servers.  It will be used to establish a secure connection
    between the GUI (Dbvserver) and the Dbvisit Agent.

    Enter a custom value:
     > kiwi123


-------------------------------------------------------------------------------
    Summary of the Dbvisit DBVAGENT configuration
-------------------------------------------------------------------------------
    DBVISIT_BASE /usr/dbvisit
    DBVAGENT_LOCAL_HOST dbv103
    DBVAGENT_LOCAL_PORT 7891
    DBVAGENT_PASSPHRASE kiwi123

    Press ENTER to proceed to continue

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

    Press ENTER to continue

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

    Press ENTER to continue

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

    Press ENTER to continue

    -------------------------------------------------------------------------------
    Component      Installer Version   Installed Version
    -------------------------------------------------------------------------------
    standby        8.0.01.17287        8.0.01.17287
    dbvnet         1.0.01.17319        1.0.01.17319
    dbvagent       1.0.01.17319        1.0.01.17319
    dbvserver      1.0.01.17319        not installed

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

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

    Your choice: 3

>>> Install log /tmp/dbvisit_install.log.201609050448

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@dbv101 dbvisit]$ cd dbvnet
[oracle@dbv101 dbvnet]$ ls
conf  dbvnet  doc  log
[oracle@dbv101 dbvnet]$ ./dbvnet -d start
[oracle@dbv101 dbvnet]$ ps -ef|grep dbvnet|grep -v grep
oracle     120     0  0 11:09 ?        00:00:00 ./dbvnet -d start

Example - Starting Dbvagent:

[oracle@dbv101 dbvisit]$ cd dbvagent
[oracle@dbv101 dbvagent]$ ls
conf  dbvserver  doc  log
[oracle@dbv101 dbvagent]$ ./dbvagent -d start
[oracle@dbv101 dbvagent]$ ps -ef|grep dbvagent|grep -v grep
oracle     120     0  0 11:09 ?        00:00:00 ./dbvagent -d start

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@dbv101 dbvisit]$ cd dbvagent
[oracle@dbv101 dbvagent]$ ls
conf  dbvserver  doc  log
[oracle@dbv101 dbvagent]$ ./dbvagent -d stop
[oracle@dbv101 dbvagent]$ ps -ef|grep dbvagent|grep -v grep
[oracle@dbv101 dbvagent]$


Example - Stopping Dbvnet:

[oracle@dbv101 dbvisit]$ cd dbvnet
[oracle@dbv101 dbvnet]$ ls
conf  dbvnet  doc  log
[oracle@dbv101 dbvnet]$ ./dbvnet -d stop
[oracle@dbv101 dbvnet]$ ps -ef|grep dbvnet|grep -v grep
[oracle@dbv101 dbvnet]$

4.  Installing Dbvisit Standby Central Console (Dbvserver)

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

In Dbvisit Standby version 8 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 or 7 configurations. Only version 8.0.x are supported.


4.1.  Examples

4.1.1.  Installing Dbvserver (GUI)


Make sure that the libaio package is 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 8.0.x Web Based Interface) onto a standalone system.  

No other Dbvisit Standby components needs 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)


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


[oracle@dbv103 8.0]$ ls -l
total 72208
-rw-r--r-- 1 oracle oinstall 73933964 Aug 30 09:21 dbvisit-standby8.0.01-el7.zip
[oracle@dbv103 8.0]$ unzip dbvisit-standby8.0.01-el7.zip
Archive:  dbvisit-standby8.0.01-el7.zip
  inflating: dbvisit-standby8.0.01-el7.tar
[oracle@dbv103 8.0]$ ls -l
total 275328
-rw-r--r-- 1 oracle oinstall 207994880 Aug 30 09:13 dbvisit-standby8.0.01-el7.tar
-rw-r--r-- 1 oracle oinstall  73933964 Aug 30 09:21 dbvisit-standby8.0.01-el7.zip
[oracle@dbv103 8.0]$ tar xf dbvisit-standby8.0.01-el7.tar
[oracle@dbv103 8.0]$ ls -l
total 275340
-rw-r--r-- 1 oracle oinstall        37 Aug 30 09:13 INSTALL.txt
-rw-r--r-- 1 oracle oinstall      3811 Aug 30 09:13 README.txt
drwxr-x--- 7 oracle oinstall      4096 Aug 30 09:13 dbvisit
-rw-r--r-- 1 oracle oinstall 207994880 Aug 30 09:13 dbvisit-standby8.0.01-el7.tar
-rw-r--r-- 1 oracle oinstall  73933964 Aug 30 09:21 dbvisit-standby8.0.01-el7.zip
[oracle@dbv103 8.0]$ cd dbvisit
[oracle@dbv103 dbvisit]$ ls -l
total 20
drwxr-x---  6 oracle oinstall 4096 Aug 30 09:13 dbvagent
drwxr-x---  5 oracle oinstall 4096 Aug 30 09:13 dbvnet
drwxr-x---  5 oracle oinstall 4096 Aug 30 09:13 dbvserver
drwxr-xr-x  2 oracle oinstall 4096 Aug 30 09:13 installer
drwxr-x--- 10 oracle oinstall 4096 Aug 30 09:13 standby
[oracle@dbv103 dbvisit]$ cd installer
[oracle@dbv103 installer]$ ls -l
total 2772
-rwxr-x--- 1 oracle oinstall 2837448 Aug 30 09:13 install-dbvisit
 
[oracle@dbv103 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.

>>> 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        8.0.01.17287        not installed
    dbvnet         1.0.01.17291        not installed
    dbvagent       1.0.01.17291        not installed
    dbvserver      1.0.01.17291        not installed

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

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

    Your choice: 1

    Which component do you want to install?
       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)
       6 - Exit Installer

    Your choice: 5

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


>>> Please specify the host name 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 the host name or alias
    specified here resolve to the IP address local to where Dbvserver is installed.
    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 [dbv103]:
     > dbv103


>>> DBVSERVER LOCAL PORT

    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]:
     > 4433

-------------------------------------------------------------------------------
    Summary of the Dbvisit DBVSERVER configuration
-------------------------------------------------------------------------------
    DBVISIT_BASE /usr/dbvisit
    DBVSERVER_LOCAL_HOST dbv103
    DBVSERVER_LOCAL_PORT 4433

    Press ENTER to proceed to continue

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

    Press ENTER to continue

    -------------------------------------------------------------------------------
    Component      Installer Version   Installed Version
    -------------------------------------------------------------------------------
    standby        8.0.01.17287        not installed
    dbvnet         1.0.01.17291        not installed
    dbvagent       1.0.01.17291        not installed
    dbvserver      1.0.01.17291        1.0.01.17291

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

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

    Your choice: 3
>>> Install log /tmp/dbvisit_install.log.201608301046
 


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@dbv103 installer]$ cd /usr/dbvisit

[oracle@dbv103 dbvisit]$ ls -l
total 4
drwxr-x--- 5 oracle oinstall 4096 Aug 30 10:46 dbvserver
[oracle@dbv103 dbvisit]$ tree .
.
`-- dbvserver
    |-- conf
    |   |-- dbvserver.conf
    |   `-- dbvserver.db
    |-- dbvserver
    |-- doc
    |   `-- README.txt
    `-- log

4 directories, 4 files
[oracle@dbv103 dbvisit]$


4.1.2.  Starting Dbvserver 

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@dbv103 dbvisit]$ cd dbvserver
[oracle@dbv103 dbvserver]$ ls
conf  dbvserver  doc  log
[oracle@dbv103 dbvserver]$ ./dbvserver -d start

[oracle@dbv103 dbvserver]$ ps -ef|grep dbvserver|grep -v grep
oracle     120     0  0 11:09 ?        00:00:00 ./dbvserver -d start
 


4.1.3.  Testing Access to the GUI

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

You can navigate to the login screen using the URL of format https://: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 first login

Once you have logged in the main Dbvisit Standby version 8 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 8 web based interface, you must have the Dbvisit Standby version 8 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, 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@dbv1 /usr/dbvisit/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]: Yes

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

Is this correct?  [Yes]: Yes
 
Enter Dbvisit Standby location on remote server: [/usr/dbvisit]:
Your input: /usr/dbvisit

Is this correct?  [Yes]: 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]: Yes

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

Is this correct?  [Yes]: Yes

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

Is this correct?  [Yes]: Yes
-------------------------------------------------------------
Testing the network connection between local server and remote server dbv2.
-------------------------------------------------------------
Settings
========
Remote server                                          =dbv2
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 dbv2...
-------------------------------------------------------------
Trace file /usr/dbvisit/standby/trace/230_dbvctl_system_readiness_201611172115.trc

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

[oracle@dbv1 /usr/dbvisit/standby]$






5.  Installing Dbvisit Standby on Windows

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

Before installing the software, please make sure you have reviewed the pre-requisite steps in section 2.5.WindowsEnvironmentPre-requisites discussed earlier in this document.

The steps for Installing Dbvisit Standby version 8 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 be 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 Virus software application installed and make sure these do not block the Dbvisit Standby software components.

The recommended method for installing Dbvisit Standby version 8 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


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 dedicate local or domain account that have 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 correct.  The value cannot be empty.

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


5.8.  Step 8 - 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 detect an earlier installation, depending on the version no questions may be asked.


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.





Have more questions? Submit a request

Comments