/
Oracle Cloud (DBaaS) -> Oracle Cloud (DBaaS)

Oracle Cloud (DBaaS) -> Oracle Cloud (DBaaS)

Jul 07, 2020

1. Introduction

The purpose of this Deployment guide is to demonstrate the way in which Dbvisit Standby 8.0 software can be used within the Oracle Database As A Service (DBaaS) space. In this guide, we focus on both the Primary and Standby databases hosted on DBaaS.  In another document, we focus on 'On-Premise Primary' to Standby hosts on 'DBaaS'. A link that document can be found here

 

The setup will be from Single Instance Primary Databases to Single Instance Standby Databases with Datafiles stored on standard filesystems. However the options for configuring Dbvisit Standby in the Oracle Cloud are in no way limited to this, it has simply been chosen for demonstration purposes.

2. Initial Setup and Configuration

2.1 Provisioning the Severs

Connect to Oracle Cloud Dashboard 

and Provision 2 Oracle Database Services as shown in the example below.

We opted for "Oracle Database Cloud Service" for Service level and have a pre-created database on each host. It was deemed faster to drop the database on the second host rather than choose the "Oracle Database Cloud Service - Virtual Image" as this does not come with binaries installed as indicated.

 

I generated a private and public set of key files using ssh-keygen from my local Linux machine.

oracle@dbvlab01[/home/oracle]: ssh-keygen -b 2048 -t rsa -f oraclecloud Generating public/private rsa key pair. Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in oraclecloud. Your public key has been saved in oraclecloud.pub. The key fingerprint is: 35:6b:e6:39:cd:06:c0:04:d9:7e:73:4d:85:80:33:ab oracle@dbvlab01.dbvisit.co.nz oracle@dbvlab01[/home/oracle]:

I could then import this file into the cloud setup in both cases.

For the purposes of the Demo, the Backup Destination is set to None.

Confirm your setup and click "create".

From the Services Tab : 

Summary Details of the 2 Oracle Database Cloud Services are as follows :

 

Primary Server Details

Standby Server Details

Primary Server Details

Standby Server Details

Name: dbvcloud01

OCPUs: 1

OS: OEL6

Memory: 7.5G

Storage: 150G

Version: 12.1.0.2

Edition: Standard Edition

Database: ORCL

Dbvisit Base: /usr/dbvisit

Standby Version: 8.0.12.19052

Name: dbvcloud02

OCPUs: 1

OS: OEL6

Memory: 7.5G

Storage: 150G

Version: 12.1.0.2

Edition: Standard Edition

Database: ORCL

Dbvisit Base: /usr/dbvisit

Standby Version: 8.0.12.19052

2.2 Preparing the Servers 

Connect to each of the cloud hosts with ssh, specifying the public key uploaded when creating the service, as user opc

$ ssh -i /Users/landers/Downloads/oraclecloud opc@dbvcloud02

From here execute sudo -s to switch to the root user and create the dbvisit directory in /usr.  Also vi the /etc/hosts file to reflect the IP address of the other node in each case.

[opc@dbvcloud02 ~]$ sudo -s [root@dbvcloud02 opc]# mkdir /usr/dbvisit [root@dbvcloud02 opc]# chown oracle:oinstall /usr/dbvisit [root@dbvcloud02 opc]# vi /etc/hosts

 

Download the latest version of Dbvisit Standby for OEL6 and SCP to each of the cloud hosts.

$ scp -i oraclecloud dbvisit-standby8.0.12-el6.zip oracle@dbvcloud01:/home/oracle dbvisit-standby8.0.12-el6.zip 100% 70MB 4.4MB/s 00:16 $ scp -i oraclecloud dbvisit-standby8.0.12-el6.zip oracle@dbvcloud02:/home/oracle dbvisit-standby8.0.12-el6.zip 100% 70MB 4.4MB/s 00:16

 

In order for Dbvisit Standby to communicate between the 2 hosts, and to enable access to the GUI frontend, 3 ports need to be made available.  These are 7890 (Dbvnet), 7891 (Dbvagent) and 4433 (dbvserver: GUI). To do this, navigate to the summary page of each host and choose Access Rules from the menu. From here, click the "create rule" button and fill in the details.  The example below shows 1 rule per port range named dbvisit_ports.  It is also possible to create 1 rule per port and name them accordingly.

 

 

At this stage, these servers are ready for the next stage of installing the software.

3. Install, Configure and Run the Standby software

3.1 Installing and Configuring the Software

