Friday, February 5, 2016

Oracle Database Cloud Service Provisioning on the fly !!!

Oracle Database Cloud Service Provisioning on the fly !!!

Oracle Database Cloud - Database as a Service provides you the ability to create service instances that contain Oracle databases, with each service instance containing a single Oracle database. You have full access to the features and operations available with Oracle Database, but with Oracle providing the computing power, physical storage and (optionally) tooling to simplify routine database maintenance and management operations.
When you create service instances, Database as a Service creates compute nodes to host the database, using computing and storage resources provided by Oracle Compute Cloud Service. Additionally, it provides access to the compute nodes (and thus to the database) using networking resources provided by Oracle Compute Cloud Service.
Please follow below simple steps to provision Oracle DB instance on cloud as service –


Login into Oracle cloud services account using the credentials which you have received from oracle for your cloud subscription and access “Oracle Database Cloud Service Console” as highlighted in snap


Click on “create” button for creating new instance of DB on cloud


Select the Service level option “Oracle Database Cloud Service”. This is best option as it will create DB with configuration provided by you, also oracle cloud services will take care backup, recovery and patching.

Also, select billing frequency as per your needs.


Select the DB version what you are looking for. In this example I have selected the Oracle Database 12c Release 1 ( installed on Linux 6.6


Select the Edition which you are looking for as per you organization need.


Service Configuration:

Select the name, description, and compute shape of your service instance and provide an SSH public key to access the instance.

DB Attributes
DB Attributes Description
Specify DB Service Name
Enter a name for your service instance.
Enter a description for your service instance
Select a compute shape from the list of supported OCPU (Oracle CPU) and RAM  combinations. These combinations fall into two categories 1) General Purpose and 2) High Memory
Provide the time zone for the service instance to use
SSH Public key
Provide the SSH public key to be used for authentication when using an SSH client to connect to a compute node that is associated with your service instance

Database Configuration:
Select the amount of data storage, administrator password, database name (SID), PDB name (for Oracle Database 12c), inclusion of “Demos” PDB (for Oracle Database 12c) for the Oracle Database to be created in your service instance.

DB Attributes
DB Attributes Description
Usable Database Storage (GB)
Enter the amount of storage you want for actual database data (in GB).
Total Data File Storage (GB
The computed amount of storage in GB that will be allocated to your instance, including space for operating system and product binaries, supporting files, database data and configuration files, and so on.
Administration Password and Confirm Password
Enter and then reenter a password for administrative access to the database and to other
components of your service instance, specifically:
– Oracle Database SYS and SYSTEM users
– Oracle Application Express ADMIN user
– Oracle GlassFish Server admin user
– Cloud database monitor access
DB Name (SID)
Enter a name for the database instance. This name:
PDB Name
(Available only for Oracle Database 12c)—Enter a name for the
default PDB (pluggable database).
Character Set
Provide the database character set for the database.

Backup and Recovery Configuration:
Select how backups are to be configured
DB Attributes
DB Attributes Description
Backup Destination
Select how backups are to be configured 1) None 2) Both Cloud Storage and Local Storage
Backups are not configured for your service instance
Both Cloud Storage and Local Storage
Backups are configured to be created automatically and stored both on local storage and on an Oracle Storage Cloud Service container.
Cloud Storage Container
Enter the name of an existing Oracle Storage Cloud Service container in the format:
Where instance is the name of the Oracle Storage Cloud Service Instance. Can be find using Rest Endpoint URL given for your storage e.g.
In above “Storage” is the instance name.  
id_domain is the id of the identity domain. In above “jcsdemo0117” is the identity domain.
Container is the name of the container. You have to create container inside storage using curl tool. For this example I have created a container called “fpsoadbbkp“. Please refer Using Oracle Storage Cloud Service E37261-14 guide for how to create container.  
So, final value for this example was – “Storage-jcsdemo0117/fpsoadbbkp”
Cloud Storage User Name
Enter the user name of a user who has read/write access to the container specified in Cloud Storage Container.
Cloud Storage Password
Enter the password of the user specified in Cloud Storage User Name.


Verify all the configuration and input provided by you


Request will be submitted and will take a while to provision database. In my case it took approx. 1 hr time. There is no progress monitor sort of thing available wherein you can see how much time left, how much time required etc. You just need to wait and refresh the screen and verify the status.


Once done in progress status for that dB instance will be changed and you would be able to see something like this-

Step 10:

Start the DB by click on DB name and select “start” from under “Manage db node”


Enable multiple ports to access this db. Below are various ports been configured but disable by default. In order to access EM console and other console you need to access all the required ports. Please go through below link to get more details.

ora_p2_dbconsole, which controls access to port 1158, the port used by Enterprise Manager 11g Database Control.
ora_p2_dbexpress, which controls access to port 5500, the port used by Enterprise Manager Database Express 12c.
ora_p2_dblistener, which controls access to port 1521, the port used by SQL*Net.
ora_p2_http, which controls access to port 80, the port used for HTTP connections to the instance.
ora_p2_httpadmin, which controls access to port 4848, the port used by the Oracle GlassFish Server administration console.
ora_p2_httpssl, which controls access to port 443, the port used for HTTPS connections to the instance, including Oracle REST Data Services, Oracle Application Express, and the Oracle Cloud on-instance database monitor.

Go the “Oracle compute cloud service” and then “Network”, find out your newly DB instance rules using find and enable them as per your requirement.


Access the DBaaS Monitor console and EM console
Use the password which you gave while provisioning db. User name would be “dbaas_monitor”


Access Database Express 12c Console and provide user name “SYS” and password which you gave during database cloud service provisioning.


No comments:

Post a Comment