Oracle DBCS : Create Virtual Image Database Deployment - Part 1

When you create an Oracle Database Cloud Service - Virtual Image Database Deployment, the following tasks are completed for you:

• Compute Allocated
• Storage Allocated
• Virtual Machine Image Installed
• Included software to create Oracle Database

You are responsible for Connecting to VM, create Database, perform maintenance operations such as Backup , Patching and Upgrade.

Note that Oracle Database 12c Release 2 (12.2) is not available for Oracle Database Cloud Service - Virtual Image service level.

When you create a database deployment on Oracle Database Cloud Service using the Virtual Image service level, Oracle Database software is not automatically installed and no database is created. You must perform these steps manually after the deployment is created.

To create a database on a Virtual Image Database Deployment, you perform these tasks:

1. Create Virtual Image Database Deployment service level
2. Create storage volumes for the Oracle Database software and for the database files, and then format and mount them
3. Stage the Oracle Database software on the mount point you created for it
4. Create a database and start the database instance
5. Start the listener for the database instance

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

Prerequisites

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

Steps to Create Virtual Image Database Deployment

• 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 "Menu" under "Database" Cloud Service as shown below

• Click "Open Service 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 or 12cR1
• 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

• Select Compute Shape (CPU and Memory for your deployment). Click "Edit" beside "SSH Public Key" box

• Click on the radio button and click browse

• Select the Public Key from your desktop/laptop

• Click Enter button

• Click Next

• Review the details for deployment and click "Create"

• We can see that the deployment is being created. Click on the Instance name "NSM-DBaaS-VM"

• The status shows "Creating Service..."

• We can see that the status is "Ready"

• Virtual Image Database Deployment "NSM-DBaaS-VM" is now ready.

• You will also receive a confirmation email whent the service is created

• Enter the IP address of the Compute Node

• On the left pane, expand "SSH" and select "Auth". On the right pane, click on "Browse" button. Select the Private Key that matches the Public Key for your Deployment. Click "Open"

• Click Yes

• Login as opc user, switch to root user, Switch to Oracle user and check if any database instance is running. With Virtual image database deployment database is not created by default

• Check the file systems. We can see that no users files systems are created. You need to allocate extra storage and create the users file systems.

Conclusion

In this article we have learned how to Create Virtual Image Database Deployment using Create Service Wizard. When you create an Oracle Database Cloud Service - Virtual Image Database Deployment, Compute Allocated, Storage Allocated Virtual Machine Image Installed and Included software to create Oracle Database. You are responsible for Connecting to VM, create Database, perform maintenance operations such as Backup , Patching and Upgrade.

Oracle DBCS : Restart An Oracle Database Cloud Service Database Deployment

You made some configuration changes to the Oracle Cloud Compute Node and it requires a restart/reboot take affect.

In this article we will demonstrate how to restart a Database Cloud Service Database Deployment.

Steps to Restart a Database Cloud Service Database Deployment.

Method 1:

• 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

• On the home page, Click "Menu" under "Database" Cloud Service as shown below

• Click "Open Service Console"

• On the this page, Click "Menu" as shown

• Click "Restart" from the list

• Click "OK" to confirm

• A message displays that the restart request is accepted. Click on Instance name "NSM-DBaaS"

• We can see that the status has changed to "Service Maintenance.."

• We can now see that the status has changed to Ready". This completed the restart process

Method 2

• Open PuTTY session on your desktop and enter Compute Node IP address

• On the left pane, expand "SSH" and select "Auth". On the right pane, click on "Browse" button. Select the Private Key that matches the Public Key for your Deployment. Click "Open"

• Login as opc user, switch to root user, check uptime and issue reboot command.

Wait for few minutes and execute steps 1 and 2 above.

• Login as opc user, switch to root user, check uptime and Verify the databsae and listener status

• Switch to oracle user and start the databsae if it not started already

• Verify the database status. This completed the restart process

Conclusion

In this article we have learned how to restart a Database Cloud Service Database Deployment.

Oracle DBCS : Start An Oracle Database Cloud Service Database Deployment

You want to start a Database Cloud Service Database Deployment after completing your maintenance work. When you start a database deployment, you can access it again and can perform any management operations.

Starting a database deployment is very simple and it is similar to powering on a computer or laptop. 

When database deployment is started, its CPU and RAM are allocated. As a result, it consumes OCPU and memory resources and so metering and billing of these resources are started.

In this article we will demonstrate how to start a Database Cloud Service Database Deployment.

Steps to Start a Database Cloud Service 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

• On the home page, Click "Menu" under "Database" Cloud Service as shown below

• Click "Open Service Console"

• On the this page, Click "Menu" as shown

• Click "Start" from the list

• Click "OK" to confirm

• A message displays that the start request is accepted

• We can see that the status has changed to "Service Maintenance". Click on Instance name "NSM-DBaaS"

• We can see that the status is still under "Service Maintenance.."

• We can now see that the status has changed to Ready"

Login to the Oracle Cloud Compute Node to verify that the server is not accessible.

• Open PuTTY session on your desktop and enter Compute Node IP address

• On the left pane, expand "SSH" and select "Auth". On the right pane, click on "Browse" button. Select the Private Key that matches the Public Key for your Deployment. Click "Open"

• Login as opc user, check uptime and verify the database status

Conclusion

In this article we have learned how to start a Database Cloud Service Database Deployment. Starting a database deployment is very simple and it is similar to powering on a computer or laptop. When database deployment is started, its CPU and RAM are allocated. As a result, it consumes OCPU and memory resources and so metering and billing of these resources are started.