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

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


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


1

Oracle Database Cloud Service or simply DBCS or DBaaS is built on top of Infrastructure that is provided by Oracle Compute Cloud Service. When you create a service instance (Database Deployment for Example), all the Oracle Compute virtual machines (VMs) required to support the Database Services are provisioned and configured for you.

You can use SSH (Secure Shell) to access the service Instance (Database VM or Database Compute node) provided by Oracle Compute Virtual Machines (VMs). Before you can access the VM, you need an SSH public/private key pair for the VM. You will need the public key when creating a service instance, and you will need the paired private key when you access it using an SSH utility.


In this article we will demonstrate how to generate or create the public/private Key Pair.


Prerequisites:

  • Oracle Cloud Subscription
  • Ready to Create an oracle Cloud Service Instance (Database Deployment for Example)
  • PuTTY


Steps to Generate SSH Key Pair on Windows using PuTTYgen utility


  • Download and Install Putty Installation package for Windows
https://www.ssh.com/ssh/putty/download

  • Start PuTTYgen program on your Windows Desktop/Laptop

Start > All Programs > PuTTY (64 bit) > PuTTYgen

  • On PuTTYgen screen do the following:
    • Type of key to generate: Default RSA or SSH-2 RSA
    • Number of bits in a generated key: 2048
    • Click generate button

  • Move the mouse around the blank area below the process bar to generate randomness to the key.

  • The Public Key generated displayed in the Key are. The key comment is the name of the key that you will use to identify it. Enter a Key passphrase and enter it again for Confirm passphrase to password-protect your key.

Note: Key passphrase is optional, but it is recommended to provide key passphrase as a security measure to protect the private key from unauthorized use.


  • Click “Save private key” and click Yes to continue without a key passphrase.


  • On the PuTTY Key Generate screen, select all of the characters under “Public key for pasting into OpenSSH authorized_keys file” and copy it

  • Open a text editor (example: Notepad++) and paste the characters, copied in previous step. 

Note: Ensure all characters are copied from first character in the text editor and there is no line breaks.

  • Save the key as a text file and add a .pub extension. while you can give it any extension you want, but .pub is a useful convention to indicate that this is a public key.

  • Make a note of the public and private key name and the location.

Note: You will need the public key when creating service instances (Database Deployment for Example) and You will need the private key when accessing virtual machine via SSH.




Conclusion


In this article we have learned how to generate SSH Key pair on Windows using PuTTYgen utility. You need the SSH key pair when you are ready to create the an Cloud Service Instance (Database Deployment for Example) and to access the service Instance (Database VM or Database Compute node). You will need the public key when creating a service instance, and you will need the paired private key when you access it using an SSH utility.

2

Before you create service instance (Database Deployment for example) on Oracle Cloud, you must subscribe to Oracle Cloud Services. Once you subscribe to an entitlement to create instance of an Oracle Cloud Service, then you can create multiple service instances based on your Business requirement.

Subscribing to an Oracle Cloud Service consists of following 3 steps:
  • Order One of the subscription type
  • A free trail subscription to an Oracle Cloud Service
  • A paid subscription
  • Activate the Service
  • Verify the Service is running

Note: Free Oracle Cloud Promotion Applicable to only:

  • Oracle Database Public Cloud Services
  • Oracle Analytics Public Cloud Services
  • Oracle Big Data Public Cloud Services
  • Oracle IaaS Public Cloud Services
  • Oracle Middleware Public Cloud Services

Prerequisites:
  • Oracle Account

In this article we will demonstrate the steps for a free trail subscription to an Oracle Cloud Service.


  • Open a web browser and enter the following URL
http://shop.oracle.com

or

http://cloud.oracle.com

For India choose http://shop.oracle.com


  • Change the country and Language

  • Login using your Oracle account

  • Click on “View Details”

  • Click on “View details”

  • Click on “Get started for free”

  • Choose your country code, Enter mobile number to receive “verification code” and click “Request Code”. Enter the Verification code received on your mobile and click “Verify”

  • Enter the Account details

  • If you are an individual select “Tax information is not available”

  • Click “Add Payment Method” and uncheck “Convert my account to Pay as You Go” to avoid charging your credit card at the end of free subscription

  • Enter “Billing Information”

  • Enter “Payment Details”

  • Verify card details and uncheck “Convert my account to Pay as You Go” to avoid charging your credit card at the end of free subscription

  • Accept “Terms and Conditions” and Click “Complete”

  • You will see the following Message on your screen


  • At this time you will receive 2 email as show below. It may take upto 24 hours to receive the the second email

  • Email 1, You will receive the following email with the Order Number

  • Email 2, Click on “Activate My Services” to activate your Oracle Cloud Services

  • Enter the “Cloud Account Name” and “Email Address”

  • Enter “First Name” and “Last Name” and Click “Create Account”. Your email ID will be your Username 

  • Click Close

  • You will receive an email with the following details:
    • Free Credits
    • Access Details: Username, Initial Password, Cloud Account name
    • My Service Administration: Use the link provided to sign in to your Oracle Cloud Account and start using Cloud Services.
    • Order Details



  • Open a web browser and enter the URL you received in the Welcome email with access details

  • Enter username and Intial password received in Welcome email with access details

  • Change the password and ensure you set a strong password 

  • Set Preferences

  • Once you login, Oracle Cloud My Services Home Page is displayed


