Create Virtual Machines

Owned by Petr Horejs
Last updated: Jan 12, 2024
3 min read

The most important part of FSDR are the machines itself. Oracle OCI has a restriction, that there is no possibility to add Oracle Standard Edition machine to FSDR stack. There are 2 ways to overcome this restriction.

  1. We can create primary and standby machines as compute instance, install Oracle Database software there and add these machines to FSDR.

  2. Or we can use the prebuilt Oracle Standard Edition Database machine types. We will create 2 machines - primary and standby. We will drop the database on the standby machine. These won’t be added to the FSDR stack due to FSDR restrictions. Next to these machines we have to create one compute instance, which will be used only for FSDR purposes. This compute instance will be registerd as member of FSDR groups and this instance will run the Switchover and Failover scripts through ssh.

 

Create Primary Database Machine

To create the database machines, press Top left menu, then Oracle Database and click on the Oracle Base Database Service.

Click Create DB System:

Fill in following things:

  • Compartment

  • Name of the Machine

  • Availability Domain

  • Shape of the Machine

  • Standard Oracle Database Edition

  • Define a method for access. Either create new keys, upload your own key, or paste the public key

  • Choose the VCN - Virtual Cloud Network

  • Select either public or private interface. If you are going to login from internet, choose the public one

  • Enter prefix of the machine network name

  • Press Next

In the Database Creation Menu:

  • Fill in the desired Database Name

  • Choose a password for sys user. Hint: #1mpoSSible_Pssw0rd

  • Disable database backups, if the machine is only for testing purposes

  • Press Create DB System

Create Standby Database Machine

Repeat the same steps as for Primary Machine. Make sure you choose different OCI region or availability domain for the standby database machine if you want a real DR solution.

Also please enter the same database name during standby database machine creation.

New DB unique name will be issued. Remember to note this down.

Create Compute Instance Machine

Press the Top Left menu and choose Compute and then Instances:

Press the Create instance button:

In the instance Creation Menu, choose following things:

  • Name: Control Center - since this instance won’t be used at all, we will use it as a Control Center (GUI) for Dbvisit Management

  • Choose correct Compartment

  • Choose desired placement of the instance

  • Choose shape with the lowest costs

  • Select correct VCN

  • Assign Public interface to the machine

  • Define how to upload ssh key for further ssh access

  • Let Live Migration set

  • Press Create Instance

Now that we have all the machines involved in the FSDR stack, we need to make custom adjustments to them.