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:
- 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.
- 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
- 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
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”.
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.
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
Choose the Create Service”- button and fill in the questionnaire form
Choose Virtual Machine or a Cloud Service
Choose a Database version you need
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.
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:
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.
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.
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!
ps. This YouTube might be handy. It shows the steps mentioned above