Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!
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.

0


In previous articles Oracle DBCS: Create Virtual Image Database Deployment series we have learned how to:

Oracle DBCS : Create Virtual Image Database Deployment – Part 1
https://netsoftmate.blogspot.in/2018/02/oracle-dbcs-create-virtual-image-database-deployment.html

Oracle DBCS : Create Virtual Image Database Deployment – Part 2
https://netsoftmate.blogspot.in/2018/03/oracle-dbcs-create-virtual-image-database-deployment-part2.html

Oracle DBCS : Create Virtual Image Database Deployment – Part 3
https://netsoftmate.blogspot.in/2018/03/oracle-dbcs-create-virtual-image-database-deployment-part3.html

In this article we will learn the final step on how to Create a Database in Virtual Image Database Deployment.

Prerequisites

  • Create Virtual Image Database Deployment
  • Create Storage Volumes for Oracle Database Software and Database Files
  • Install Oracle Database Software

Step to Create a Database in Virtual Image Database Deployment:

  • Get the IP address of the Compute node you want to connect from Oracle Database Cloud Service Console. Here my Deployment Service Name is “NSM-DBaaS-VM” and the IP address is 144.21.72.128

  • 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”

  • Enter login as “opc” user. You will be connected without prompting for the password. Switch to the “root” user and “oracle user”. Verify no database is running currently.

  • Login as oracle user and set Oracle Home, Oracle Base and PATH variable. Make sure Oracle Executable dbca is set in PATH correctly.

  • Start dbca in silent mode by providing the values on the command line as shown below:

  • Connect to the database and verify the status



Conclusion

In this article we have learned how to create a database in Virtual Image Database Deployment.
0


In previous articles we have learned how to create Virtual Image deployment and Scale Up Storage Using Oracle Database Cloud Service and Create one storage volume for the Oracle Database software and one storage volume for all database files, and prepare them for use. 

Oracle DBCS : Create Virtual Image Database Deployment – Part 1
https://netsoftmate.blogspot.in/2018/02/oracle-dbcs-create-virtual-image-database-deployment.html

Oracle DBCS : Create Virtual Image Database Deployment – Part 2


https://netsoftmate.blogspot.in/2018/03/oracle-dbcs-create-virtual-image-database-deployment-part2.html

In this article we will learn how to Install Oracle Database Software

Prerequisites

  • Create Virtual Image Database Deployment
  • Create Storage Volumes for Oracle Database Software and Database Files

Steps to Install Oracle Database Software in Virtual Image Database Deployment.

  • Get the IP address of the Compute node you want to connect from Oracle Database Cloud Service Console. Here my Deployment Service Name is “NSM-DBaaS-VM” and the IP address is 144.21.72.128

  • 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”

  • Enter login as “opc” user. You will be connected without prompting for the password. Switch to the “root” user and “oracle user”

  • Login as oracle user, switch directory to /u01 and look for the zip file containing the Oracle Database software by displaying the contents of the /scratch/db directory. Extract the zip file into the current directory /u01

  • Ensure that the Oracle software is extracted correctly

  • Switch to root user and execute the set-up scripts as follows. Exit the session


Conclusion



In this article we have learned how to Install Oracle Database Software on a Virtual Image Database Deployment. Installing Oracle Software in VM Image deployment is very easy, you just need to locate the correct Oracle Software version and extract them in the correct directory.
0

In previous article “Oracle DBCS : Create Virtual Image Database Deployment – Part 1” we have learned how to Create Virtual Image Database Deployment using Create Service Wizard.
https://netsoftmate.blogspot.in/2018/02/oracle-dbcs-create-virtual-image-database-deployment.html

In this article we will Scale Up Storage Using Oracle Database Cloud Service and Create one storage volume for the Oracle Database software and one storage volume for all database files, and prepare them for use. This will be the part 2 and continuation of the previous article.


Prerequisites
Create Virtual Image Database Deployment