Conclusion

In this article we have learned how to subscribe to Oracle Cloud Services (Free trail). Once you subscribe to an entitlement to create instance of an Oracle Cloud Service, then you can create multiple service instances based on your Business requirement.
2

To start using Oracle Database Cloud Service, follow the guidelines as below:

  • Sign up for a free credit promotion or purchase a subscription
Fill in your information, and sign up for a free credit promotion or purchase a subscription to Oracle Database Cloud Service.

  • Add and manage users and roles
Create user accounts and assign them appropriate privileges and assign the necessary Database Cloud Service roles.

  • Create a database deployment
Use create service wizard (GUI interface) to create a new database deployment.

  • Enable network access
Allow access to network services associated with your database deployments.

  • Load data into the database
Use Oracle Database tools to load data into your databases.

  • Monitor database deployments
Checkout health and performance of individual database deployments.

  • Monitor the service
Check on the day-to-day operation of your service, monitor performance, and review important notifications.

  • Patch a database deployment
Apply or Rollback a patch

  • Back up a database deployment
Perform database backup and restore


Illustration


Conclusion

In this article we have seen Typical Workflow of an Oracle Database Cloud Service. It is very easy to start a subscription, create a database deployment and perform several other tasks listed in the Workflow.

1

Oracle uses simple and most efficient Storage Volumes and File System Layout in Oracle Database Cloud Service (DBCS) for the ease of use and management.

Let’s take a look at the Oracle Database Cloud Services Storage Volume and File System Layout in more details.

When you create a database deployment, Oracle Database Cloud Services (DBCS) creates the following Storage Layout and File Systems for you.

Storage Volumes

Storage Volume
Description
bits
60 GB volume completely allocated to /u01 on the virtual machine.
boot
32 GB volume allocated to the following file system mounts on the virtual machine:
  • / (root)
  • /boot
  • swap space

data
GB size equal to the value provided in the Usable Data Storage field during the database deployment creation process, with a minimum of 15 GB. This volume is completely allocated to /u02 on the virtual machine.
fra
GB size depends on the choice of Backup Destination during the database deployment creation process:


  • Both Cloud Storage and Local Storage: GB size equal to 1.7 times the size of the data volume.
  • Cloud Storage Only or None: GB size equal to 0.1 times the size of the data volume, with a minimum of 7 GB

This volume is completely allocated to /u03 on the virtual machine.
redo
10 GB volume completely allocated to /u04 on the virtual machine.

Storage Volumes of an Oracle Database Deployment



File System Layout

File System mount point
Description
swap
Swap space: 4 GB allocated from the boot Compute Cloud storage volume.
/ (root)
Operating system files: 25.5 GB allocated from the boot Compute Cloud storage volume.
/boot
Operating system kernel: 500 MB allocated from the boot Compute Cloud storage volume.
/u01
Oracle product software: the entire bits Compute Cloud storage volume.
/u02
Oracle Database data storage: the entire data Compute Cloud storage volume.
/u03
Database backup storage: the entire fra Compute Cloud storage volume.
/u04
Database redo logs: the entire redo Compute Cloud storage volume.


File System Layout of an Oracle Database Deployment




Conclusion

In this article we have learned about Oracle Database Cloud Services Storage Volumes and File System Layout. When you create a database deployment, Oracle Database Cloud Services (DBCS) creates the Storage Layout and File Systems for you.

2

Oracle Database Cloud Service (DBCS) provides you the ability to deploy Oracle databases in the Oracle Cloud. Each database deployment contains a single Oracle database in a Virtual machine image. You can’t create multiple databases in one database deployment if you want to create multiple databases then you create a 12c Container database with multiple Pluggable databases. Oracle DBCS or also known as DBaaS is part of Platform as a Service (PaaS) offering. The compute, virtual machine, storage, network, optionally tools to simplify routine database maintenance and management operations are provided by Oracle. You will have full access to the features and options available with Oracle Databases.

