This post covers How To Create Database & Connect to host on Oracle’s Gen2 Cloud (OCI).
In Oracle Cloud Infrastructure Database is divided into two types:
1. Autonomous Database: Oracle Cloud Infrastructure‘s Autonomous Database is fully managed by Oracle such as patching and another administrating task. Autonomous Database is further divided into types:
- ADW: ADW stands for Autonomous Data Warehouse and used for decision support or data warehouse workload.
- ATP: ATP stands for Autonomous Transaction Processing and used for a transactional workload.
To know more about Autonomous Database check here
2. User-Managed Database: User-Managed database is fully managed by users such as patching, cloning, backup & restore. It is further divided into three types.
- Virtual Machine DB Systems: Database is running on Virtual Machine&It supports both 1 -node, and 2-node RAC DB systems on Virtual Machine.
- Bare Metal DB System: Database is running on Bare Metal &It only supports only 1-node DB systems (RAC is not supported)
- Exadata DB System: Exadata DB systems runs on Exadata on Cloud and consist of a quarter rack, half rack, or full rack of compute nodes and storage servers, tied together by a high-speed, low-latency InfiniBand network and intelligent Exadata software and it is always a 2-node RAC only.
To know more about various Database Offerings check here
We can deploy User-managed Database In Oracle Gen2 Cloud (OCI) either on Virtual machine (VM), Bare Metal (BM) or on Exadata CS, In this post, I have covered the steps for VM-DB but concepts remain more or less same for BM & Exadata CS too.
So Let’s look at Deployment on Cloud so two main Deployment Model on Public Subnet. In order to understand this, there is VCN (this is network) & Subnet which is VCN divided into smaller parts.
- Database Deployed On Private Subnet
Database Host on a private subnet listen on a Private IP, We recommend Deploying database on a private subnet & you will be able to access the database within the Virtual Cloud Network. You can also access it from the on-premise network using DRG (Dynamic Routing Gateway).
- Database Deployed On Public Subnet
Database running on Public Subnet will get both Private IP & Public IP, you will be able to access it via Public IP & Internet Gateway is required for connectivity.
We only recommend creating a database on the public subnet only when you are using this database for testing purpose or if you want to expose your database to the internet.
To know more about VCN, Subnet, Firewall (Security List), IGW, DRG & how to create it, check here
How To Connect
In order to connect to Database Host deployed in Oracle Gen2 Cloud (OCI), you need to open port 22, which is SSH port and you will be able to connect to your database Instance and port 1521 which is database port, so that your database will be able to talk to application or other services over internet.
Note: When you create VCN using default options various resources is by default created by Oracle (Security List, IGW, Route Table).
To know how to create a security list and open port in Oracle Gen2 Cloud check here
Task For You
- If you don’t have an Oracle Cloud account yet, register using my Step by Step FREE Guide Get my FREE Guide at https://k21academy.com/cloud01
- Create a VCN & Public Subnet, More on VCN & Subnet: https://k21academy.com/
- Create Database in Public Subnet
- Connect to Database Server using Putty
- [Video] Oracle Autonomous Data Warehouse Cloud Service 18c Now on OCI
- Oracle Cloud Infrastructure: Database Offerings
Now if you want to go further deep and become Oracle Certified Cloud DBA, then next, Register for FREE Masterclass Click on the image below to register for FREE