Getting started with (DBaaS) Oracle Database 18c on Cloud
In past few months Oracle DBaaS, Oracle Cloud, Oracle Database 18c, Cloud Database and many more terms are trending in Database and IT world. Oracle DBaaS is nothing but a Database provided by Oracle as a Service (Database as a Service) in which our complete database with workloads will reside in Oracle’s cloud. And we’ll get Web based Dashboard (UI) to manage our Database Instances, backups, storage and so on. We can also connect with our database using SSH based on highly secured RSA Key. This SSH connectivity with our cloud server will be a Password-less SSH Connectivity.
Oracle also provides a Free Promotional cloud service in which any company or an individual can create a free promotional cloud account and can test their database and workloads on Oracle Cloud DBaaS. An account holder will get 300 USD for free to utilize on this cloud account, which we’ll use to create our Oracle Cloud Database with Oracle Database 18c Enterprise Edition release.
Before we can create our Cloud Database, we must have a cloud account. So as this post is about a complete process we’ll start from the very beginning. So at the very first, we’ll create Oracle Cloud account.
1. Creating free Oracle Cloud account.
Go the url https://cloud.oracle.com/tryit to create a cloud account. and click on Create a Free Account as shown in the screenshot.
Yes, this is a completely free account without doubt but still Oracle asks for Credit Card details, just in case if we want to extend our One month’s / 300 USD subscription. One more thing to keep in mind that there you may see a minor deduction which Oracle does for verification. However this deduction will also credited back in you account in few hours. In my case deduction was ₹ 50.
Once done with filling these details you will see, Your credit card has been successfully validated. Please proceed to complete the Sign Up Message.
2. Login to your account.
First Check your mailbox, you must have received an email from Oracle Cloud team with login details.Click on Get Started with Oracle Cloud account.First login to your account with the default system generated password.After signing in it will ask you to Set new password. Make sure you meet the password criteria as this will be your Cloud account password which will be used to access your all cloud services like IaaS, PaaS, SaaS and DBaaS. So consider to set strong password.This is the Dashboard screen. As we can see my name initials HP at the right top of the screen which indicates we’ve successfully logged in to our cloud account. Let’s go to the menu as highlighted at the left top corner in the screenshot to get started.Click on Services and then you’ll be able to see Database.So now we’ve our credentials to login to cloud account. So let’s now login into cloud account from the Desktop Computer.
3. Demunix Cloud account.
4. Creating Cloud Database Instance on Oracle Database 18c.
In this screen, Enter an Instance Name, Optional Description about the instance like test or qual or prod, select Software Release and Software Edition from the drop down list I’ve selected Oracle Database 18c Enterprise Edition, select Database type as Single Instance. And click NEXT.
In this screen you’ll need to provide almost every detail about your Database. Enter your Database Name, Administration Password, DB Storage and Total Storage, Compute Shape (Physical memory and CPU Cores).
Now you can see your uploaded Public Key.
If you don’t know how to create Public / Private RSA key, Here is the Guide
To configure Backup and Recovery we need to have Oracle Cloud Storage Container account. If we have it, we’ll just need to enter credentials of Storage account. Here I’m ignoring it for time being. So in Backup Destination we’ll select None. And Click NEXT.
5. Login to Could Database using SSH.
In order to Login to Cloud Database using SSH, we need Public IP of our Instance, and RSA key.
Enter oracle as a username. and you’ll notice it’s being authenticated with public key, which we’ve uploaded at the time of creating the instance.
login as: oracle Authenticating with public key "rsa-key-20180312" [[email protected] ~]$
[[email protected] ~]$ hostname demunix-cloud
Optionally we can check OS Version
[[email protected] ~]$ cat /etc/oracle-release Oracle Linux Server release 6.8
Check pmon background process for oour created instance DEMCLOUD
[[email protected] ~]$ ps -ef | grep pmon oracle 12248 1 0 Mar23 ? 00:00:05 ora_pmon_DEMCLOUD oracle 17174 16810 0 14:45 pts/0 00:00:00 grep pmon
check ORACLE_SID & ORACLE_HOME
[[email protected] ~]$ echo $ORACLE_SID ; echo $ORACLE_HOME DEMCLOUD /u01/app/oracle/product/18.0.0/dbhome_1
Everything seems perfect, Now let’s login to our Cloud Database.
[[email protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 126.96.36.199.0 Production on Sat Mar 24 14:46:47 2018 Version 188.8.131.52.0 Copyright (c) 1982, 2017, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 184.108.40.206.0 - Production Version 220.127.116.11.0 SQL>
Hurrah ! We’re connected to our Oracle Database 18c on Cloud Database.
Let’s check the version.
SQL> select name, status, version from v$database,v$instance; NAME STATUS VERSION --------- ---------- ----------- DEMCLOUD OPEN 18.104.22.168.0
Let’s check the full version.
SQL> select banner_full from v$version; BANNER_FULL -------------------------------------------------------------------------------- Oracle Database 18c Enterprise Edition Release 22.214.171.124.0 - Production Version 126.96.36.199.0
Cheers, We’ve successfully created our Cloud Database on Oracle Database 18c