Friday, May 5, 2017

Oracle Cloud: Creating a Database Deployment

4:51 AM Posted by Dilli Raj Maharjan 2 comments

You must have subscription or free Trial account to proceed.
Open URL

Click on Sign In

Select your data center location. The datacenter location is mentioned on the email send by the Oracle. Format of email will be as mentioned below.

Click on My Services Once you select data center.

Enter your Identity domain and Click on Go.

Enter Username and Password and Click on Sign In

Click on Create Instance link of Dashboard

Click on Database.

Click on Create Service.

Enter Service Name and Description. You can select Service Level as: Oracle Database Cloud Service or Oracle Database Cloud Service - Virtual Image
With Oracle Database Cloud Service, Oracle database software and Oracle database is automatically installed and ready to use. It comes with the cloud tools to backup, patching and others.
On Oracle Database Cloud Service using the Virtual Image service level, Oracle Database is not automatically installed, nor is a database created. We have to install database manually after the deployment is created.

Choose Metering Frequency, Select Hourly if you are using Trial it will save credits for later use.

Choose appropriate Software Release: We have 3 Release of Oracle Database Softwares.
  • Oracle Database 11g Release 2
  • Oracle Database 12c Release 1
  • Oracle Database 12c Release 2

Choose appropriate Software Edition. We have four Software Edition.

Standard Edition: Very basic features, Only single PDB in case of Oracle 12c

Enterprise Edition: Includes performance, availability, scalability, and security required for mission-critical applications such as high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications.

Enterprise Edition - High Performance: provides all the features of Enterprise Edition, plus many of the available Oracle Database options and management packs.

Enterprise Edition - Extreme Performance: provides all the features of Enterprise Edition, plus all of the Oracle Database options and management packs appropriate for use in Oracle Database Cloud Service.

Select the appropriate Database Type. In my case I have selected Single Instance. 
If you select Standard Edition of Oracle you can select Single Instance database only

With Enterprise Edition and Enterprise Edition- High Performance you get Single Instance with Data Guard Standby option too.

If you select Enterprise Edition - Extreme Edition then You will get RAC options with all the options available on Enterprise Edition. 

Once all the appropriate options are selected Click on Next to continue.

This is the landing page once you click on Next. Provide appropriate DB Name, PDB Name and Administration Password. Click on Edit to add SSH Public Key

Click on Update button to select the appropriate location of the key file. If you do not have key file then use ssh-keygen command to generate SSH key. Following images shows how to create ssh-key on OSX using ssh-keygen -t rsa command. 

$ssh-keygen -t rsa

Verify with ls command the key file exists.

Select the appropriate Backup Destination. We have 3 options:
1. Both Cloud Storage and Local Storage: Backup will be stored on Cloud storage container and local storage too. The default retention policy used is to store 30 days backup on cloud and 7 days latest backup on local storage.
2. Cloud Storage Only: Backup will be stored on Cloud storage container only.
3. None: Backup will not stored else where.

You may Click on Advance setting to view the Listener, Timezone, Character set and GoldenGate option.

Once all the required options are selected. Click on Next to view the confirmation page.

Review the selected option for the last time. If you are fine with the selected options Click on Create to continue Database Instance Creation.

 Database Instance creation on progress.


Once instance creation is completed, The Status label is removed and is ready to access. Click on the service name to view details of the Database Instance.

Note IP address and now you can login to the server via putty or ssh

By default 2 OS users are created. 

User opc(an acronym of oracle public cloud) is created with the sudo privileges. The user is intended to perform administrative task with in the Virtual image: OS and the backup and recovery related task. Using opc we can perform any task that requires root-privileges.

User oracle(owner of Oracle Database Software) is created generally for administrative task of Oracle. Using oracle we can authenticate as the sysdba user and create tablesapace, users and perform database admin tasks.