Steps to Scale up Storage using Oracle Database Cloud Service Console in 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”


  • Currently the Storage is 32GB. Let’s Scale Up the Storage. Click on the Instance Name


  • Click on the “Menu” icon and Select “Scale Up/Down”

  • I am adding addition 30GB storage. Click “Yes, Scale Up/Down Service”Here I am adding addition 30GB storage. Click “Yes, Scale Up/Down Service”


  • A message printed on the screen “Service scale up/down request is accepted”. The Instance status changed to “Service Maintenance”


  • After sometime we can see that the Storage is now Scale up to 62GB. Click on Instance to add more Storage


  • Click on the “Menu” icon and Select “Scale Up/Down”


  • This time I am adding addition 50GB storage. Click “Yes, Scale Up/Down Service”


  • A message printed on the screen “Service scale up/down request is accepted”. The Instance status changed to “Service Maintenance”


  • After sometime we can see that the Storage is now Scale up to 112GB.


  • Get the IP address of the Compute node you want to connect from Oracle Database Cloud Service Console. Here my Deployment Service Name is “NSM-DBaaS-VM” and the IP address is 144.21.72.128


  • 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”


  • Enter login as “opc” user. You will be connected without prompting for the password. Switch to the “root” user


  • Display the list of block devices, the two volumes created are xvdc and xvdd


  • First format the volume for the Oracle Database software and mount it as /u01 as shown below




  • Now format the volume for the database files, and mount it as /u02 as shown below




  • Verify the mount points and display the block devices


  • Update the /etc/fstab file so new mount points get mounted automatically whenever the VM is rebooted



Conclusion

In this article we have learned how to Scale Up Storage using Oracle Database Cloud Service console and create storage volumes for Oracle Database Software and Database files.

0

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.
2

In the previous article we have demonstrated how to connect to Oracle Database in Oracle Cloud using Oracle SQL Developer when the Oracle Net Listener port 1521 was enabled.

Let’s assume that you DO NOT want to enable the Oracle Net Listener port 1521 for security reasons. In that case you can create an SSH tunnel to port 1521 on the compute node associated with Oracle Database Cloud Service. Then you can use SSH client software that supports tunneling. Oracle SQL Developer supports SSH and it can used to create an SSH tunnel to port 1521 on the compute node if you don’t want to enable port 1521 explicitly.

In this article we will demonstrate how to connect to Oracle Oracle Database in Oracle Cloud using SQL Developer and SSH Tunneling.

Prerequisites

  • IP address of Compute node
  • Database Service name
  • Database username and password to connect to the database
  • Download and unzip SQL Developer software. Use the below link to download latest SQL Developer software
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Steps to connect to Oracle Database in Cloud using Oracle SQL Developer and SSH Tunneling


  • From the below screen shot we can see that SSH port 22 is enabled and Oracle Net Listener port 1521 is disabled


  • Open Oracle SQL Developer on your Desktop/Laptop and Click the Add button


  • Fill in all the details, Connection name, username, password, Host name, Service Name


  • Click “Test” button. As the port 1521 is disabled we can’t connect to the Oracle Database. 
We should use SSH tunneling to establish a successful database connection


  • From  SQL Developer Click “View” menu and select SSH


  • On the left pane, click on SSH host and select “New SSH Host”


  • Fill in all the details, and click OK
Name: Any name of your choice
Host: IP address of Compute node
Username: opc or oracle
Use Key file: Select the private key from your desktop/laptop that matches the Public Key for your Deployment
Name: Any name of your choice
Host: localhost
Port: 1521 used by SQL*Net



  • Now Open Oracle SQL Developer on your Desktop/Laptop and Click the Add button, Fill in all the details, Connection name, username, password, Host name, Service Name and click Test button. We can now see that he Status is Successful. Click connect


  • Execute some SQL Statement to ensure you can fetch the data from database


  • From  SQL Developer Click “View” menu select DBA to display DBA menu on left pane of SQL Developer


  • Under DBA menu click Add button to add database connection. Select a Connection and click OK


  • Navigate to DBA Menu, select your database connection to explore database configuration, status, other DBA options

