Oracle Database on AWS: EC2 & RDS from Scratch
Description I will be looking to delve deeper into the AWS Infrastructure and demystify the entire dilemma around Oracle Database on AWS.
We will take a main architecture diagram as base , where we shall create a custom VPC, which will have a Public Subnet & a Private Subnet. The Public Subnet will have access to the internet and we will have a test Oracle 18c XE Database and an Apache Webserver in this.
The Oracle 12c RDS Database will be created in Private Subnet and will have access only from Webserver. To achieve this our approach would be as follows:
We will start with the very basics like : What is Cloud Computing , What are the meanings of the important acronyms like IaaS/ PaaS/ SaaS, Top Cloud Vendors by Market Share.
A good understanding will be given about AWS Cloud , Sign-Up Process and Understanding the AWS Management Console.
We will be approaching our study from Architecture standpoint by doing a deep dive into the Architecture of AWS and discussing : Regions / AZ / VPC / Security Groups / EBS Voume / S3 Storage,
A number of demos will be done on the creation of Custom VPC , Secury Groups , EBS Disk , S3 Storage. A demo will be done showing the configuration of AWSCLI on Mac OS / Windows.
EC2: We will discuss the details on EC2 / What are AMI: Amazon Machine Images.
We will do a demo to create an EC2 Instance in Custom VPC , Install 18c XE on EC2 Instance, Backups/Recovery using RMAN Backups to S3 Storage.
RDS: What is RDS / RDS for Oracle , Backup/ Recovery , Monitoring , Oracle Vs RDS commands
A demo will be done on Deploying Oracle 12c Database in RDS , Patching the existing version of Oracle.
A Demo will show the creation of EC2 instance which will act as Apache Webserver , then we shall install Apache, PHP and show the entire process around PHP with OCI8 Connectivity.
We will also discuss what is REST API and using a tool Postman call an RDS REST API. To continue:
Mismanagement of multi-cloud expense costs an arm and leg to business and its management has become a major pain point. Here we break down some crucial tips to take some of the management challenges off your plate and help you optimize your cloud spend.
In a recent blog post, Oracle introduced the MySQL Database Service in the Oracle Cloud Infrastructure (OCI). The service is now available as a fully-managed service running on Oracle Generation 2 Cloud Infrastructure.
To move or not to move? Benefits are multifold when you are migrating to the cloud. Get the correct information to make your decision, with our cloud engineering expertise.
Oracle Online Training & Certification Course; Launch your career by joining India's best Institute to learn 10g 11g and become well-versed oracle professional.
In this tutorial, you will learn how to declare and initialize Oracle PL/SQL collections (Nested Tables). Nested tables are very similar to the PL/SQL tables, which are known in Oracle as index-by tables.