Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page described describes the installation process of Dbvisit StandbyMP on Linux and Windows platforms.

You much must review & complete all Installation Requirements prior to starting installation: Installation Requirements

Info

There is no specific required sequence to install dbvagentmanagers and dbvcontrol. For example it doesn’t matter if you install first dbvcontrol on separate host, or if you first install primary dbvagentmanager.

You can choose any sequence for installing Dbvisit StandbyMP components which suits you best.

Table of Contents
stylenone

1. Linux

Note

Never use root user for Installation of Dbvisit StandbyMP on Linux

Note

This installation procedure is not valid for Oracle RAC and SEHA environments. Refer to <<TBD>> instead

1.1  Create a "Dbvisit Base" Directory

  • This step needs to be done on primary, standby and dbvcontrol server (if different from standby server).

This step is the only exception where we will need to use root privileges. The default location is /usr/dbvisit. You can specify any location you need as long as has enough free space (see Installation Requirements ). Following commands can be used to create installation directory:

Code Block
sudo mkdir /usr/dbvisit
sudo chown oracle:oinstall /usr/dbvisit

The ownership of the directory needs to be changed to the user who will install and run Dbvisit (Oracle/SQLServer/Postgres Database software owner). 

1.2  Download and Extract Latest Software

  • This step needs to be done on primary, standby and dbvcontrol server (if different from standby server).

...

The latest available version can be downloaded from the Dbvisit web site https://dbvisit.atlassian.net/wiki/spaces/DSMPV12/pages/4403331076/Installation+Requirements

1. Linux

Note

Never use root user for Installation of Dbvisit StandbyMP

www.dbvisit.com 

Once the software is downloaded, you can upload / copy it to a temporary location on your server, do not use Dbvisit Base location. Make sure the ownership of the file is set to the same user who owne Dbvisit Base:

Code Block
mkdir /tmp/dbvisit
cd /tmp/dbvisit
# now upload files
chown oracle:oinstall /tmp/dbvisit/standby-v12.1.tar.gz
tar -xzf standby-v12.1.tar.gz

Verify you can now see two installer files:

Code Block
-rwxr-xr-x. 1 oracle oinstall 188106709 Jan 28 09:54 install-agent-v12.1
-rwxr-xr-x. 1 oracle oinstall  64448219 Jan 28 09:52 install-control-v12.1

1.3 Install Dbvisit StandbyMP dbvagentmanager

  • This step needs to be done on primary and standby server only

You can start the installation by running in install-agent file:

Code Block
cd /tmp/dbvisit
./install-agent-v12.1

You will need to respond to following prompts during installation:

Prompt

Example Value

Comment

Please carefully read the end-user license agreement at https://dbvisit.com/eula. Do you agree to the terms of this agreement?

Yes

Installation will proceed only with response “Yes”

Which directory should the software be installed into?

/usr/dbvisit

Dbvisit Base directory you prepared earlier

Agent File Transfer Port: (7890)

There’s usually no need to change the port, press enter to accept suggested value

Fully Qualified Domain Name for this host: [? for help] (czlin0231)

czlin0231

hostname (including domain name or not) of your primary server. Hostname must be resolvable into valid IPv4 address and such interface needs to be present on the host

Fully Qualified Domain Name for the Control Center:

czlin0232

hostname (including domain name or not) where you will install your dbvcontrol. Hostname must be resolvable into valid IPv4 address. It is not required for controlcenter to be installed / running at this point.

Agent Communications Port:(5533)

There’s usually no need to change the port, press enter to accept suggested value

Passphrase:

Admin123

passphrase used for encrypting communication between dbvagentmanagers and dbvcontrol. Must match on all hosts. There is no complexity requirement.

Example complete output of installation:

