Create Virtual Cloud Network

To create a Virtual Cloud Network, press top right menu button, choose Networking option and press Virtual Cloud Networks link:

From the top menu press Start VCN Wizard button:

Choose “Create VCN with Internet Connectivity option and press Start VCN Wizard button:

Fill in the VCN Creation form:

1. Name of the VCN: <Name of the VCN>

2. Choose a Compartment to which the VCN belongs

3. Configure whole VCN subnet: 10.0.0.0/16

4. Choose Public subnet: 10.0.0.0/24

5. Choose Private subnet: 10.0.1.0/24

6. Press Next button

Review the information provided and confirm the VCN creation.

Create Database Systems

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

Image Removed

Image Added

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.

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

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

Drop Database on Standby Machine

The Database Service is created with database running, but you do not need the database to be running on the standby machine. Dbvisit will create a copy of the primary database there. To drop the database, you can follow this procedure:

rman target /
RMAN> startup mount force dba;
RMAN> drop database including backups noprompt;

Download and Install Dbvisit Software

There is nothing special in installing Dbvisit Multiplatform in OCI environment.

• Install Control Center on the compute instance machine

• Install Dbvisit Agent on both database machines

Use following document how to install Dbvisit Multiplatform: https://dbvisit.atlassian.net/wiki/spaces/DSMP/pages/3242000447/Installing+Standby+Multiplatform#Installing-Standby-Multiplatform-on-Unix

Create Standby Database using Dbvisit Multiplatform

You can follow this guide, how to create Standby database on Oracle OCI to OCI: https://dbvisit.atlassian.net/wiki/x/JQAJ2w