Oracle Autonomous Database - A Beginner's Guide

1. What is Autonomous Database (ADB)?

A fully managed database that handles tuning, backups, patching & scaling automatically.

• No need for manual DBA work
• Ideal for running OLTP, analytics, or mixed workloads
• Available in two types: ADB for OLTP (Transaction Processing) and ADB for DW (Data Warehouse)

2. 🚀Provisioning an ADB Instance

I have used minimal resources for demo purpose.

You can explore the ‘Advanced Options’ section if you wish to customize any additional settings.

To monitor the progress, you can check the Work Requests section.

You can find all the database information here.

3. 🔗Connecting to ADB

Various ways to connect and query your database.

• Use SQL Developer or SQLcl with downloaded Wallet
• Use SQL Worksheet directly from the OCI console (browser-based)
• Connect with JDBC/ODBC drivers for applications

Let’s try with the SQL Worksheet.

4. 🔐ADB Wallet and Security

Ensures encrypted and secure connections to your database.

• Download Client Credentials (Wallet) from ADB console
• Use them to connect securely via apps/tools
• Always store securely, rotate if required.

5. 💾Backup and Recovery

It's automated – but you still have control.

• Backups are taken automatically every day
• You can restore to any point in time using the "Restore" feature

6. 📊Monitoring and Scaling

Track performance and scale with a click.

• View Metrics & Logs in the OCI Monitoring service
• Scale CPU & Storage without downtime
• Check resource usage and optimize workloads.