Oracle DBaaS 1z0-160 part 6:Creating you first single instance database in Oracle cloud

1.You will get following dashboard once you login to oracle cloud

2.Please select Database option as below

3.Please select option “Custom”

4.Please provide below details

4.a Instance Name:-

The name for the new database deployment. The name:

  • Must not exceed 50 characters.
  • Must start with a letter.
  • Must contain only letters, numbers, or hyphens.
  • Must not contain any other special characters.
  • Must be unique within the identity domain.
4.b Region:-

(Available only if your identity domain is enabled for regions.)

If you choose a region that supports Oracle Cloud Infrastructure, the Availability Domain and Subnet fields are displayed, and the deployment will be created on Oracle Cloud Infrastructure. Otherwise, the deployment will be created on Oracle Cloud Infrastructure Classic. Choose No Preference to let Database Cloud Service choose an Oracle Cloud Infrastructure Classic region for you.

Note: If you are creating a database deployment that uses Oracle Data Guard on Oracle Cloud Infrastructure Classic, choose the value No Preference. Currently, region specification is not supported for deployments that use Oracle Data Guard on Oracle Cloud Infrastructure Classic.

4.c Availability Domain

(Available only on Oracle Cloud Infrastructure) The availability domain (within the region) where the database deployment will be placed.

4.d Subnet

(Available only on Oracle Cloud Infrastructure) The subnet (within the availability domain) that will determine network access to the database deployment.

4.e Service level

The service level for the new deployment:

Oracle Database Cloud Service

Oracle Database Cloud Service – Virtual Image (Not available in accounts that use the Universal Credits payment model) (Not available on Oracle Cloud



Select the IP network where you want the database deployment placed.


No Preference  to use the default

shared network provided by Oracle Cloud Infrastructure Compute Classic.


Currently, the following limitations apply to IP networks:

  • Only database deployments hosting a single-instance database support IP networks.
  • Database deployments that use Oracle Data Guard do not support IP networks.
  • Database deployments that use Oracle RAC do not support IP networks.


5.Now please generate public key and private key using puttygen (Puttygen will be installed automatically if you install putty)

SSH is a cryptographic network protocol that uses two keys, one public and one private, to provide secure communication between two networked computers. Port 22 is the standard TCP/IP port that is assigned to SSH servers, and on Database Cloud Service instances this port is accessible to external clients by default.

When creating a database deployment, you specify the public key on the Service page of the Create Instance wizard by:

  • Uploading a public key file. You can specify a file on your local system that contains the public key value.
  • Pasting the public key value. You can paste the public key value into a box provided by the wizard. If you do so, make sure the value does not contain line breaks or end with a line break.
  • Having the wizard generate a key pair for you. You can have the wizard create an SSH key pair and use the generated public key value. You download a zip file containing both the public key file and the private key file.

When you access a compute node using SSH, you must provide the private key that matches the public key specified when the database deployment was created.

Puttygen is required to generate public and private key which is required next section to enable SSH access.After that you need to click “Generate” button and move mouse cursor frequently to generate randomness.

You need to provide public key during next section of database creation so that public key will be saved in DB server.You need to keep private key secretly.Please save the public key in notepad.

Please save public key

6.Go to next screen and provide other details as well as public key which we generated previous step.

6.a Storage Consideration

During creation of database deployment you choose the usable amount of data storage increment upto maximum 2TB.You may add space after creation of instance too.

By adding more space you can increase storage upto 4.6 TB with local backup and 12 TB without local backup.7.6 TB for deployment hosting for oracle RAC database backup.

Scaling up storage is responsibility for CLoud Dabatase Admin.

6.b Backup Destination

Controls how backups for the deployment are to be configured:

Both Cloud Storage and Local Storage

—backups are

configured to be created automatically and stored both on local storage and on cloud storage.If this choice is selected, the Cloud Storage Container,User Name and Password fields are displayed.

Cloud Storage Only

— backups are configured to be

created automatically and stored on cloud storage.If this choice is selected, the Cloud Storage Container,User Name and Password fields are displayed.


This choice is not currently available for database deployments that use Oracle Real Application Clusters(Oracle RAC).


—Backups are not configured for the deployment.

7.Please check all details before proceed to database creation.

8.Once you press create button,your instace is being created now

9.Once instance created,you will get confirmation mail.

10.Please check Activity tab for details about instance creation




About the Author

debasis maity

12+ years of rich experience on Database Administrations and on Infrastructure Solution Architect. AWS Certified Solution Architect and Senior Oracle DBA

Leave a Reply

Your email address will not be published. Required fields are marked *