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.

Step 2 – Oracle DBCS : Generate SSH Key Pair On Windows

By Netsoftmate on

December 26, 2017

- Uncategorized

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.

Step 1 – Oracle DBCS : Subscribe To an Oracle Cloud Service

By Netsoftmate on

December 22, 2017

- Uncategorized

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

http://cloud.oracle.com

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

Change the country and Language

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.

Oracle Database Cloud Service (DBCS) Workflow

By Netsoftmate on

December 21, 2017

- Uncategorized

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.

Oracle DBCS Storage Volumes and File System Layout

By Netsoftmate on

December 20, 2017

- Uncategorized

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.

Oracle Database Cloud Services (DBCS) Overview

By Netsoftmate on

December 19, 2017

- Uncategorized

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.

Oracle Cloud Quick Overview

By Netsoftmate on

December 18, 2017

- Uncategorized

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 Services, Enterprise 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

Courtesy: Oracle

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)

NO OLD POSTSPage 3 of 3NEXT POSTS

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

Home

About

Services

Blog

Contact

Step 3 – Oracle DBCS : Create A Database Deployment

Oracle Database Cloud Service (DBCS) Workflow

Oracle Database Cloud Services (DBCS) Overview

ABOUT US

Services

CONTACT US

Follow Us!