In my previous post, I activated and created a Cloud Standard Edition Database (=CSE) .
Oracle’s promise – Cloud no DBA necessary
“Fully managed by Oracle – no DBA necessary”
The above statement is for a Database Schema Service database, and sounds very promising from a SME business owners perspective. Hopefully I have time to test drive it, to check the degree of truth in that statement.
Testcase Database as a Service (=DBaas)
So I am the lucky “owner” of a Cloud Standard Edition Database.
Our Cloud Standard Edition Database is not yet aware of any companies data.
What does my Cloud SE DB looks like?
Newly created without any Customer Data
The picture above shows my newly created CSE.
The CSE database has not yet any business related data in it, and 93% of Operating system Memory in use.
Well-known DBA routines still useful?
Should I have asked for a bigger Cloud? Are these numbers normal and good enough to hold the real customer data as well? Should I have taken something into considerations, before activating my CSE database? Did I miss something important? How can I be sure not to overdue the small budget, that the SME customer has? How about the automatic backup routines? Can I rely on the default backup policy, or should I urgently fix them? Is this Cloud different from On-Prem or should I stick to the company’s well-known DBA routines?
I found this document, but do still have some open questions that need answers.
Start using my CSE
Oracle provide us with an “out-of-the-box” the “DBaas Monitor” Console, which helps us monitoring our Cloud Standard Edition Database Instance well being.
Before we can use the “DBaas Monitor” Console, we need to sign in to our Cloud Service account, and enable the https access “Access Rules” option for our instance:
Instance Access RulesEnable https AccessOK – otherwise will not work
Login to DBaas Monitor
There. Now we can Open the Console and start to explore our newly created CSE.
DBaas MonitorDBaas monitorDBaas monitor Login
Login to CSE with SQL Developer
If your attention is to use SQL Developer remember to enable the listener from our Cloud Service.
Access Role – SQL Developer
After this small exercise in the Cloud, more questions arises.
Thinks to think about in SE
In my next post I will talk about Cloud Backup Service and what to think about when your DB is a SE Cloud version.
Take care, stay well and let’s enjoy the sunny days of Summer!