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:
Name of the VCN: <Name of the VCN>
Choose a Compartment to which the VCN belongs
Configure whole VCN subnet: 10.0.0.0/16
Choose Public subnet: 10.0.0.0/24
Choose Private subnet: 10.0.1.0/24
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
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