October 22, 2020

How to create Oracle Autonomous Database in OCI

What is autonomous database:-  An Oracle Autonomous Database is a cloud-based technology designed to automate many of the routine tasks required to manage Oracle databases which is mostly done by DBA's. It uses machine learning to automate database performance tuning, backups, securing database , patching etc.

Types of autonomous database based on workload :-


  •  Autonomous transaction processing
  •   Autonomous data warehouse
  •   Autonomous Json Database

To create Autonomous database, first login to Oracle cloud (www.oracle.com/cloud




Provide details such as Display name , Database name , Workload type- which is autonomous transaction processing in our case , deployment type- shared infrastructure ,DB Version , Cpu count , storage etc. In our case we chose “Always Free” option which comes with default 1 Ocpu and 20GB of storage.
















So this concludes the creation of Oracle Autonomous Database.


No comments:

Post a Comment

Datapatch Fails in Oracle 12c on Windows – Root Cause and Step-by-Step Fix

   Recently, while applying a patch on an Oracle 12c (12.2.0.1) database on Windows, I ran into a frustrating issue: datapatch kept failin...