Create Compute Instances and Install SQL Server

Owned by Petr Horejs
Jan 16, 2024
3 min read

Create Compute Instances

First of all, we need to create 2 compute instances in order to install SQL Server in Oracle OCI.

We need to make sure, that each instance is created either in different region or in different Availability Domain.

 

Before we can create the compute instances, we need to define Virtual Network. You can follow this guide to do that Create Virtual Cloud Network(s)

 

Please follow

To create a compute instance, from the drop down menu select compute and then instances:

image-20240105-153626.png

Press Create Instance button:

image-20240105-162524.png

 

Fill in following information:

  1. Name of the machine: sqlserver_AD1

  2. Choose the correct compartment

  3. Choose correct Availability Domain. Primary and standby machines should be configured in separated Availability Domains. If you are configuring FSDR accross different regions, ignore this step.

  4. Choose an OS image of the machine: Ubuntu 20.04

  5. Choose a shape of the machine

  6. Choose a VCN created in the initial part of this guide

  7. Choose the public or private interface, depends on how you configured the VCN

  8. Generate / upload / paste ssh key to get the access to the machines

  9. Paste the public ssh key here

 

Repeat the same steps to create the Standby database machine.

 

Create Central Console Virtual Machine

Follow this guide how to create virtual machine for Central Console: https://dbvisit.atlassian.net/wiki/spaces/DSMP/pages/3758293006/Create+Control+Center+Virtual+Machine

 

Add Central Console Machine to Disaster Recovery Group

From menu Disaster Recovery → DR Protection Groups open a detail of DR_Group_1 disaster recovery group and on the left side choose Members menu. Press Add member button then.

In the Add member menu fill in following things:

  1. Check, that you confirm deletion of existing plans by adding a member to the DR group

  2. Choose Compute Resource Type

  3. Choose our Control Center machine to be added as a member

  4. Choose “Moving instance” instance type

  5. Press the “Add VNIC mapping” button

In the VNIC mapping menu, choose a different IP address, that is the current IP address to be obtained by the machine:

Press Add button to add the VNIC mapping.

Press Add button to confirm adding a member to the DR group.