Unzip, Untar and the run the dbvisit installer following the instructions in the dbvisit installation guide as the user oracle. 

https://dbvisit.atlassian.net/wiki/display/DS8QSG/Dbvisit+Standby+8.0+User+Guide

[oracle@dbvcloud02 ~]$ unzip dbvisit-standby8.0.12-el6.zip Archive: dbvisit-standby8.0.12-el6.zip inflating: dbvisit-standby8.0.12-el6.tar [oracle@dbvcloud02 ~]$ cd dbvisit/installer/ [oracle@dbvcloud02 installer]$ ls -lrt total 2768 -rwxr-x--- 1 oracle oinstall 2833364 May 11 02:16 install-dbvisit [oracle@dbvcloud02 installer]$ ./install-dbvisit

On the node dbvcloud02, the dbvserver (option 5) was also installed.  Alternatively, a 3rd host could be configured for hosting the dbvserver.   Careful to ensure during the dbvnet configuration on each node that the correct hosts are specified for source and destination. The output from the installation on node2 is shown below for reference.

----------------------------------------------------------- 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. Installer Directory /home/oracle/dbvisit >>> 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.12.19052 not installed dbvnet 2.0.12.19052 not installed dbvagent 2.0.12.19052 not installed dbvserver 2.0.12.19052 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 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 [dbvcloud02]: > >>> Please specify the Local Dbvnet PORT to be used. Dbvnet will be listening on the specified port for incoming 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]: > >>> 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 [dbvcloud02]: > dbvcloud01 >>> 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 incoming 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]: > >>> 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 dbvcloud02 DBVNET_LOCAL_PORT 7890 DBVNET_REMOTE_HOST dbvcloud01 DBVNET_REMOTE_PORT 7890 DBVNET_PASSPHRASE kiwi123 Press ENTER 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 [dbvcloud02]: > >>> Please specify the listening PORT number for Dbvagent. The Dbvisit Agent (Dbvagent) will listening on the specified port for incoming 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]: > >>> 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 dbvcloud02 DBVAGENT_LOCAL_PORT 7891 DBVAGENT_PASSPHRASE kiwi123 Press ENTER 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.12.19052 8.0.12.19052 dbvnet 2.0.12.19052 2.0.12.19052 dbvagent 2.0.12.19052 2.0.12.19052 dbvserver 2.0.12.19052 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 [dbvcloud02]: > >>> 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]: > ----------------------------------------------------------- Summary of the Dbvisit DBVSERVER configuration ----------------------------------------------------------- DBVISIT_BASE /usr/dbvisit DBVSERVER_LOCAL_HOST dbvcloud02 DBVSERVER_LOCAL_PORT 4433 Press ENTER to continue ----------------------------------------------------------- About to install Dbvisit DBVSERVER ----------------------------------------------------------- Component dbvserver installed. Press ENTER to continue ----------------------------------------------------------- Component Installer Version Installed Version ----------------------------------------------------------- standby 8.0.12.19052 8.0.12.19052 dbvnet 2.0.12.19052 2.0.12.19052 dbvagent 2.0.12.19052 2.0.12.19052 dbvserver 2.0.12.19052 2.0.12.19052 ----------------------------------------------------------- What action would you like to perform? 1 - Install component(s) 2 - Uninstall component(s) 3 - Terminate Your choice: 3 >>> Installation completed Install log /tmp/dbvisit_install.log.201705240214.

Version 8.0.20 has a new parameter, that of DBVSERVER_PUBLIC_HOST (parameter public_address in dbvserver.conf)

Rather than accepting the default hostname prompt here, the public-facing IPv4 address of the Cloud Host should be used. Public-facing IPv4 address that will be supplied to the Agents (Dbvagent) to be used for pushing information back to the Central Console. This is the externally resolvable address supplied to dbvagent, not an additional listener address on dbvserver itself.

Once the software has been installed on both nodes.  Start the processes.

[oracle@dbvcloud01 installer]$ cd /usr/dbvisit/dbvnet [oracle@dbvcloud01 dbvnet]$ ./dbvnet -d start [oracle@dbvcloud01 dbvnet]$ cd ../dbvagent/ [oracle@dbvcloud01 dbvagent]$ ./dbvagent -d start [oracle@dbvcloud01 dbvagent]$ ps -ef|grep -i dbv oracle 6250 1 0 02:23 ? 00:00:00 ./dbvnet -d start oracle 6388 1 0 02:24 ? 00:00:00 ./dbvagent -d start