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