Creating a Database Cloud Service (DBaaS) Instance

Overview

Purpose

This tutorial covers how to create database instances in the Oracle Database Cloud Service - Database as a Service (DBaaS).  

Time to Complete

Approximately 30 minutes.

Introduction

Oracle Database Cloud Service (Database as a Service) provides a platform to create full Oracle database instances in a virtual machine (VM). You have full access to the features and operations available with Oracle Database, but with Oracle providing the physical storage and (optionally) performing certain database maintenance and management operations automatically.

When you create a database instance, you use the Create Database Cloud Service wizard, which steps you through the process of making the choices that produce a service instance tailored to your needs. These choices include:
  • Service Level
  • Billing Frequency
  • Oracle Database Release Version
  • Oracle Database Edition
  • Computing Power
  • Database Storage
  • Backup and Recovery Configuration
For detailed information on using the Oracle Database Cloud Service (DBaaS), including connecting to database instances, see the documentation Using Oracle Database Cloud Service (Database as a Service).

Scenario

In this tutorial, you will use the Create Database Cloud Service wizard to create a database instance.

Software Requirements

  • You need one of the supported browsers listed in the following table:

  • Browser Version
    Microsoft Internet Explorer 9 or 10; set Browser Mode to IE9 or IE10
    Mozilla Firefox 24 and later
    Google Chrome 29 and later
    Apple Safari 6
Note: This release does not support mobile browsers.

Prerequisites

Before starting this tutorial, you should:

  • Have already procured and activated a trial or paid subscription to the Oracle Database Cloud Service (DBaaS). Don't have a subscription? Go to Oracle Store or https://cloud.oracle.com/database
  • Have generated a secure shell (SSH) private/public key pair, with copies of the private and public key files on your local computer. You will point to the SSH public key when you create the database instance. For details on generating an SSH private/public key pair, refer to the Generating a Secure Shell (SSH) Private/Public Key Pair section of the Using Oracle Database Cloud Service (Database as a Service) documentation.

Invoking the Create Database Cloud Service Wizard

Log in to the Oracle Database Cloud Service (DBaaS) console using the credentials provided by your Oracle Cloud account administrator. For details on accessing the console, see the documentation on Accessing the Database Cloud Service (DBaaS) Console.

  • Your administrator may provide you a link to the My Services console, from which you can choose Oracle Database Cloud Service (DBaaS).
  • Or,  your administrator may provide you a direct link to the Oracle Database Cloud Service (DBaaS) console.
  1. To create a new database instance, in the Database Cloud Service console click Create Instance.

    click create instance
  2. The Create Database Cloud Service wizard is invoked, displaying the Subscription Type page.

    subscription type page

Filling the Subscription Type Page


Use the Subscription Type page to select the service level and billing frequency.
  1. The two types of service level are Oracle Database Cloud Service - Virtual Image, and Oracle Database Cloud Service.

    • You can choose the Oracle Database Cloud Service - Virtual Image service level to define a database instance manually or using the Oracle Database Creation Assistant (DBCA). 
    • You can choose the Oracle Database Cloud Service service level to have the wizard create a database instance for you, using configuration options provided in the wizard. This service level also makes additional cloud tooling available for backup, recovery and patching.

      For this tutorial, select Oracle Database Cloud Service (not the Oracle Database Cloud Service - Virtual Image service level).
    choose service level
  2. On the Subscription Type page, you also select the billing frequency. For this tutorial, select Monthly. Then click Next.

    billing frequency

Filling the Software Release Page

The wizard Software Release page appears. Use this page to select the Oracle Database software release that you want to run on your instance.
  1. For this tutorial, select Oracle Database 12c Release 1. Then click Next.

software release page

Filling the Software Edition Page

The Software Edition page appears. Use this page to select the Oracle Database software edition that you want to run on your instance.
  1. For this tutorial, select Enterprise Edition. Then click Next.

software edition page

Filling the Service Details Page - Instance Configuration

