PurposeThis tutorial covers how to create database instances in the Oracle Database Cloud Service - Database as a Service (DBaaS).
Time to Complete
Approximately 30 minutes.
IntroductionOracle 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
In this tutorial, you will use the Create Database Cloud Service wizard to create a database instance.
- You need one of the supported browsers listed in the following table:
|Microsoft Internet Explorer||9 or 10; set Browser Mode to IE9 or IE10|
|Mozilla Firefox||24 and later|
|Google Chrome||29 and later|
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.
To create a new database instance, in the Database Cloud Service console click Create Instance.
The Create Database Cloud Service wizard is invoked, displaying the Subscription Type page.
Filling the Subscription Type Page
Use the Subscription Type page to select the service level and billing frequency.
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).
On the Subscription Type page, you also select the billing frequency. For this tutorial, select Monthly. Then click Next.
Filling the Software Release Page
For this tutorial, select Oracle Database 12c Release 1. Then click Next.
Filling the Software Edition Page
For this tutorial, select Enterprise Edition. Then click Next.
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
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 (-).
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.
- 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.
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>.
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.
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.
Filling the Service Details Page - Backup and Recovery Configuration
Next, you fill the fields in the Backup and Recovery Configuration section.
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.
Confirming Your Database Instance Definition
On the Confirmation page, review your database definition choices.
When you are satisfied with the information, click Create.
In this tutorial, you learned to:
- Use the Create Database Cloud Service wizard to create a database instance
- For more detailed information about creating Oracle Database instances in the Oracle Database Cloud Service (DBaaS), see the documentation.
- To learn more about Oracle Database Cloud Service, visit the Database Cloud Service.
- For training on the Oracle Cloud platform-as-a-service (PaaS) Services, visit the Oracle Learning Library
- Look at these videos on working with the Oracle Database Cloud Service:
- 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.
- 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.