In this post, we are covering how to create your first Autonomous Data Warehouse Cloud Service 19c on Oracle Cloud Infrastructure (OCI).
Note: There are different types of DB systems in the Oracle Cloud To know more about Oracle Cloud Database Deployment Options (VMDB, BMDB, ExaCS, ExaCS & Autonomous (ADW, ATP), check here
Note: This post is part of Video series of Roles and Responsibility or Tasks of DBA, if you haven’t seen my previous post then click on the link to watch the previous video post click here
Create Your First Autonomous Data Warehouse 19c on OCI
In this video, We have covered how to create your first Autonomous Data Warehouse on Oracle Cloud Infrastructure (OCI), whereas OCI is the 2nd generation of Oracle Cloud & OCI-C is the first generation.
Note: To know more difference between OCI vs OCI-C click here
Note: In this video, we have covered Create an Autonomous database 18c version but now all the autonomous databases you create by default are 19c database. In the below steps, we covered how to create an Autonomous 19c database on OCI.
Database Types
OLTP (On-line Transaction Processing): is a category of data processing that is focused on transaction-oriented tasks (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and effectiveness measured by a number of transactions per second.
OLAP (On-line Analytical Processing | Data Warehouse ): is characterized by a relatively low volume of transactions. For OLAP systems a response time is an effectiveness measure. OLAP allows users to analyze database information from multiple database systems at one time.
Read More: Oracle Enterprise Manager(OEM) 13c for beginners, what is OEM, high-level steps to deploy OEM on Oracle cloud infrastructure (OCI), OEM architecture components, OEM HA/DR overview.
Oracle Autonomous Data Warehouse (ADWC):
Oracle Autonomous Data Warehouse Cloud uses applied machine learning to self-tune and automatically optimizes performance while the database is running. Oracle Autonomous Database is Oracle’s new, fully managed database tuned and optimized for both data warehouse and transaction processing workloads. It is built on the next generation Oracle Autonomous Database technology using artificial intelligence to deliver unprecedented reliability, performance.
Note: To know more about Oracle Autonomous Database Overview: ADW, ATP, Serverless & Dedicated Infrastructure click here
Architecture of Modern Cloud Data Warehousing
How To Create Autonomous Database On Oracle Cloud
1) Register & Log into the Oracle Cloud account, Click here
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. To get a FREE guide click here
2) Sign In: Once you have all the things sorted, sign in to Oracle Cloud Account, and you will land on the OCI Console.
3) Create Database: Click on the hamburger menu on the top left side, select Autonomous Data Warehouse or Autonomous Transaction Processing & then Click on Create Autonomous Data Warehouse.
4) First, select the Compartment in which you want to create the Database.
Note: To know more about Policy & compartment click here
5) Select compartment inside which you want to create the Instance, Enter the Display name and database name and Choose a workload type.
6) Choose a deployment type, Choose database version 19c then select OCPU Count & Storage (TB).
Note: As of April 2020 19c version only available on Shared Infrastructure so select Shared Infrastructure deployment type.
7) Create the Create administrator credentials (make sure you remember the password), Choose network access & Choose a license type then click on Create Autonomous Data Warehouse.
Note: Password must be 12 to 30 characters and contain at least one uppercase letter, one lowercase letter, and one number. The password cannot contain the double quote (“) character or the username “admin”.
Note: Choose network access As of February 2020 (Shared Infrastructure Only) Autonomous Database Now Supports Private Endpoints by using this it is now possible to restrict access to Autonomous Database by specifying a private endpoint within a Virtual Cloud Network (VCN).
8) When the database creation is complete, the status changes from Provisioning to Available
Note: It will take 10-20 minutes to make your database up & Running
How To Connect
1) In order to connect to Autonomous Database deployed in Oracle Cloud (OCI), you can use SQL developer web.
Note: To know step by step how to connect to an Autonomous database using SQL Developer web click here
Related/Further Readings
- [1Z0-931] Oracle Autonomous Database Cloud Certified Specialist Everything You Must Know About
- Difference between OCI vs OCI-C
- Oracle Cloud Database Options (VMDB, BMDB, ExaCS, ExaCS & Autonomous (ADW, ATP)
- Oracle Autonomous Database Overview: ADW, ATP, Serverless & Dedicated Infrastructure
- Create & Connect to Database on Oracle’s Gen2 Cloud (OCI)
- Connect to Autonomous database using SQL Developer Web
Begin Your Cloud Journey
Begin your journey towards becoming an Oracle Cloud Expert and earn a lot more in 2024 by joining our FREE CLASS. You will also know more about the Roles and Responsibilities, Job opportunities for OCI Architects, Admins in the market, and what to study Including Hands-On labs you must perform to get the Higher Paying jobs.
Click on the below image to Register for Our FREE Class on MASTERING ORACLE CLOUD FOR DBAs, APPs DBAs, ARCHITECTS & SYS ADMINS
Eli Paul says
Thank you for many video share your knowledge. I have question on ExaCS can be use autonomous data base or only VM base DB, I heard conflicting story
Thanks,
Eli
Atisha Sharma says
Yes, ExaCS works with both Autonomous Databases and VM-based databases on Exadata, regardless of deployment environment (on-premises or cloud). Conflicting information might be due to historical limitations or deployment specifics.