Conclusion

In this article we have learned how to connect to Oracle Database in Oracle Cloud using Oracle SQL Developer remotely when port 1521 is disabled for security reason. You can create an SSH tunnel to port 1521 on the compute node associated with Oracle Database Cloud Service. Then you can use SSH client software that supports tunneling. Oracle SQL Developer supports SSH and it can used to create an SSH tunnel to port 1521 on the compute node if you don’t want to enable port 1521 explicitly.


0

You can connect to the Oracle database in Oracle Cloud using Oracle SQL Developer or similar tool to perform the database operations as you would similar to an on-premises databases. When you create a Database Cloud Service database deployment on Oracle Cloud, by default the Oracle Net Listener port 1521 is Disabled to ensure network security. Use the Oracle Database Cloud Service console to enable access to port 1521 on a compute node to make a SQL Developer connection to the Oracle Database.

Note: If you DO NOT want to open the Oracle Net Listener port 1521 for security reasons, you can create an SSH tunnel to port 1521 on the compute node associated with Oracle Database Cloud Service. Then you can use SSH client software that supports tunneling. Oracle SQL Developer supports SSH and it can used to create an SSH tunnel to port 1521 on the compute node if you don’t want to enable port 1521 explicitly.

In this article we will demonstrate how to connect to Oracle Database in Cloud using Oracle SQL Developer Remotely

This article assumes that Oracle Net Listener port 1521 is enabled. To enable port 1521, follow the steps outline at:
http://netsoftmate.blogspot.in/2018/01/step-6-oracle-dbcs-enable-access-to.html

Prerequisites
  • IP address of Compute node
  • Enable port 1521 – This port is used by SQL*Net
  • Database Service name
  • Database username and password to connect to the database
  • Download and unzip SQL Developer software. Use the below link to download latest SQL Developer software
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Steps to connect to Oracle Database in Cloud using Oracle SQL Developer


  • 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 Service Name. In my case “NSM-DBaaS” is the service name


  • Hover mouse on the “Connect String”, it will pop up the complete Connect String. Copy the Service Name as shown below


  • You can also get the service name of you Container DB and Pluggable DB using “lsnrctl status” Command as shown below


  • Open Oracle SQL Developer on your Desktop/Laptop and Click the Add button


  • Fill in all the details, Connection name, username, password, Host name, Service Name


  • Click “Test” button and make sure the Status is Success


  • Execute some SQL Statement to ensure you can fetch the data from database


  • From  SQL Developer Click “View” menu select DBA to display DBA menu on left pane of SQL Developer


  • Under DBA menu click Add button to add database connection


  • Select a Connection and click OK


  • Navigate to DBA Menu, select your database connection to explore database configuration, status, other DBA options

Conclusion

In this article we have learned how to connect to Oracle Database in Oracle Cloud using Oracle SQL Developer remotely. You can connect to the Oracle database in Oracle Cloud using Oracle SQL Developer or similar tool to perform the database operations as you would similar to an on-premises databases. Oracle Net Listener port 1521 should be enabled on the compute node to make a SQL Developer connection to the Oracle Database.

0

Oracle Database Cloud Service uses access rules to provide secure network access to database deployments. You can use the Oracle Database Cloud Service console to perform network access operations such as enabling and disabling access rules and creating new access rules. 

Network access to the compute nodes associated with Oracle Database Cloud Service is primarily provided by SSH connections on port 22. When you access a compute node using SSH, you must provide the private key that matches the public key associated with database deployment. To access other network protocols and services may require additional configuration.

