Search

Top 60 Oracle Blogs

Recent comments

Oracle’s DBaaS Is Easy

Introduction

Oracle has been king of the database hill for many years. Now, they’re extending that dominance to the cloud. Oracle DataBase as a Service (DBaaS) uses the Platform as a Service (PaaS) model to enable deployment and management of Oracle database instances in the cloud.

Using Oracle’s DataBase as a Service (DBaaS) is quick and easy. In the example below I create and deploy an Oracle SE instance in about thirty minutes; about twenty of that was waiting for the system to complete provisioning. Have you ever been able to create a database and built the server space it required so simply? Once you have Oracle’s DBaaS, instance creation and deployment can be as easy as following a wizard-based process; no forms to fill out from you operations people and no hardware to purchase/allocate.

Creating a New Service

First you must have an Oracle Cloud account with DBaaS. Log in and go to “My Services” as shown below. Click on “Create Service” to begin the wizard-based process.

Once, the wizard begins you will be “walked” through a series of steps to define and deploy your database instance.

Subscription Type and Billing Frequency

The first screen in the process asks that you choose to create the database entirely with wizards (as I do in this paper), manually, or using DBCA (Database Configuration Assistant).

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0031-1024x... 1024w, http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0031.png 1083w" sizes="(max-width: 447px) 100vw, 447px" />

Software Release

The next stage in the process is to specify the database version to be used. (Rumor has it that Oracle 12c 12.2 will be available first to Oracle DBaaS cloud customers and then to on-premise shops.)

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0041-1024x... 1024w, http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0041.png 1061w" sizes="(max-width: 486px) 100vw, 486px" />

Software Edition

Part of Oracle DBaaS flexibility is allowing you to choose a Standard Edition (SE) database as shown below; or one of three “flavors” of Oracle Enterprise Edition.

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_005-1024x7... 1024w, http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_005.png 1047w" sizes="(max-width: 483px) 100vw, 483px" />

Service Details (Configuration)

The Service Details panel allows detailed specification of the Database Service including Service Configuration, Backup and Recovery Configuration, and Database Configuration. For the sake of example I did not set up Backup and Recovery and went with the simplest setup possible. However, as you can see many options allow specification of a complex fully protected database.

SSH Public Key

Security is a significant concern in today’s world; Oracle’s DBaaS requires that you provide a valid SSH key to protect your cloud resource. On UNIX/Linux/Mac this means running the “ssh-keygen” line command, on Windows this is usually accomplished using PuTTYgen’s SSH-2 RSA feature. You will specify a “passphrase” and create a public key and a private key. You will use the public key when creating the DBaaS service instance and the private key when accessing it later.

Choose the “Edit” button provided to direct the wizard to your SSH Public Key file selection.

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0081.png 505w" sizes="(max-width: 300px) 100vw, 300px" />

Here is the screen with the public key file in place. Next select the “shape” of the instance. In this example I selected a simple single CPU with minimal RAM; most of the instances I create are for training developers so this is more than adequate. Your applications might require significantly greater resources, so choose them!

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0091-1024x... 1024w, http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0091.png 1050w" sizes="(max-width: 484px) 100vw, 484px" />

Backup and Recovery

In this example; I opted to skip having backup and recovery. For most of my training courses this is the appropriate decision. Your production systems will probably require that you more-fully protect your data.

Database Configuration

In the final part of the screen you may choose to create the instance from an existing backup; or you may specify several options to complete the database configuration: file storage; admin password, SID, PDB name, character sets, and whether or not to enable Oracle GoldenGate.

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0111-1024x... 1024w, http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0111.png 1059w" sizes="(max-width: 500px) 100vw, 500px" />

Confirmation Page

Finally, the “Create Service Instance” wizard provides a confirmation page allowing you to review and if necessary go back and change settings.

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0121-1024x... 1024w, http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0121.png 1080w" sizes="(max-width: 438px) 100vw, 438px" />

Service Created

Once the service is created; you are returned to the Cloud Services Dashboard where the new service is listed. However, it may take a while for provisioning and deployment to complete. Clicking on the instance name “sedemo1” in the example below takes you to a page that show many specifics for the instance.

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_013.png 1024w" sizes="(max-width: 300px) 100vw, 300px" />

Instance Specifics – Abbreviated

The instance is not yet completely provisioned as shown by the lack of IP address and the “In Progress” message at the bottom of the page. To see more details, click the “show more” link.

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_014-1024x6... 1024w, http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_014.png 1099w" sizes="(max-width: 457px) 100vw, 457px" />

Instance Specifics – Detailed

After clicking “show more” greater detail is displayed about the DBaaS service instance. Note, still “in progress” – this can sometimes take 15-20 minutes.

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_015-1024x7... 1024w, http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_015.png 1102w" sizes="(max-width: 419px) 100vw, 419px" />

Create Service Completed!

Once the service is created; a message appears with the start and stop time (about 20 min below). Note that the service has now been assigned an IP address and a connect string.

http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0161-1024x... 1024w, http://kingtraining.com/blog/wp-content/uploads/2016/09/dbaas_0161.png 1106w" sizes="(max-width: 412px) 100vw, 412px" />

All Done!

As you can see; it is remarkably easy to “spin up” an Oracle instance using DBaaS. Remember this the next time you need a test database, or to support a new application, or to build a Proof-of-Concept system. Oracle DBaaS is quick and easy to use.