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

How to find Hostname from AWS console

By Netsoftmate on

July 2, 2018

- Uncategorized

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

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

http://netsoftmate.blogspot.com/2018/06/how-to-login-aws-console.html

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…

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

How to Create AWS RDS Instance

By Netsoftmate on

July 2, 2018

- Uncategorized

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

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.html

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

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html

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

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.html

To Learn about RDS Security group, please follow this link

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.RDSSecurityGroups.html

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.

How to Login AWS Console

By Netsoftmate on

June 21, 2018

- Uncategorized

Overview

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

To know more about Amazon RDS please click here AWS RDS

In this article we will demonstrate how to login to AWS Console

Steps to Login AWS console

Open link in browser and click on Sign in to the console

https://aws.amazon.com/

Enter your Credentials

After click on sign in, AWS console open as follows

Click on services then RDS

We are on the AWS RDS page.

conclusion

In this blog we have learned how to login to AWS console then from console to Relational Database service(RDS).

Next, How to Create AWS RDS Instance…

By

Name : omer
Designation : Senior Database Engineer
Organization: NetSoftMate IT Solutions.

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)

Home

About

Services

Blog

Contact

ABOUT US

Services

CONTACT US

Follow Us!

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

Home

About

Services

Blog

Contact

Database Management Services, Oracle Databases, Oracle Exadata

Steps to Deploy Exadata Database Machine on Oracle Cloud Infrastructure

How to find Hostname from AWS console

How to Create AWS RDS Instance

Steps to create AWS RDS Instance (Oracle EE)

How to Login AWS Console

Oracle DBCS Storage Volumes and File System Layout

File System Layout of an Oracle Database Deployment

Oracle Cloud Quick Overview

Infrastructure As a Service (IaaS):

Platform As a Service (PaaS)

Software As a Service (SaaS)

Oracle Cloud Platform

Oracle IaaS and PaaS

Conclusion