Oracle Database 18c on Cloud – A Complete Process

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.

DBaaS 18c


Select account type and fill the details.
DBaaS 18c


After filling above details, enter you valid phone number on which you can receive Code, and enter the received code in Verification Code field.DBaaS 18c


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.

So click on Edit Payment Method as shown in the screenshot.DBaaS 18cAnd fill the details.
DBaaS 18cDBaaS 18c

Once done with filling these details you will see, Your credit card has been successfully validated. Please proceed to complete the Sign Up Message.

DBaaS 18cAfter filling details accept the terms and conditions and click on Complete.


Here you see the Thank you message, you work completes here in Creating Account. Now you will receive an email from Oracle Cloud team with further details.DBaaS 18c


2. Login to your account.

First Check your mailbox, you must have received an email from Oracle Cloud team with login details.DBaaS 18cClick on Get Started with Oracle Cloud account.DBaaS 18cFirst login to your account with the default system generated password.DBaaS 18cAfter 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.DBaaS 18cThis 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.DBaaS 18cClick on Services and then you’ll be able to see Database.DBaaS 18cSo 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.

Enter your Cloud credentials.DBaaS 18c


ORACLE Cloud My Services, in the right top corner, we can see my account email and Oracle Cloud account name which is demunix.DBaaS 18c


Click on Services to go to Database service.DBaaS 18c


Click on Database to go to Oracle Database Cloud Service.DBaaS 18c


Click on Instances to go to Create Instance page.DBaaS 18c


4. Creating Cloud Database Instance on Oracle Database 18c.

Click on Create Instance button to initiate Instance Creation Wizard.DBaaS 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.
DBaaS 18c


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 in SSH Public key click on EditDBaaS 18cChoose your public key, (DEMCLOUD.pub)DBaaS 18cClick on Update.DBaaS 18c


Now you can see your uploaded Public Key.

DBaaS 18cIf 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.

DBaaS 18c


Response Confirmation Screen. Nothing to change here, just need to verify our responses and click on Create.DBaaS 18c


As we can see, Status is saying Creating instance. Instance is being created. With 1 OCPU, 7.5 GB of Physical Memory.DBaaS 18c


When you click on instance name which is demunix-cloud in our case. You’ll get the complete details about your instance. even a Public IP.DBaaS 18c


As we can see, Status says ReadyDBaaS 18c


Now we’re good to start the instance. To start it, open menu and click on Start to start the instance.DBaaS 18cClick on OK to Start the instance.

DBaaS 18cAs we can see, Instance start request is accepted now.DBaaS 18c


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.

This is the public key of our instance. Which we can get by clicking on the instance name.DBaaS 18c


In this demonstration, we will connect using PuTTY, so enter Public IP of our Cloud Database instance in PuTTY.DBaaS 18c


Expand SSH and click on Auth (Do not expand auth). and select the PuTTY compatible private key DEMCLOUD.ppk generated by PuTTYgen software. and click on Open.DBaaS 18c


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] ~]$

Verify hostname

[[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 18.0.0.0.0 Production on Sat Mar 24 14:46:47 2018
Version 18.1.0.0.0

Copyright (c) 1982, 2017, Oracle. All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.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.0.0.0.0

Let’s check the full version.

SQL> select banner_full from v$version;

BANNER_FULL
--------------------------------------------------------------------------------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0

Cheers, We’ve successfully created our Cloud Database on Oracle Database 18c

Peace 🙂

1 thought on “Oracle Database 18c on Cloud – A Complete Process

Comments are closed.