Written by Syed Jaffar Hussain
First thing first, do not get behind from the rest of the Oracle Cloud world. Let’s a step ahead and catch up all the latest happening in Oracle cloud technologies. Cloud is not something very new, it’s there for some time now, however, after Oracle’s very aggressive marketing and heavy investment in Cloud technologies (data centers and new offerings), the fight among the Cloud dinosaurs (Amazon, Microsoft & Oracle) has been raised the bar. Over the past one month and so, I have been extensively doing some cool Oracle Cloud stuff using one month Free Cloud Trial, which can be further extended by a month, and decided to share all my learning in these set of articles.
Let me emphasize one thing before we deep dive into the Oracle Cloud world. I am not going to provide any comparison between the Oracle and rest of the Cloud competitors. My solo intention is to provide all the Oracle Database cloud stuff that I have learned over the past one month and so. Plus, discuss the various Cloud services that Oracle offers, what are the major security concerns that put Organization back step to embrace the cloud and how Oracle address these issues.
There are many advantages going to the Cloud, such as cost efficiency, quick deployments, easy provisioning, access from anywhere etc., however, organizations such as finance,Government, health sectors & manufacturing, are still hesitant to fully go with the Cloud technologies, mainly due to the data security/sovereignty, local legal and compliance policies, and other risks. Below are a few major risk concerns raised in the Cloud (Originally discussed at, http://www.csoonline.com/article/3043030/security/the-dirty-dozen-12-cloud-security-threats.html):
Cloud service abuse
Like other Cloud market competitors, Oracle also offers three types of cloud models: Public, Private and Hybrid. Each type has its share of pros and cons. Oracle provide the following cloud services, (www.oracle.com/cloud):
Software as a Service (SaaS) – HCM - ERP – EPM – SCM
Platform as a Service (PaaS) – Database Management – Integration – App Development
Infrastructure as a Service (IaaS) – Compute – Storage - Network
For being data security (hosting data off-site) is one of the prime concerns for financial sectors and other big organizations, Oracle has recently came-up with a new era of Cloud offering, Oracle Cloud Machine (OCM), aka on premises cloud machine, where the Oracle Cloud Machine will be hosted in your Data center, plugged into your own network, behind your firewall. With OCM you can leverage the Public Clouds Pass and IaaS capabilities, which includes, Oracle Java Cloud, Oracle Database Cloud and Oracle Integration Cloud. The image below depicts the architecture of OCM:
Apart from the security and other concerns/risks talked earlier that prevents big organizations moving into the cloud, is the database performance. The customers demand cutting-edge hardware for their highly OLTP and Analytical databases. For such customers, Oracle offers its engineered systems (Exadata) in cloud services. It delivers the same database performance as on-premises. Customers can start with a quarter rack systems and can expand as per the demand.
Oracle M7 SuperCluster is a ready to deploy secure cloud infrastructure machine, serves both database and application needs for cloud. M7 with the following ability provides the highly secure cloud infrastructure:
The processors in M7 server provides Software in Silicon ability that protects data from the unauthorized access.
Cryptographic Acceleration provides end-to-end encryption with nearly zero-overhead
Immutable zones, provides read only VMs
If you are new to Oracle cloud model, it is essential to understand which services comes under which category. Below are the images from Oracle Cloud that depicts the services that are offered under each category:
Image: Software as Service (SaaS)
Image: Platform as Service (PaaS)
Image: Infrastructure as Service (IaaS)
Oracle Free Trial offering let you use the Oracle Cloud services free for a month, also can be extended for another month. Using the Free Trial, one could explore the Cloud options and have some real hands-on with the abilities. As a first step, get started understanding Oracle cloud concepts and its services vising the below URL:
The following provides a step-by-step procedure how to setup a free trial to explore Oracle Cloud services:
Once you have setup a free trial account using the instruction specified in the above document, now it is time to get started with Oracle Cloud database creation using the procedure below.
On My Account à Sign-in to My Account, as shown in the below image:
Then, provide your general Oracle SSO log-in credentials:
On the Dashboard, scroll down to the Oracle Database Cloud Services option
Provide the Free Trial Cloud credentials:
Go to the Service Console:
You will be then taken to the page where you can create a new database service:
To create a new database service, hit on the Create Service button.
Choose the Service level, select the first option: Database Cloud Service and Monthly billing frequency for your test, and hit the Next button.
Select the preferred Database instance, Oracle 11gR1 or Oracle 12cR1 and hit the Next button.
Here you have a choice of different database editions. For a RAC database and all other Enterprise Edition features, like partitioning, multitenant etc., select Enterprise Edition – Extreme Performance option. (Remember, each edition is directly proportional to the billing you choose)
On Details page, input all the database instance related values and also determine the CPU and RAM that you needed for your service. After your input all the values, hit the Next button.
On the Confirmation page, just hit the Create button, as shown in the below image:
Sit back for a while and relax till the service is provisioned, as show in the picture below:
Once the instance is provisioned, you see the below details:
In order to access the database server through putty, SQL Developer and OEM, you must enable access controls, like listener, http server etc. Go to the Dashboard and select Oracle Compute Cloud Service option.
Go to the Network tab to enable the access control:
From the dropdown list, on each service name, choose Enable, as shown below picture:
After updating the status as Enabled, all services should appears like the below:
Since all the access control, listener, http port etc is enabled, you can now configure the putty connection details to access the database to manage and perform the database activities.
Open the PuTTY Configuration. Enter the Hostname (IP ADDRESS), provided again the database instance you have created.
Configure Oracle user (which has no password), as show in the below screen shot:
Also enter the private key that was generated as per the documentation.
Then save the configuration for future connection. Once you login, you see the below screen shots:
Oracle provides the below users to connect to the database machine:
Oracle user for Oracle database instance
OPC – a sudo user, similar to root user
This part of the article, you have understand the general benefits of Cloud technologies, what type of Cloud is supported by Oracle and what are the services under each category. Also, demonstrated how to have a month Free Trial to play with Oracle Database Cloud service. In the next article, I will demonstrate how to manage the cloud database, tools/utilizes to perform backup recovery and other advanced options. Also, will discuss the methods to migrate on premise database to cloud.