Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Create

...

Before you start building standby database you need to have at least 2 OCI Database Systems ready and connected through the same VCN. Here is a list of prerequisites, that need to be fullfilled before you start installation of Dbvisit Software:

...

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

...

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

...