Wednesday, 27 December 2017

Step 3 - Oracle DBCS : Create A Database Deployment

There are several ways in which you can create a Database Deployment in Oracle Database Cloud Service. Some of the methods that you can use to create a Database Deployment are:

  • QuickStart Template
  • Create Service Wizard
  • Using Snapshot
  • Hybrid Disaster Recovery (DR) Deployment

In this article we will demonstrate how to Create A Database Deployment using Create Service Wizard.


  • Oracle Account
  • Oracle Cloud Subscription
  • SSH Public/Private Key pair

Steps to Create a Database Deployment

  • Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account
  • Enter your username and password

  • Click on the Menu as shown in the image below

  • Click on Database (OCI)

  • Click on "Go to Console"

  • Click on "Create Service"

  • Fill in all the details and click Next
    • Service Name: Enter the service name, It only accepts hyphen (-) as special character
    • Description (optional): Enter a description on the service
    • Notification Email: To send the update on Instance creation
    • Service level: Oracle Database Cloud Service
    • Metering Frequency: Monthly or Hourly
    • Software Release: 11gR2, 12cR1 or 12cR2
    • Software Edition: Enterprise, standard, Enterprise Edition - Extreme performance or Enterprise Edition - High performance
    • Database Type: Single Instance, Single Instance with Data Guard, RAC, RAC with Data Guard, Hybrid DR

  • Fill in all the details 
    • DB Name: This will be your container DB name
    • PDB Name: This will be your pluggable DB name
    • Administrator password: This will be your administrator password for users sys, system, dbaas_monitor and so on
    • Backup and Recovery Configuration: Cloud and Local, Cloud only or None
    • Compute Shape: select the configuration you need for your business
    • SSH Public Key: choose the public key you generated in steps
    • Click on advance settings and choose your desired option

Steps to upload public key

  • Click Next

  • Review the Summary and click "Create"

  • At this moment the Service creation is in progress. Click on the Service Name

  • Click on the arrow symbol shown below to see the service create and delete history

  • Click refresh to check the status of service

  • The service has been created successfully

  • Up on the completion you will also receive the email that the service is created and is now available for use

  • Click on the arrow symbol and "show more" to see all the details about the service just created

  • Make a note of the IP address as it will used to connect to the compute node


In this article we have learned how to Create a Database Deployment on Oracle Database Cloud Service using Create Service Wizard. There are several ways in which you can create a Database Deployment, using the QuickStart template is the fastest and the easiest method to create a Database Deployment.

1 comment:

Deploy Exadata Database Machine On Oracle Cloud Infrastructure

In this article we will demonstrate a quick steps to deploy Exadata Database Machine in Oracle Cloud Infrastructure (OCI). Prerequisites:...