You can find requirements for Dbvisit StandbyMP software installation on this page. There are requirements which common for all installation, and requirements which are platform specific (Windows / Linux) and also specific for each database platform.

You always need to fullfill all applicable requirements to your concrete installation at the same time. For example, if installing Dbvisit StandbyMP on Windows Oracle Server, you will need to fulfill Common Requirements, OS Platform Windows Requirements and Database Platform Oracle Requirements.

1. Common Requirements

These requirements must be satisfied for all Dbvisit StandbyMP installations.

1.1  Network and Ports Requirements

Dbvisit Standby Multiplatform has two components: dbvagentmanager (Agent) and dbvcontrol (Control Center). More information in Dbvisit StandbyMP concept: https://dbvisit.atlassian.net/wiki/spaces/DSMPV12/pages/4396875777/Introduction#2.-Dbvisit-StandbyMP-Components

While dbvagentmanager must be deployed on each primary and standby server, there should be only one dbvcontrol component per whole environment. It is supported to deploy dbvcontrol on primary server or on standby server but never to both at the same time. It is also supported to use separated host from primary or standby for dbvcontrol. This host can have independent OS Platform in relation to primary and standby server.

Dbvisit StandbyMP components use following ports:

A. Deploying dbvcontrol on separate server

When using separate server for dbvcontrol, the firewall rules need to be allowed as per this picture:

B. Deploying dbvcontrol on standby server

When standby server for dbvcontrol, the firewall rules need to be allowed as per this picture:

1.2  Storage Requirements

A. Storage Space Requirements

Dbvisit Standby is installed on all servers forming part of the Standby Database configuration: Primary database server, standby database server and dbvcontrol host (if separate host for dbvcontrol is used).

5GB space for the Dbvisit Standby software installation on the file system - however, 10-15GB is recommended especially for multiple configurations and because of tracefiles.

IMPORTANT: The standby database server will require the same amount of storage capacity as the primary database server for standby database creation, because it will contain primary database synchronized copy. In addition, Dbvisit StandbyMP always uses primary database backup, so standby server will need free capacity for primary database copy as well as for its backup.

B. NFS support

Using NFS for Dbvisit StandbyMP installation is supported on Linux platform only. NFS volumes used for Dbvisit Installation must fulfill following requirements:

• We require to disable attribute caching on NFS client side. NFS volume must be mounted with following mount options:

rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0

• You must ensure that NFS volume insn’t accessed concurrently by two separate dbvisit dbvagentmanager or dbvcontrol processes at the same time as this leads to repository corruption

C. ACFS support (Oracle Specific Feature)

• It is supported to install Dbvisit StandbyMP on ACFS

• You must ensure that NFS volume insn’t accessed concurrently by two separate dbvisit dbvagentmanager or dbvcontrol processes at the same time as this leads to repository corruption

D. CIFS support

• CIFS is not supported for Dbvisit StandbyMP deployment

1.3  CPU and Memory Requirements

Primary Server:

Dbvagentmanager component on primary server requires minimum 1 CPU thread and minimum 1 GB of memory per primary database from which Dbvisit transfers archivelogs.

Standby Server:

Dbvagentmanager component on standby server requires minimum 1 CPU thread and minimum 1 GB of memory per standby database

Dbvcontrol Server:

Dbvcontrol (central webserver console) can be installed on separated Linux or Windows host regardless of database servers OS platform.

The dbvcontrol requirements scale with the total count of primary and standby databases:

1.4  Dbvcontrol Webserver Browser Requirements

We recommend and support Chrome Browser for accessing dbvcontrol. However, other browsers such as Edge or Firefox will work as well. In case of any observed issues, we recommend to switch to Chrome Browser.

1.5  SMTP Server Requirements

Dbvisit StandbyMP uses SMTP server client to send notifications (which are optional). To use the notification feature, it is necessary that dbvcontrol component has direct access to SMTP Server.

Dbvisit StandbyMP supports following SMTP server communication protocols: StartTLS ,TLS/SSL or NoEncryption.

2. OS Platform Requirements

These requirements must be satisfied When installing Dbvisit StandbyMP on specific OS platform (Windows/Linux).

2.1  Linux

