Oracle Standard Edition in the Cloud – easy or not?

Oracle Database Cloud Service (Database as a Service)

It is based on VMs provided by Oracle Compute Cloud Service. You can connect to your Oracle Database Cloud Service (Database as a Service) instances by using Oracle Net Services from outside the Oracle Cloud.

Two service levels of Oracle Database Cloud Service (Database as a Service) instances are available:

  1. The Virtual Image level includes the Oracle Database and the supporting software as part of the virtual machine you provision. You have to install the Oracle Database, and you are responsible for all maintenance operations for this software.
  2. Oracle Database Cloud Service (Database as a Service).
    The instance comes with automated tooling for backup, recovery, patching and upgrade. When you provision one of these Oracle Database Cloud Service (Database as a Service) instances, your virtual machine comes with your Oracle Database instance already running, with backup jobs already scheduled.

Standard Edition is like EE in the Cloud

The Cloud is here to stay, and lot’s of people have already tried it out, and by googling, it seems that most of the articles are focused on the Enterprise Edition option. Please check out Tim Hall’s post about his tests from here.

How about if I want a Standard Edition Database? Any different steps needed?  Let’s check it out.

How-To create a SE Instance in the Cloud

1 – Create a SSH public/private key

  1. Generating a SSH Public/Private Key Pair (I used PuTTY Key Generator), to be used with our SE Cloud Database.  Enter a password/passphrase for the private key and save the private key.
    • To save the public key copy and paste in a Notepad file the generated text, and save the Notepad document with the .pub expension; for example MyPubOraCloudKey.pub
SSH Key Generator
SSH Key Generator
Copy and save your Public Key
Copy and save your Public Key

IMPORTANT – Save the keys and remember the passphrase for your private key. This will be
used in further steps.

2 – Create a Storage Container

Before creating the SE instance it’s a good idea to create the storage container, since this will be required during the Instance creation phase. It is used for backups, and I used CloudBerry,  but you can also create one with REST API if that’s more your “cup-of-tea”.

Create Storage Container for Backups

3 – Login to Your Oracle Cloud account (Create if not available)

After you have registered with your (trial) account, login and remember to choose the “Data Center” associated with your services. In my case i use a site geographically near Finland.

SE on Cloud
SE on Cloud

4 – Create a Database Cloud Service SE Instance

Click on the Oracle Database Cloud Service and you will see a a  “Create Instance” – button on the right side of the Dashboard, and choose the Database option

createService

Choose the Create Service”- button and fill in the questionnaire form

Choose Virtual Machine or a Cloud Service

Create Service

Choose a Database version you need

Choose Database version 11 or 12
Choose Database version 11 or 12

In early days of Oracle Cloud Service, the only available Standard Edition version provided was SE1. Checked the information provided by Oracle at the moment, and they say “Standard Edition”, so I guess they now provide us with the SE2 edition.

so is it Standard Edition 2?

Choose Standard Edition Database

Choose Standard Edition Database

Service Configuration Steps

Give your service a suitable name, Description, Shape, timezone, and provide your SSH public Key to be used for authentication when using a SSH client to connect to a compute node VM that is associated with your SE Cloud Service Instance:

createService4

Database and Backup Configuration

Provide the rest of the information.  Remember the CloudBerry stage performed earlier? Now is the time to provide the information about the storage you created.

Database & Backup Configuration
Database & Backup Configuration

That’s all. A note to my self: How about the “automatic backup routines” that came with the above configuration steps?

Checking with CloudBerry, and some backups available already….Nice.

Backups already there
Backups already there

There is my newly created Standard Edition Database and instance, and it didn’t take long and didn’t require much Oracle DB skills to get things working. Anybody can clearly get a DB up and running in no time.

The real question now is how about using or administrating this type of database? Any pitfalls to be aware of? How about migrating the old On-prem database with a different character set to this Cloud SE Database? How do I restore a lost Cloud SE DB? Can anybody perform the normal DBA stuff as easily, or do they need some kind of Oracle DB knowledge? I guess it’s time to figure out, if some Oracle DBA skills are needed at all in this world among clouds.

Take care, stay well, and enjoy the challenges in life!

–Ann

Turku 23.7.2016

ps. This YouTube might be handy. It shows the steps mentioned above

Leave a Reply

Your email address will not be published. Required fields are marked *