Expand
titleClick to Expand
Code Block
[oracle@czlin0231 mp]$ ./install-agent-v12.1.0DEV-49-ga7643cd35
+----------------------------------------------------------------------+
|          ____  _                  _ _           __  __ ____          |
|         / ___|| |_ __ _ _ __   __| | |__  _   _|  \/  |  _ \         |
|         \___ \| __/ _' | '_ \ / _' | '_ \| | | | |\/| | |_) |        |
|          ___) | || (_| | | | | (_| | |_) | |_| | |  | |  __/         |
|         |____/ \__\__,_|_| |_|\__,_|_.__/ \__, |_|  |_|_|            |
|          Copyright 2024                   |___/   By Dbvisit         |
+----------------------------------------------------------------------+

Welcome to Dbvisit StandbyMP setup version v12.1.0DEV-49-ga7643cd35.

? Please carefully read the end-user license agreement at https://dbvisit.com/eula. Do you agree to the terms of this agreement? Yes
? Which directory should the software be installed into? /usr/dbvisit

- - - You are now configuring the Dbvisit StandbyMP Agent - - -

The Agent will listen on the following discovered addresses:
 -  127.0.0.1
 -  10.0.2.15
 -  192.168.8.231
? Agent File Transfer Port: 7890
? Fully Qualified Domain Name for this host: czlin0231
? Fully Qualified Domain Name for the Control Center: czlin0232
? Agent Communications Port: 5533
Each Dbvisit StandbyMP Agent and the Dbvisit StandbyMP Control Center must
be configured with the same passphrase. This is how we know that they are all
intended to be part of the same system. Please specify a strong passphrase - we
suggest at least 12 characters, containing at least 2 numbers and 2 symbols.
? Passphrase: *
? Confirm Passphrase: *

- - - Dbvisit StandbyMP Agent configuration finished - - -


- - - Ready to perform installation - - -

? Do you wish to proceed with the setup using the supplied configuration options? Proceed with setup

- - - Performing installation - - -

Copying software files to '/usr/dbvisit'...
Writing Agent configuration file '/usr/dbvisit/standbymp/conf/dbvagentmanager.ini'...

- - - File creation complete - - -


- - - Configuration Summary - - -

Install Directory:                                  /usr/dbvisit
Fully Qualified Domain Name for this host:          czlin0231
Fully Qualified Domain Name for the Control Center: czlin0232
Agent Communications Port:                          5533
Agent File Transfer Port:                           7890

- - - Installation Summary - - -

The following actions have been performed:
 -  Installed Dbvisit StandbyMP Agent software into: /usr/dbvisit/standbymp
 -  Agent settings are available in the configuration file: /usr/dbvisit/standbymp/conf/dbvagentmanager.ini
 -  Generated new security certificates in: /usr/dbvisit/standbymp/certificates

- - - INSTALLATION SUCCESSFUL - - -


To enable the installed Dbvisit StandbyMP components to run as system services, you will need to execute some commands as the "root" user in order to complete the setup.

To install the system service(s), you can run, substituting the name of the user to run as if it is different from the current user:
        sudo /usr/dbvisit/standbymp/bin/dbvagentmanager service install --user oracle
To start the system service(s), you can run:
        sudo /usr/dbvisit/standbymp/bin/dbvagentmanager service start

Directly after the installation of dbvagentmanager is finished, you have the option to create dbvagentmanager systemctl service by copying and running the last lines in the installer output:

Code Block
sudo /usr/dbvisit/standbymp/bin/dbvagentmanager service install --user oracle
sudo /usr/dbvisit/standbymp/bin/dbvagentmanager service start

Creating systemctl service for dbvagentmanager will ensure dbvagentmanager will automatically startup after server reboot.

1.4 Install Dbvisit StandbyMP dbvcontrol

  • This step needs to be done on server where you intend to install dbvcontrol (separate host or standby server).

You can start the installation by running in install-control file:

Code Block
cd /tmp/dbvisit
./install-control-v12.1

You will need to respond to following prompts during installation:

Info

When installing dbvcontrol on standby server, choose same dbvisit base as you’ve chosen for dbvagentmanager, do not separate dbvcontrol installation from dbvagentmanager

Prompt

Example Value

Comment

Please carefully read the end-user license agreement at https://dbvisit.com/eula. Do you agree to the terms of this agreement?

Yes

Installation will proceed only with response “Yes”

Which directory should the software be installed into?

/usr/dbvisit

Dbvisit Base directory you prepared earlier

Control Center Web Server Port: (4433)

There’s usually no need to change the port, press enter to accept suggested value.

Agent Communications Port: (5533)

There’s usually no need to change the port, press enter to accept suggested value.

Passphrase:

Admin123

passphrase used for encrypting communication between dbvagentmanagers and dbvcontrol. Must match on all hosts. There is no complexity requirement.

Example complete output of installation:

Expand
titleClick to Expand
Code Block
[oracle@czlin0231 mp]$ ./install-control-v12.1.0DEV-49-ga7643cd35
+----------------------------------------------------------------------+
|          ____  _                  _ _           __  __ ____          |
|         / ___|| |_ __ _ _ __   __| | |__  _   _|  \/  |  _ \         |
|         \___ \| __/ _' | '_ \ / _' | '_ \| | | | |\/| | |_) |        |
|          ___) | || (_| | | | | (_| | |_) | |_| | |  | |  __/         |
|         |____/ \__\__,_|_| |_|\__,_|_.__/ \__, |_|  |_|_|            |
|          Copyright 2024                   |___/   By Dbvisit         |
+----------------------------------------------------------------------+

Welcome to Dbvisit StandbyMP setup version v12.1.0DEV-49-ga7643cd35.

? Please carefully read the end-user license agreement at https://dbvisit.com/eula. Do you agree to the terms of this agreement? Yes
? Which directory should the software be installed into? /usr/dbvisit

- - - You are now configuring the Dbvisit StandbyMP Control Center - - -

The Control Center will listen on the following discovered addresses:
 -  127.0.0.1
 -  10.0.2.15
 -  192.168.8.231
? Control Center Web Server Port: 4433
? Agent Communications Port: 5533
Each Dbvisit StandbyMP Agent and the Dbvisit StandbyMP Control Center must
be configured with the same passphrase. This is how we know that they are all
intended to be part of the same system. Please specify a strong passphrase - we
suggest at least 12 characters, containing at least 2 numbers and 2 symbols.
? Passphrase: *
? Confirm Passphrase: *

- - - Dbvisit StandbyMP Control Center configuration finished - - -


- - - Ready to perform installation - - -

? Do you wish to proceed with the setup using the supplied configuration options? Proceed with setup

- - - Performing installation - - -

Copying software files to '/usr/dbvisit'...
Writing Control Center configuration file '/usr/dbvisit/standbymp/conf/dbvcontrol.ini'...

- - - File creation complete - - -


- - - Configuration Summary - - -

Install Directory:              /usr/dbvisit
Control Center Web Server Port: 4433
Agent Communications Port:      5533

- - - Installation Summary - - -

The following actions have been performed:
 -  Installed Dbvisit StandbyMP Control Center software into: /usr/dbvisit/standbymp
 -  Control Center settings are available in the configuration file: /usr/dbvisit/standbymp/conf/dbvcontrol.ini
 -  Generated new security certificates in: /usr/dbvisit/standbymp/certificates

- - - INSTALLATION SUCCESSFUL - - -


To enable the installed Dbvisit StandbyMP components to run as system services, you will need to execute some commands as the "root" user in order to complete the setup.

To install the system service(s), you can run, substituting the name of the user to run as if it is different from the current user:
        sudo /usr/dbvisit/standbymp/bin/dbvcontrol service install --user oracle
To start the system service(s), you can run:
        sudo /usr/dbvisit/standbymp/bin/dbvcontrol service start

Directly after the installation of dbvagentmanager is finished, you have the option to create dbvagentmanager systemctl service by copying and running the last lines in the installer output:

Code Block
sudo /usr/dbvisit/standbymp/bin/dbvcontrol service install --user oracle
sudo /usr/dbvisit/standbymp/bin/dbvcontrol service start

Creating systemctl service for dbvcontrol will ensure dbvcontrol will automatically startup after server reboot.

Once dbvcontrol is installed and started, you can verify accessibility by going to following URL:

Code Block
https://<control center hostname>:4433

2. Windows

3. Batch Installation

It is possible to perform fresh installation of Dbvisit components in batch mode if needed for automation. Upgrade in batch mode is not possible.

3.1 Linux

It is possible to run dbvagentmanager and dbvcontrol installer in batch mode using “-batch” switch. Each installer has different parameters and only non-default parameters (marked as “required to specify”) are needed.

Complete set of dbvagentmanager batch installation parameters for Linux:

Code Block
  -agent-communications-port int 
    	Agent communications port number (default 5533)
  -agent-file-transfer-port int
    	Agent file transfer port number (default 7890)
  -control-center-address string
    	host address of the Control Center (required to specify)
  -default-backup-dir string
    	default directory for SQL Server backup files (default value determined by $install-dir/standbymp/backup)
  -host-address string
    	resolvable address of this host (default value determined by hostname)
  -install-dir string 
    	base directory to install into (default value /usr/dbvisit)
  -passphrase string 
    	passphrase used to secure communication between Agents and Control Center (required to specify)

Complete set of dbvcontrol parameters is:

Code Block
  -agent-communications-port int
        Agent communications port number (default 5533)
  -install-dir string
        base directory to install into (default /usr/dbvisit)
  -passphrase string
        passphrase used to secure communication between Agents and Control Center (required to specify)
  -web-server-port int
        Control Center web server port number (default value 4433)

Example batch installation commands:

Code Block
./install-agent-v12.1 -batch -install-dir /usr/dbvisit -host-address czlin0231 -control-center-address czlin0232 -passphrase a
./install-control-v12.1 -batch -passphrase Admin123

You will need to create / start systemctl services same as when performing manual installation

3.2 Windows

Batch installation for Windows has different syntax than on Linux due to the fact that we’re using msi installer. The batch installation can be run by specifying /quiet switch together with parameters listed below:

Complete set of dbvagentmanager batch installation parameters for Windows:

Code Block
INSTALLDIR="C:\Program Files\Dbvisit" 
  base directory to install into (default value C:\Program Files\Dbvisit)
DEFAULTBACKUPDIR="C:\Program Files\Dbvisit\standbymp\backup" 
  default directory for SQL Server backup files (default value determined by $install-dir\standbymp\backup)
AGENTMANAGERDOMAIN="." 
  Domain for User account who will run dbvagentmanager Windows Service (default empty: service is then created as "Local System")
AGENTMANAGERACCOUNT="Administrator" 
  User account who will run dbvagentmanager Windows Service (default empty: service is then created as "Local System")
AGENTMANAGERPASSWORD="abc" 
  passphrase used for User account who will run dbvagentmanager Windows Service (default empty: service is then created as "Local System")
HOSTADDRESS=czwin0191 
  resolvable address of this host (default value determined by hostname)
PASSPHRASE=a 
  passphrase used to secure communication between Agents and Control Center (required to specify)
FTLISTENPORT=7890 
  Agent file transfer port number (default 7890)
NATSPORT=5533 
  Agent communications port number (default 5533)
NATSADDRESS=czwin0192
  host address of the Control Center (required to specify)
Info

specifying “.” for AGENTMANAGERDOMAIN means local user will be used

Complete set of dbvcontrol batch installation parameters for Windows:

Code Block
INSTALLDIR="C:\Program Files\Dbvisit\standbymp" 
  base directory to install into (default value C:\Program Files\Dbvisit)
WEBLISTENPORT=4433 
  Control Center web server port number (default value 4433)
NATSLISTENPORT=5533 
  Agent communications port number (default 5533)
PASSPHRASE=Admin123
  passphrase used to secure communication between Agents and Control Center (required to specify)

Example batch installation commands:

Code Block
agent-v12.1.msi AGENTMANAGERDOMAIN="." AGENTMANAGERPASSWORD="AdminUpwd" AGENTMANAGERACCOUNT="Administrator" PASSPHRASE=Admin123 NATSADDRESS=czwin0192
agent-v12.1.msi /quiet PASSPHRASE=a NATSADDRESS=czwin0192
control-center-v12.1.msi /quiet PASSPHRASE=Admin123
Info

note that although the /quiet command itself will be immediately completed, the installation will run in background and take some time to complete