Following is a list of Linux platform specific requirements.

• Default installation directory is /usr/dbvisit (this can be modified during installation)

• We recommend to installing Dbvisit StandbyMP as same OS user which runs Database Engine (oracle, postgres …)

• If you have dedicated mount for /tmp, make sure it is NOT mounted with “noexec” option. This can be verified with for example “mount -l” command.

• After the Dbvisit StandbyMP installation, user can choose to create systemctl service for dbvagentmanager and dbvcontrol to automate startup. In this case, root access will be required to start and stop these components.

• SELINUX must be set to disabled or permissive. In Enforcing mode SELINUX will prevent dbvagentmanager and dbvcontrol services from working correctly. You can find out the status by running:

[root@czlin0231 ~]# getenforce
Enforcing

• System date must be actual and match on all servers where Dbvisit StandbyMP is deployed. You can verify by:

$ date
Wed Feb 14 15:35:38 CET 2024
$ sudo systemctl status chronyd #EL8 and newer
$ sudo systemctl status ntpd #EL7 and older

Chronyd and ntpd services will ensure system date correct synchronization. If system date is not synchronized, there can be issues with connection issues because of certificates validity (which is based on actual date).

2.2  Windows

If installing Dbvisit Standby onto a Windows Based environment the following pre-requisite checks should be performed:

A. User performing Installation

This is for example any named user administrator account who will perform Dbvisit StandbyMP software installation.

• The User performing installation of Dbvisit Standby may be a local or a domain user who is part of Local Administrators group

• Default installation directory is C:\Program Files\Dbvisit (this can be modified during installation). User running the Dbvisit installation will assume ownership of installation directory C:\Program Files\Dbvisit

B. Dbvisit StandbyMP User specified during installation

During Dbvisit StandbyMP installation you will be prompted for username and password. This user will be used for running Dbvisit StandbyMP dbvagentmanager service and will be interacting directly with the database engine.

• This user needs to be local or a domain user who is part of Local Administrators group

• This user needs to be granted the "Log On As Service" policy to allow the user to run the Dbvisit Standby Services. To grant, run from command line:

secpol.msc

And afterwards add user:

• This user must have complete privileges to interact with the database Engine present on the server

C. Other Requirements

• For installation It is recommended that User Account Control be turned off - not strictly required, but highly recommended.

• For the duration of installation it is recommended to turn of any 3rd party antivirus software (excluding Windows Defender). It can be enabled again after installation is completed, if whole Dbvisit installation directory is whitelisted and excluded from scan

3. Database Platform Requirements

Below you will find requirements specific for individual database platform. There are different requirements for Windows and Linux platforms.

3.1  Oracle

A. Linux

• We strongly recommend to use user who was used for oracle home installation (typically oracle) for installation of Dbvisit StandbyMP prouct

• Installation user must have same user id and group id on primary and standby server:

[oracle@czlin0231 ~]$ id
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)

B. Windows

• User who is selected to run Dbvisit StandbyMP dbvagentmanager service during installation must be member of following groups:

ora_dba
Local Administrators
Oracle Home DBA group - (if using 12c make sure the user is in the new Oracle Home DBA group)

C. Common

• Dbvisit StandbyMP doesn’t require Oracle Listener for its operation

• When installing Dbvisit StandbyMP on RAC or SEHA environments, additional prerequisites must be fulfilled. See Oracle RAC and SEHA documentation for further details: <<<< TBD >>>>>

• ORACLE_HOME system-wide environment variable must be set to existing oracle home software location

• PATH system-wide environment variable must include ORACLE_HOME\bin directory

3.2  SQL Server

A. Linux

• It is required to Install Dbvisit StandbyMP product as user who is used for runnning SQL Server instance

B. Windows

• We recommend to not specify any user for Dbvisit StandbyMP dbvagentmanager service (so as the installed dbvagentmanager service runs as Local System)

3.3  Postgres

A. Linux

• It is required to Install Dbvisit StandbyMP product as user who is used for runnning Postgres database cluster

B. Windows

• We recommend to not specify any user for Dbvisit StandbyMP dbvagentmanager service (so as the installed dbvagentmanager service runs as Local System)