The following rules are created when a database deployment is created. They are set to disabled by default:

  • ora_p2_ssh: Controls access to port 22 and this port is used by SSH client to connect to the compute node. 
  • ora_p2_dbconsole: Controls access to port 1158 and this port is used by Enterprise Manager 11g Database Control.
  • ora_p2_dbexpress: Controls access to port 5500 and this port is used by Enterprise Manager Database Express 12c.
  • ora_p2_dblistener: Controls access to port 1521 and this port is used by SQL*Net.
  • ora_p2_http: Controls access to port 80 and this port is used for HTTP connections.
  • ora_p2_httpssl: Controls access to port 443 and this port is used for HTTPS connections, including Oracle REST Data Services (ORDS), Oracle Application Express (APEX), and Oracle DBaaS Monitor.

To access network protocols and services on a compute node by using a port other than port 22, require additional configuration:
  • Enable network access to the port: Use the Oracle Database Cloud Service console to enable access to a port on a compute node
  • Create an SSH tunnel to the port: Create SSH tunnel enables you to access a specific compute node port by using an SSH connection as the transport mechanism

    In this article we will demonstrate how to Enable Access to a Compute Node Port other than port 22 using Oracle Database Cloud Service console.


    Prerequisites
    • Access to Oracle Database Cloud Service console

    Steps to Enable Ports using Oracle Database Cloud Service Console

    • 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 Service Name. In my case “NSM-DBaaS” is the service name

      • Click on “Menu” and select “Access Rules”

      • By default only port 22 is enabled and all other ports are disabled for security reasons

      • To enable a port click on “Menu” and select “Enable”. Here I am opening port 1521 used by SQL*Net access

      • Click “Enable”



      • We can see the port 1521 is now enabled

      • Similarly open port 443 used by HTTPS connection as shown below


      • Port 443 is now Enabled

      • Enable port 5500 used by EM Express


      • Port 5500 is now Enabled



      Conclusion


      In this article we have learned how to Enable Access to a Compute Node Port other than port 22 using Oracle Database Cloud Service console. Oracle Database Cloud Service uses access rules to provide secure network access to database deployments. You can use the Oracle Database Cloud Service console to perform network access operations such as enabling and disabling access rules and creating new access rules. 


      0

      When you create a database deployment in Oracle Database Cloud Service, the following tasks are completed for you:
      • Compute Node Allocated
      • Storage Allocated
      • Virtual Machine Image Installed
      • Set Keys and Privileges
      • Install and Configure Database
      • Configure Backup
      • Configure Tools
      • Configure Access

      Network access to the Compute Node associated with Oracle Database Cloud Service is primarily provided by SSH connections on port 22. By default SSH port 22 is opened to allow access to the tools, utilities and other resources on the Compute Node associated with the Oracle Database Cloud Services. You can use SSH client software such as PuTTY on Windows to establish a secure connection and log in as “opc” or “oracle” user.

      In this article we will demonstrate how to connect to Compute Node associated with Oracle Database Cloud Service.

      Prerequisites
      • IP address of Compute Node
      • SSH Private Key file that matches the Public Key associated with the deployment
      • PuTTY software


      Steps to connect to Oracle Database Cloud Compute Node using PuTTY on Windows Operating System

      • Get the IP address of the Compute node you want to connect from Oracle Database Cloud Service Console. Here my Deployment Service Name is “NSM-DBaaS” and the IP address is 144.21.72.104

      • Open the PuTTY software your desktop or laptop. Start > All Programs > PuTTy (64 bit) > PuTTY

      • 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



      • On the left pane, select “Session” and Click “Open”

      • Click “Yes”

      • Enter login as “opc” user. You will be connected without prompting for the password

      • Switch to the “oracle” user and verify the database status

      • There is one Container Database with1 user Pluggable database and both are in Read Write state.


      Conclusion

      In this article we have learned how to connected to the Oracle Database Cloud Service Compute Node. By default the SSH port 22 is opened to allow access to the compute node. You will use the IP address of the compute node of your deployment to connect it.


      0

      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.


      0

      PREVIOUS POSTSPage 1 of 2NO NEW POSTS