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

ABOUT US

Services

CONTACT US

Follow Us!