When you create a database deployment, Database Cloud Service creates compute nodes to host the database, using computing, storage and networking resources provided by various Oracle Cloud infrastructure services.

Service Level

Service Level
Details
Oracle Database Cloud Service – Virtual Image
Compute Allocated
Storage Allocated
Virtual Machine Image Installed
Included software to create Oracle Database
Connect to VM and run DBCA to create Database
You are responsible for maintenance operations such as Backup , Patching and Upgrade
Oracle Database Cloud Service
Compute Allocate
Storage Allocate
Virtual Machine Image Installed
Set Keys and Privileges
Install and Configure Database
Configure Backup
Configure Tools
Configure Access

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

Selecting Service Level During Database Deployment


Metering Frequency

Frequency
Description
Hourly
Pay only for the number of hours used during your billing period.
You cannot switch a deployment from hourly to monthly metering frequency after it is created.

Monthly
Pay one price for the full month irrespective of the number of hours used.
You cannot switch a deployment from hourly to monthly metering frequency after it is created.

Selecting Metering Frequency During Database Deployment


Cloud Tooling for Database Cloud Service

Purpose
Tool
Description
Automated Backup
bkup_api
To perform on-demand backup and change how automatic backups are configured. Use raccli for Real Application Clusters deployment.
Automated Recovery
dbaascli
To perform restore/recovery. Use raccli for RAC deployment.
Automated Patching
dbaascli
To apply patches. Use raccli for RAC deployment
Database Monitoring
DBaaS Monitor
To monitor Oracle Database and Computing Resources

Oracle Database Software Release

When creating a database deployment on Oracle Database Cloud Service (DBCS), you choose one of the following Oracle Database software releases:
  • Oracle Database 11g Release 2
  • Oracle Database 12c Release 1
  • Oracle Database 12c Release 2
Selecting Software Release During Database Deployment


Oracle Database Software Edition

Edition
Options Included
Packs Included
Standard Edition
None
None
Enterprise Edition
None
None
Enterprise Edition – High Performance
Advanced Analytics, Advanced Compression, Advanced Security, Database Vault, Label Security, Multitenant, OLAP, Partitioning, Real Application Testing, Spatial and Graph
Cloud Management for Oracle Database, Database Life Cycle Management, Data Masking and Subsetting, Diagnostics, Tuning
Enterprise Edition – Extreme Performance
Active Data Guard, Advanced Analytics, Advanced Compression, Advanced Security, Database In-Memory, Database Vault, Label Security, Multitenant, OLAP, RAC, Partitioning, Real Application Testing, Spatial and Graph
Cloud Management for Oracle Database, Database Life Cycle Management, Data Masking and Subsetting, Diagnostics, Tuning
  
Selecting Software Edition During Database Deployment


Oracle Database Type

Database Type
Description
Single Instance
A single Oracle Database instance and database data store hosted on one compute node.
Database Clustering with RAC
A two-node clustered database using Oracle Real Application Clusters technology; two compute nodes each host an Oracle Database instance, and the two instances access the same shared database data store.
Single Instance with Data Guard Standby
Two single-instance databases, one acting as the primary database and one acting as the standby database in an Oracle Data Guard configuration.
Database Clustering with RAC and Data Guard Standby
Two two-node Oracle RAC databases, one acting as the primary database and one acting as the standby database in an Oracle Data Guard configuration.
Data Guard Standby for Hybrid DR
Single-instance database acting as the standby database in an Oracle Data Guard configuration. The primary database is on your own system.

Selecting Database Type During Database Deployment


Automatic Backup Configuration

When you create a new database deployment on DBCS, you can choose whether you want to configure automatic backup for your database.

Backup Option
Description
Both Cloud Storage and Local Storage
30 days worth of backups are kept, with the 7 days most recent backups 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.
None
No automatic backups are configured

Selecting Backup Destination during Database deployment

Conclusion

In this article we have learned about Oracle Database Cloud Services (DBCS). Oracle Database Cloud Service (DBCS) provides you the ability to deploy Oracle databases in the Oracle Cloud. When you create a database deployment, Database Cloud Service creates compute nodes to host the database, using computing, storage and networking resources provided by various Oracle Cloud infrastructure services.


1

