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.
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.
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:
On this page: |
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, the packages would already be installed and no additional software would be required.
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 ... ... |
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 Systems | Windows Based Systems |
---|---|
/usr/dbvisit | C:/Program Files/Dbvisit |
It is strongly recommended that you make use of the default location when installing Dbvisit Standby.
On Unix, it is important to pre-create this directory and make sure the owner and group used for this directory are the same as what was used for the Oracle Database Software installation. In most cases, this will be the Unix user "oracle" and group "oinstall" or "dba"
Note: It is recommended you have minimum 512MB of free space in this location to cater for the installation.
DBVISIT_BASE is also used to store active redolog during the switchover. Make sure, that there is also additional space available equal to the size of your redolog file |
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:
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.
Note that in Dbvisit Standby version 8, Oracle RAC configurations are treated differently. 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 a large number 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, an example in the case above configuration the following can be added:
192.168.1.18 dbvracdb-vip.demo.net dbvracdb-vip |
For more detail on creating this Virtual IP, please see the Oracle Documentation with regards to the command "appvipcfg"
Below is an example of the steps to create the Virtual IP on a Linux based RAC configuration and starting it on node1 (These commands are only executed on one of the nodes - example node 1 and is done as the "root" user)
appvipcfg create -network=1 -ip=192.168.1.18 -vipname=dbvracdb-vip -user=root crsctl status resource dbvracdb-vip -p crsctl setperm resource dbvracdb-vip -u user:oracle:r-x crsctl setperm resource dbvracdb-vip -u user:grid:r-x crsctl start resource dbvracdb-vip -n node1 |
When installing Dbvisit Standby and you may get the following error "Error: Can't locate libperl.so"
Example:
oracle@dbvlin103[/home/oracle/8.0/dbvisit/installer]: ./install-dbvisit
Error: Can't locate libperl.so
...........
Background Information:
When Dbvisit Standby is executing, including Dbvnet and Dbvserver, temporary files are extracted and used from the default system temp location.
On most Unix system this will be /tmp The problem, in this case, is that the /tmp mount point was mounted using the "noexec" option.
Using the mount command you can quickly review the settings:
oracle@dbvlin103[/home/oracle/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.
When looking at installing the Dbvisit Standby product, you need to make sure that the required supported Oracle Database software is already installed and configured with a primary database running (started in an open read/write mode).
No outage is required for the installation of Dbvisit Standby. It is however required that the primary database is in "archivelog" mode. If not you will need to enable this first - which will require an outage - as a restart of the database is required to enable this option. |
For Oracle RAC environments, all the RAC instances must be running during the initial Dbvisit Standby installation and configuration.
Below are a few key points to take into account with regards to the Primary Server configuration:
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 of either primary or standby databases use ASM storage, the user that installed Dbvisit Standby should be able to connect to the ASM instance as sysdba.
To enable the use of a standby database, your primary database must be in archivelog mode. To determine if the database is in archive log mode run SQL command: "sql> archive log list"
Example:
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 21568 Next log sequence to archive 21571 Current log sequence 21571 |
If the database is not in archivelog mode you can use the following to enable it. Please note this requires an outage. Also, make sure you have sufficient space in your fast/flash recovery area:
SQL > connect / as sysdba SQL > shutdown immediate SQL > startup mount SQL > alter database archivelog; SQL > shutdown immediate; SQL > startup |
For more details on enabling/disabling archivelog mode, please see the Oracle Documentation.
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:
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 |
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:
The latest versions of the browsers are recommended. Please note that local virus software, security policies and configurations may interfere with the web-based interface - it is recommended that you review your settings if the central console is not displaying correctly. Dbvisit Standby central console is tested with the latest base releases of the above browsers without any special add-ons or virus software configurations or security policies applied. |
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:
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 the E-Mail Notification Configuration.
If installing Dbvisit Standby onto a Windows Based environment (Microsoft Windows 2008 and above - 64bit) the following pre-requisite checks should be performed:
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 <DDC> -D start|stop|status) and is expected to be included in Windows as either the first or the second update. |
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:
It is important to make sure that the directories used to store temporary backups - an example where the backups are stored during Create Standby Database (CSD) and Synchronise Standby Database (SYNC) have the Windows Oracle Homeowner added to have full read/write permission.
This also counts for the ARCHSOURCE and ARCHDEST locations. If these directories do not have correct permission, the CSD, SYNC or Graceful Switchover processes could fail with errors similar to:
Below is an extract from a trace file indicating the permission on the TEMP folder was not correct - the Oracle 12c Database Home Owner on Windows which in this example was the "oracle" user did not have sufficient permission on the temporary backup folder which was C:\Temp in this case.
20170116 18:43:54 main::cmn_cat: RMAN-00571: =========================================================== 20170116 18:43:54 main::cmn_cat: RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 20170116 18:43:54 main::cmn_cat: RMAN-00571: =========================================================== 20170116 18:43:54 main::cmn_cat: RMAN-03002: failure of restore command at 01/16/2017 18:43:54 20170116 18:43:54 main::cmn_cat: ORA-19963: error getting logical block size of file C:\TEMP\DBV_DEV_CSD_STDBY.CTL 20170116 18:43:54 main::cmn_cat: ORA-27041: unable to open file 20170116 18:43:54 main::cmn_cat: OSD-04002: unable to open file 20170116 18:43:54 main::cmn_cat: O/S-Error: (OS 5) Access is denied. |
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.
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 an SQLite database which is created as part of the Dbvisit Standby Configuration (DDC) file creation and is located in the DBVISIT_BASE/standby/conf directory. The file will take the format of DB_NAME.db. If you have multiple standby databases, there will only be one repository per primary database.
It is possible to install a Dbvisit Standby version 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.
You can follow these basic steps discussed in this section to install Dbvisit Standby version 8. This section covers 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.
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 |
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 as noted on the download web page. Please check the Dbvisit Standby v8 Support Matrix for supported versions. Unless specified all installation files are for 64bit installations (x86_64) |
Important:
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 |
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 |
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 the execute permission for the Oracle Unix software owner - which in this example is the "oracle" Unix account. |
Below is the detailed output of the installation process.
In summary, the following are performed:
In most cases just accepting the default values are recommended |
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 |
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:
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 |
Stopping the core components Dbvnet and Dbvagent can easily be done by running the following commands:
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]$ |
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.
The Dbvisit Standby version Central Console will not be able to manage Dbvisit Standby version 6 or 7 configurations. Only version 8.0.x is supported. |
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 need to be installed on this system - only the Dbvserver component.
During the installation 4 key questions are asked:
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]$ |
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 |
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://<your-server-name>:4433
It is important to make sure that port 4433 is not blocked by your local firewall |
The login screen should now be visible in your browser
The default username is "admin" and the password "admin"
It is recommended to change this after the first login
Once you have logged in the main Dbvisit Standby version 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.
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)".
When installing Dbvisit Standby, it is important that once the installation on the Primary and the Standby servers are complete and all required processes are started (Dbvnet, Dbvagent and Dbvserver) that we then test the network connectivity between the primary and standby.
This process can help confirm that network communication is working before you continue creating DDC files or if upgrading - performing the DDC file upgrade.
The command to test connectivity is: dbvctl -f system_readiness
A series of questions will be asked, for example, the remote server name. We recommend you run this command on the primary as well as the standby to ensure network connectivity is working prior to continuing with creating or upgrading DDC files.
Example:
Below is an example using the "system readiness" function:
[oracle@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/No> [Yes]: Yes Enter the name of the remote server: []: dbv2 Your input: dbv2 Is this correct? <Yes/No> [Yes]: Yes Enter Dbvisit Standby location on remote server: [/usr/dbvisit]: Your input: /usr/dbvisit Is this correct? <Yes/No> [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/No> [Yes]: Yes Choose copy method: 1) /usr/dbvisit/dbvnet/dbvnet 2) /usr/bin/scp Please enter choice [1] : 1 Is this correct? <Yes/No> [Yes]: Yes Enter port for method /usr/dbvisit/dbvnet/dbvnet: [7890]: Your input: 7890 Is this correct? <Yes/No> [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]$ |
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.
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
Before you start the installer it is again important to make sure that the user account you are running the installer as and that will be used to run the Dbvisit Standby software must be in the Local Administrators, Users and ORA_DBA Windows Groups. Failing to do this can lead to errors during installation. Disabling User Access Control is also recommended.
We recommend you create a new Local Windows account that have the above-mentioned permissions and that this account is used to run the Dbvisit Standby software (it's Services and Windows Schedules).
In the example we will discuss below a new Local account called "dbvisit" is created with the relevant groups assigned. UAC was also disabled.
Before you continue, review the following checklist:
The above ports should be added to the Windows Firewall to allow the Dbvisit Standby components to communicate. If you have a firewall between your Primary and Standby (DR) datacenter please make sure that these ports can be used - especially the Dbvnet port 7890.
Also, review any AntiVirus software application installed and make sure these do not block the Dbvisit Standby software components.
The recommended method for installing Dbvisit Standby version 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.
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.
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
During step 6 you will be requested to provide the Windows user account that will run Dbvisit Standby.
We recommend you create a dedicated local or domain account that has the required permission on the primary and standby servers as mentioned earlier.
This user must have Local Administrator, Users and ORA_DBA group assigned.
If you are using Oracle 12c do not specify the Oracle Home user here, rather use another account that has the correct groups assigned.
The Database Services will still be created to run under the Oracle Home user.
Please make sure you enter this password correctly. The value cannot be empty.
If this password is not entered correctly, the Dbvserver, Dbvnet and Dbvagent services will fail to start.
The installation will now start and should take only a few seconds to a minute to complete.
Once all the software is installed, a confirmation window will be displayed.
The installer script will automatically be executed. During this process, the configuration files for Dbvnet, Dbvagent and Dbvserver will be reviewed.
If no software has been installed before the installer script will prompt the user for input. If the installer detects an earlier installation, depending on the version no questions may be asked.
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.
The next step once the software is installed on both primary and standby systems is to configure the Dbvisit Standby Configuration (DDC) file.