Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!
Database Management Services, Oracle Databases, Oracle Exadata
In this article we will demonstrate quick steps to deploy Exadata Database Machine in Oracle Cloud Infrastructure (OCI). 

Prerequisites:

  • Exadata Cloud Subscription
  • Credentials to Login Oracle Cloud
  • Access to Deploy Exadata in OCI
  • Compartment
  • VCN & Subnet

Steps to Deploy Exadata on OCI

  • Open a browser and enter the URL you have received from Oracle to connect to the Oracle Cloud
  •  

  • Enter your Oracle Cloud credentials
  •  

  • Click on “Create Instance”
  •  

  • Click on “All Services” and search for Exadata keyword. Click on Create.
  •  

  • Select your “Compartment” on left and Click on “Launch DB System”
  •  

  • Enter the details as per your requirement and the Exadata subscription procured
  •  


  • Browse and upload the public key
  •  

  • Choose your desired storage allocation and timezone
  •  

  • Fill in the required VCN and Subnet details. Work with your network engineer to gather the correct details on VCN and Subnet created for your environment
  •  

  • Fill the database details, name, version, CDB and Password
  •  

  • Select the Workload type and database character set for your database
  •  

  • Optionally specify the TAG Key and click “Launch DB System” to deploy Exadata DBM
  •  



Conclusion

In this article we have learned how to deploy an Exadata Database Machine in Oracle Cloud Infrastructure (OCI).


Expert Support for Oracle Exadata | Netsoftmate



1

Overview

All AWS RDS Instances has DNS name and port number which is also known as endpoint, to establish connection to your AWS DB Instance you require DNS names and port number, we can find endpoint details of AWS RDS Instance through AWS console.

In this article we will demonstrate, how to find endpoint details from AWS console.

Steps to find endpoint of AWS RDS Instance

  • Login to AWS console
please check previous article on how to login AWS console by click on following link

  • From console got to services then RDS

  • Click on RDS

  • Click on Instances

  • Choose oracle database instance and see database properties from Instance action tab.


  • Click on see details to display database instance properties.


Conclusion
In preceding article we have learned that how to find endpoint details from AWS console.



Next, How to establish connection between on-premises and AWS Cloud…





By
Name : Omer
Designation : Senior Database Engineer
Organization: Netsoftmate IT Solutions
. 
3

Amazon Web Services (AWS) is a secure cloud services platform, It offers compute power, database storage, evolving cloud computing platform provided by Amazon, content delivery and other functionality to help businesses scale up and grow.

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.
To know more about Amazon RDS please visit https://aws.amazon.com/rds/

In this article we will demonstrate how to create an AWS RDS Instance.

Steps to create AWS RDS Instance (Oracle EE)


  • Login to AWS console, click here to know more about how to login to console
  • On AWS console click on RDS dashboard

  • Click on Get started now,  then on next page select engine

  • Click on Oracle Engine to create Oracle Database Instance

  • Select edition, here we are selecting enterprise edition,then another window appear where we have to provide more details, here choose license model as bring your own license

  • Now choose DB version, we have selected latest version

  • Now choose db instance class, we have choose DB instance class as db.r4.xlarge – this class has 4 cpu, 30 GB memory, to know more about Db instance class check this

  • Provide storage type, we have selected IOPS to learn more about AWS storage type please check following link.

  • Provide database settings, like DB name, master username credentials this master username we will use for connecting to database through back end.

  • After specifying DB details now move next window to provide advance configuration settings, like VPC details, security group
To learn more about VPC(virtual private cloud) check this link
To Learn about RDS Security group, please follow this link


  • Provide VPC, security group, database name and port details

  • Under Database options, provide database details character set, option group and parameter group

  • After provide all details click on Launch DB instance


  • Check progress, instance creation is in progress

  • Instance created and backup is in progress

  • Now Database is available for use


Conclusion
In this article  we have learned how to Create AWS RDS Instance. We have touch base about virtual private cloud(VPC), RDS security group, DB Instance class and storage types.



Next, How to find Host name of AWS RDS Instance….


By
Name : Omer
Designation : Senior Database Engineer
Organization: Netsoftmate IT Solutions
3

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