Oracle Cloud Overview
  • Oracle Cloud is one of the few cloud providers that can offer a complete set of cloud services to meet all your enterprise computing needs.
  • Oracle Cloud provides deployment options ranging from the public cloud to your data center.
  • Oracle Cloud offers best-in-class services across:
  • Software as a Service (SaaS),
  • Platform as a Service (PaaS),
  • Infrastructure as a Service (IaaS)


Infrastructure As a Service (IaaS):


Using Oracle IaaS services you can set up the virtual machines, storage, and networking capabilities you need to run any kind of workload. The entire infrastructure is managed, hosted, and supported by Oracle. You are responsible for patching and maintenance of the operating system and any other application software that you may run.


Platform As a Service (PaaS)


Using Oracle PaaS services you can quickly provision ready-to-use environments for your enterprise IT and development teams, so they can build and deploy applications, based on proven Oracle databases and application servers. Oracle Database as a service (DBaaS) is part of PaaS offering. You are not responsible for managing and administering the infrastructure and Operating System.


Software As a Service (SaaS)


Oracle SaaS allows users to subscribe and use application software in the cloud. Oracle offers cloud-based solutions for Human Capital Management (HCM), Cloud Managed ServicesEnterprise Resource Planning (ERP), Supply Chain Management (SCM), HR, CX and many other applications, all managed, hosted, and supported by Oracle. You are not responsible for managing and administering the infrastructure and Operating System.


Oracle Cloud Platform

Oracle Cloud Platform
Courtesy: Oracle

Oracle IaaS and PaaS

 Oracle IaaS and PaaS
Courtesy: Oracle

 

Conclusion


In this article we have learned what is Oracle Cloud and what are the different Oracle Cloud offerings currently available. Oracle Cloud offers best-in-class services across Software as a Service (SaaS), Platform as a Service (PaaS) and Infrastructure as a Service (IaaS)
4

Introduction


Exadata Compute nodes and storage cells come with an Integrated Lights Out Manager or simply ILOM. ILOM is an adapter card in each compute node and storage cell that operates independently of the operating system. The ILOM boots up as soon as power is applied to the server and provides web and SSH access through the management network. Using ILOM you can perform several tasks remotely that would otherwise require physical access to the servers, this includes access to the remote console, attach diag.iso image, power server on and off, and rebooting or resetting the server. Also ILOM monitors the configuration and server internal hardware components.

In this article I will demonstrate step by step procedure on how to boot Exadata Compute node with the diagnostic ISO image using Web ILOM Remotely.

Steps to Mount diag.iso On An Exadata Compute Node Using ILOM Console:


  • Copy/Download diag.iso to desktop machine
You can copy the diag.iso image from a good working compute node or storage cell to the desktop as shown below. You have an option to download image file from MOS note as well. See the MOS note 2001454.1 for more details.

Locate the diag.iso image on a good working server



Using WinScp copy the diag.iso image to the desktop/laptop






  • Connect to the WEB ILOM as shown below
Open a web browser and enter the ILOM Hostname or ILOM IP address you want to attached diag.iso image


Enter the root user credentials



This is the ILOM home page which brief information about the server. On the left pane you have different options that you can use to manage the server remotely.



  • Launch Remote Console by following the steps below
On the left pane Expand “Remote Control” and Click on “Redirection”


Click on “Launch Remote Console” button



Click Ok



Click Ok






Click Continue



Click Run



Now we can access the server remotely.



  • Attach the diag.iso to Remote Console as follows
Click “KVMS” and Click on “Storage”


Click “Add” Button



Select the “diag.iso” image file on the local desktop/laptop



Click Ok



  • Reboot the Server to boot from ISO image as follows
On the left pane expand “Host Management”, Click on “Host Control” and Select “CDROM” as Next Boot Device and Click Save button


On the left pane expand “Host Management”, Click on “Power Control” and Select “Power Cycle” and Click Save button



Click Ok





  • Now the System is booting from diag.iso image

  • Perform the desired action
Enter ‘e’ to enter into interactive mode or
Enter ‘r’ to perform a system restore from NFS backup

At this stage the server booted from diag.iso, enter into interactive mode, restore/recovery the machine or correct the OS configuration that you have and when you are done, disable redirection.

Conclusion

In this article we have learned how to mount diag.iso on Exadata compute node and boot Exadata Compute node. Using ILOM you can perform several tasks remotely that would otherwise require physical access to the servers, this includes access to the console, power server on and off, and rebooting or resetting the server.

0

PREVIOUS POSTSPage 8 of 18NEXT POSTS

[contact-form-7 id=”4973″ title=”Lead”]