What must be created before provisioning an Oracle Cloud Infrastructure DB Systems
This post covers How To Create a Database on Oracle’s Gen2 Cloud (OCI) on VM Database. Show
Every Oracle Cloud learner must know how to create a Database. It is surely a must know & important topic. But, before that let me tell you about the different types of Databases in Oracle Cloud and the deployment topology. Types of Databases in Oracle CloudThere are different types of DB systems in the Oracle Cloud.
Note: There are different types of DB systems in the Oracle Cloud which you can check here Oracle Cloud Database Deployment Options (VMDB, BMDB, ExaCS, ExaCS, Autonomous (ADW, ATP), MySQL DB & NoSQL DB. Note: In this video, we’re going to create a database on VMDB: Virtual Machine DB Systems. Deployment TopologyNow, in order to create your Database, you first need to select a region & domain you are going to create the database. Region is a geographical location in which the Oracle Cloud exists. Read more about the difference between Region Availability Domain (AD) & Fault Domain (FD) Database DeploymentIn Oracle Cloud, there are two deployment models in User-Managed Database i.e., Database in Public Subnet or Database in Private Subnet where Subnet is a part of VCN Check this blog to know more about VCN, Subnet, Firewall (Security List), IGW, DRG & how to create it. 1) Database Deployed Inside Private Subnet Database Host on a private subnet listen on a Private IP, We recommend the Deploying database on a private subnet & you will be able to access the database within the Virtual Cloud Network. You can access it from the on-premises network via DRG (Dynamic Routing Gateway) using either FastConnect or IPSec VPN 2) Database Deployed Inside Public Subnet A 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 purposes or if you want to expose your database to the internet. Network TopologyWhen you’re creating the Databases, you’ll also need to have Network Topology. Within the Virtual Cloud Network (VCN), you can either have a public subnet or a private subnet. Note: In this video, we’re going to create a Database after creating VCN with a public subnet. Create Database On Oracle Cloud: Step By Step1) Register & Log in to the Oracle Cloud account. Note: First, you should have an Account at Oracle Cloud and if you don’t have one, then you can register FREE using my step-by-step video & guide that I covered in episode 30. 2) Configure Network: Next, as we want to access the database over the internet, so we’ll create it in the Public Subnet and assign Public IP in addition to configuring Internet Gateway on VCN. Note: If you are not familiar with VCN, Subnet, or Internet Gateway then learn about them in one of my previous episodes on networking. 3) Generate SSH Keys: Once you are done with creating VCN & Public Subnet, then you also need one more thing i.e. SSH Keys Pair that you generate using Puttygen, so that you can access the Autonomous Linux using SSH private key. Note: If you are new to SSH Keys or don’t have one, check the steps here to create SSH keys 4) Sign In: Once you have all the things sorted, sign in to Oracle Cloud Account, and you will land on the OCI Console. 5) Create Database Instance: Click on the hamburger menu on the top left side, select Bare metal, VM & Exadata & then Click on Create DB System.
6) First, select the Compartment in which you want to create the Database. Note: Read more about the Compartments and Policy. 7) Click on “create DB System” Choose the compartment, enter the name of the DB System, Then choose Availability Domain inside which you want to create the Instance, If you want higher CPU & higher memory, then click on “Change Shape“. Note: Know more about Region & Availability Domain in OCI. 8) Under “Add SSH key”, click on “Upload the SSH Keys files” and browse the location where the public key is stored. Note: If you are new to SSH Keys or don’t have one, check the steps here to create SSH keys 9) Choose License type, click on License included, if you want to choose your own license then click on BYOL (Bring your own license) 10) Select the VCN & Public Subnet, leave other options default, Click on Next 11) Enter the DB Name, & select the Database version (We have selected 19c, you can select upon your requirement). Create the SYS admin password (make sure you remember the password) Click on Create DB System. 12) When the database creation is complete, the status changes from Provisioning to Available Note: It will take 30 minutes to make your Database up & Running How To Connect1) In order to connect to Database Host deployed in Oracle Gen2 Cloud (OCI), you need to open port 22, which is an SSH port and you will be able to connect to your database Instance and In case you want to connect to database listener port you have to open port 1521 so that your application will be able to talk to the database or other services over the internet. Note: When you create VCN using default options various resources are by default created by Oracle (Security List, IGW, Route Table). Check this video blog to learn how to create a security list and open port in Oracle Gen2 Cloud 2) To connect to the Instance you will need the Public IP of the Instance & the PuTTY Software Note: know how to get the Public IP of the Database Enter the Public IP Address in the Hostname, then add the SSH Private key (That we created before) under SSH & then Auth. Click on “Open” TroubleshootingSo that’s all how you can create and provision a Database on OCI. Now, some of you might face issues while connecting the instances. There could be multiple reasons for Instance Connectivity issues in OCI like:
For the Fixes of the above issue, you can check our previous post [Troubleshooting] Compute (Linux/Windows) & Database Instance Connectivity Issue in Oracle Cloud (OCI) Related/Further Readings
What’s Next For You?If you want to upgrade your career from an Oracle DBA to Oracle Cloud DBA, and want to clear Oracle Cloud Database Migration and Integration Specialist then register for our FREE class and don’t miss an opportunity to gain a plethora of insights on becoming a certified Oracle Cloud DBA. What is the first thing needed before creating DB system?You'll need the following items to create any DB system: The public key, in OpenSSH format, from the key pair that you plan to use for connecting to the DB System via SSH. A sample public key, abbreviated for readability, is shown below. For more information, see Managing Key Pairs on Linux Instances.
Which Oracle cloud infrastructure service can you use to create and manage your infrastructure?You specify the compute resources that your applications require, and the Container Engine provisions them on Oracle Cloud Infrastructure in an existing OCI tenancy. Oracle Cloud Infrastructure Networking lets you create and manage a software-defined network we call a Virtual Cloud Network (VCN).
How many DB systems must you provision before you can enable Oracle Data Guard for a virtual machine DB system database?An Oracle Data Guard implementation requires two DB systems, one containing the primary database and one containing the standby database.
Which two are the minimum prerequisites to launch a DB system?Before you set up a bare metal or virtual machine DB system, you must set up a virtual cloud network (VCN) and other Networking service components. To launch a DB system, you must have: A VCN in the region where you want the DB system. At least one subnet in the VCN (either a public subnet or a private subnet)
Which are the three pre requisites to configure a private endpoint with autonomous databases?Network prerequisites. A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure. Cannot be changed after provisioning.. A private subnet within your VCN configured with default DHCP options. ... . At least 1 network security group (NSG) within your VCN for the Autonomous Database.. Which is an important consideration when choosing an Oracle cloud infrastructure?Which is an important consideration when choosing an Oracle Cloud Infrastructure region? Choose the region that is in close proximity to end users for best performance.
|