When creating a new database deployment on Oracle Database Cloud Service, you have option to choose whether you want to configure automatic backup or not. The options are as follows:

Both Cloud Storage and Local Storage

30 days worth of backups are kept and the 7 most recent days worth available directly on the compute node’s local storage.

Cloud Storage Only

30 days worth of backups are kept with all backups on cloud storage container.

None

No automatic Backup are configured

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

Prerequisites:

Oracle Account
Oracle Cloud Subscription
SSH Public/Private Key pair
Oracle Storage REST Endpoint

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

Get the REST Endpoint by connecting to Container Classic. This REST Endpoint will be used when creating the Database Deployment.

Open the Service Console from the Database Server as show below

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

Once the information is filled, Click Next.

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

Once the information is filled, Click Next.

Review the Summary and click “Create”

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

This page shows that the provisioning is in-progress. Click on Oracle Database Cloud Services to go back to the home page

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

Connect to the Compute node and verify the database.

Conclusion

In this article we have learned how to create a database deployment and configure automatic backups in Oracle Database Cloud Service.

Step 4 – Oracle DBCS : Customize Dashboard

By Netsoftmate on

December 28, 2017

- Uncategorized

In our previous article we have learned how to Create a Database Deployment using Create Service Wizard. Let’s assume that you have created multiple services on Oracle Cloud and want to manage the services on the Dashboard so you just display services you want. You can use “Customize Dashboard” option on the “Oracle Cloud My Services” page to specify which services appear on the dashboard.

In this article we will demonstrate how to Customize Dashboard on Oracle Cloud My Services page.

Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

https://myservices-xxxxx-xxxxxxxxxxef4b21bb7ee3b2cf4123d1.console.oraclecloud.com/mycloud/faces/dashboard.jspx

Enter your username and password

On the home page click on “Customize Dashboard” as shown below

A pop box will be opened showing all the services. You will see the following options:

Automatic: This is the system default
Expand: Show service details
Collapse: Hide service details
Show: It will always show service on the dashboard
Hide: It will always hide service from the dashboard

Here I want to show the following services on my dashboard:

Identity Cloud
Database
Database Backup
Storage Classic
Compute Classic
Container Classic

Once you are done with the selection, click the close icon to close the “Customize Dashboard” menu

Now we can see all the services which we have choose to show/display on the dashboard

Conclusion

In this article we have learned how to Customize the Dashboard on Oracle Cloud My Services page. You can specify which Cloud Services should appear on the dashboard so it is easy for you to switch between the Cloud Services.

Step 3 – Oracle DBCS : Create A Database Deployment

By Netsoftmate on

December 27, 2017

- Uncategorized

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.

Prerequisites:

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

http://netsoftmate.blogspot.com/2017/12/step-2-oracle-dbcs-generate-ssh-key.html

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

This page shows that the provisioning is in-progress. Click on Oracle Database Cloud Services to go back to the home page

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

Conclusion

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.

Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!

Home

About

Services

Blog

Contact

Oracle DBCS : Create A Database Deployment With Automatic Backup

Step 3 – Oracle DBCS : Create A Database Deployment

ABOUT US

Services

CONTACT US

Follow Us!