1. Introduction
The section of the user guide explains installing Dbvisit Standby MP on AWS EC2 instances. In this guide, we focus on both primary and standby on the AWS. The setup will be a single instance primary database and a single instance standby database on Linux Platform. The data files are stored on a standard filesystem. This is just an example, and it does not limit the possibility of storing the data files on an ASM, using the Windows operating system, or using any supported Oracle platforms that are available on AWS.
2. Initial Setup and Configuration
2.1 Provisioning servers
We will be provisioning two servers, both with the same Linux version and release. We are using community AMIs with Linux 7.9. Click on “Launch Instance with AMI” to move to next step
Below image shows the Instance type choses (t2.medium) and also the key pair to login. We are using the existing key pair to connect to these machines (SydneySC), but a new key can be created by clicking on “Create new key pair”
The next important step is to configure network and firewall which we will see details in the next section.
Adding additional storage for Oracle installation and database files. In this example we have added just one EBS volume with 75Gig. The Root volume is already added as part of the AMI but you can choose to increase the size.
2.2 Network and Firewall
The details of the VPC created is shown below.
Security group for Inbound and Outbound rules. ( 1 ) for Nats Port for agentmanager (5533) communication and also for PostgreSQL cluster ( 2 ) Webserver port for GUI ( 3 ) Dbvnet communication port range , the main port required for this is 7890. ( 4 ) The port for ssh and also for RDP incase of windows. A specific IAM profile is also created that has required permissions and policies assigned to it.
Once this is completed and added. Click on “Launch Instance” to start the instance. There are also options to have reserved public IP to ensure that the IPAddresses do not change after every server restart. These can be used for machines that are created for permanent production use. For this use case we have not enabled them as these machines are used only for temporary purposes. The machine name has also been set to desired one using the tags.
Once the server has been launched. Repeat the same to do for the second server with a different name but use the same VPC, security group and also IAM profile. Now we have two servers. Below is the details of one of them.
Login to the servers using SSH.
3. Installation and Configuration (Oracle and Standby MP)
We now have two servers that can ping each other and connect to them using ssh and also security groups configured to establish connection using the ports 7890,5533 and 4433.
The next steps that were completed are,
a. Installing Oracle on both primary and standby. Create a new database on the primary server.
ec2-user@localhost[/home/ec2-user]: sudo su - oracle Last login: Fri Apr 26 14:40:39 NZST 2024 on pts/0 The Oracle base has been set to /u01/app/oracle oracle@localhost[/home/oracle]: cat /etc/oratab SRC:/u01/app/oracle/product/19.3/dbhome_1:N oracle@localhost[/home/oracle]: ps -ef |grep pmon oracle 7667 1 0 14:42 ? 00:00:00 ora_pmon_SRC oracle 8936 8860 0 14:58 pts/0 00:00:00 grep --color=auto pmon SQL> select name,open_mode from v$database; NAME OPEN_MODE --------- -------------------- SRC READ WRITE
b. Create dbvisit directory on both primary and standby server for installing Dbvisit under /usr directory.
root@localhost[/root]: cd /usr root@localhost[/usr]: mkdir dbvisit root@localhost[/usr]: chown oracle:oinstall dbvisit/