The Service Details page appears. On this page, you configure details in three areas:

  • Instance configuration
  • Database configuration
  • Backup and recovery configuration
  1. First, you fill the fields in the Instance Configuration section.
    Note: Several fields have Help icons to assist you. For example, the Help message for the Instance Name field explains that the instance name of your choice can have up to 50 characters, must start with a letter, and can contain only letters, numbers, and hyphens (-).

    service details page

  2. Enter an instance name.
    Note: The Instance Name is the name by which this database instance will be listed among potentially multiple database instances in your DBaaS service. It is not the database SID or service name, which you will provide in the Database Configuration section of this page.

    Optionally enter a description of the database instance.
    Note: You can use the description to show reminders, such as the public key you used and the storage size. If you create multiple database instances in your DBaaS service, the description of each instance will help distinguish them in the list of instances.

    Select a compute shape from the drop box.
    Note: The compute shape specifies the number of Oracle Compute Units (OCPUs) and amount of memory (RAM) for the virtual machine (VM) hosting the new service instance. Database Cloud Service (DBaaS) offers several OCPU/RAM combinations.

    instance name description compute shape

  3. Fill the VM Public Key field by selecting either the key file name of an SSH public key on your computer, or the key name of an existing SSH public key that was uploaded earlier to your DBaaS virtual machine.
    Note: For details about creating SSH public keys, refer to the links in the Prerequisites section of this tutorial.

    To select a key file name of an SSH public key on your computer to upload to your DBaaS virtual machine, click Browse.

    key file name

    To select they key name of an existing SSH public key that was uploaded earlier to your DBaaS virtual machine, use the full hierarchical name of the public key in the format /Compute-<identity-domain>/<username>/<key-name>.

    key name

    Note: For details on generating an SSH private/public key pair, refer to this tutorial (reviewers: that SSH key tutorial is currently in development; this is a link placeholder), or go to the Generating a Secure Shell (SSH) Private/Public Key Pair section of the Using Oracle Database Cloud Service (Database as a Service) documentation.

Filling the Service Details Page - Database Configuration

Next, you fill the fields in the Database Configuration section.

  1. Enter the amount of storage in GB for actual database data, administrator password, database name (SID), and PDB pluggable database name (if you have selected Oracle 12c).
    Note: The administrator password you provide is used for the SYS and SYSTEM database users, for the admin Oracle GlassFish Server user, and for the admin Oracle Application Express user.

    database configuration

Filling the Service Details Page - Backup and Recovery Configuration

Next, you fill the fields in the Backup and Recovery Configuration section.

  1. For backup and recovery, enter your choice of destinations; container name, user name and user password for an Oracle Storage Cloud container (if backing up to cloud storage).
    When specifying the name of the container, use the format: instance-id_domain/container, where instance is the name of the Oracle Storage Cloud Service instance, id_domain is the name of the identity domain, and container is the name of the container.
    Example for Cloud Storage Container: storagesvc999-usoracleaccoutrial00999/backup_container

    For this tutorial, you can select Block Store Only. Then click Next.

  2. backup and recovery configuration

Confirming Your Database Instance Definition

On the Confirmation page, review your database definition choices.

  1. When you are satisfied with the information, click Create.

  2. confirmation page

    When you return to the Database Cloud Service console, you will see your new database instance listed. It will have a status of "In Progress" until the instance creation is completed.

    in progress

Summary

In this tutorial, you learned to:

  • Use the Create Database Cloud Service wizard to create a database instance

Resources

Credits

  • Lead Curriculum Developer: Rick Green
  • Other Contributors: Mike Fitch, Dom Lindars, Brian Spendolini

To navigate this Oracle by Example tutorial, note the following:

Topic List:
Click a topic to navigate to that section.
Expand All Topics:
Click the button to show or hide the details for the sections. By default, all topics are collapsed.
Hide All Images:
Click the button to show or hide the screenshots. By default, all images are displayed.
Print:
Click the button to print the content. The content that is currently displayed or hidden is printed.

To navigate to a particular section in this tutorial, select the topic from the list.