Oracle Autonomous Database Internals: What Is Really Automated

Beyond the Marketing - What ADB Actually Does vs What DBAs Still Own

23 March 2026

Chetan Yadav — Senior Oracle & Cloud DBA

⏱️ 13–14 min read

⏱️ Estimated Reading Time: 13–14 minutes

ADW • ATP • Auto-Indexing • Auto-Patching • Auto-Scaling • What DBAs Still Own

⚙️ Environment Referenced in This Article

Service: Oracle Autonomous Database on OCI (Shared & Dedicated Exadata Infrastructure)
Workload Types Tested: ADW, ATP, AJD  •  Oracle DB Version: 19c base + 23ai features on ADB
Workload: 2.8 TB OLTP + 6.1 TB analytics  •  Scale: 4–32 ECPU auto-scaling  •  Region: OCI ap-mumbai-1 primary, ap-hyderabad-1 DR

"The self-driving database." Oracle's marketing for Autonomous Database promises that the DBA is no longer needed — the database manages itself. Patches itself. Tunes itself. Scales itself. After running Oracle ADB in production for financial and analytics workloads across multiple OCI regions, I can tell you the reality is more nuanced and more interesting than the marketing suggests.

Oracle Autonomous Database genuinely automates things that used to consume enormous DBA time — patching, backup, storage management, and a meaningful subset of performance tuning. But it does not eliminate the need for database expertise. It changes what that expertise is applied to. The DBA who understands what ADB actually automates and what it does not will be dramatically more effective than one who takes the "self-driving" claim at face value.

This guide opens the hood on Oracle ADB internals: how auto-indexing actually works, what happens inside auto-patching, when auto-scaling kicks in, and which critical responsibilities remain firmly with the DBA and architect.

Step-by-step installation of Oracle Database 19c (64-bit) on Red Hat Enterprise Linux 9.4

Oracle Database 19c Installation Runner

Platform: RHEL 9.4 (64-bit)

Step-by-step installation of Oracle Database 19c (64-bit) on Red Hat Enterprise Linux 9.4.

1. Assumed the Installer is downloaded 

File name:

LINUX.X64_193000_db_home.zip

Upload it to the server 

/stage/oracle/LINUX.X64_193000_db_home.zip

2.  Configure Hostname

hostname.

hostnamectl

3. Configure /etc/hosts

Edit hosts file.

vi /etc/hosts

4. Install Oracle Preinstall Package

Configure prerequisites 

dnf install -y oracle-database-preinstall-19c

*Note :(this pre install steps will automatically create the require user, group and required lib and rpm)

5. Configure SELinux

Edit SELinux configuration.

vi /etc/selinux/config

Set:

SELINUX=permissive

Apply immediately:

setenforce 0

6.  Disable Firewall

Stop firewall.

systemctl stop firewalld

systemctl disable firewalld

7. Create Oracle Directory Structure

Create Oracle installation directories using your custom path.

mkdir -p /Chetan/practice/u01/app/oracle/product/19.0.0/dbhome_1

mkdir -p /Chetan/practice/u02/oradata

Set ownership.

chown -R oracle:oinstall /Chetan

chmod -R 775 /Chetan

8.  Configure Oracle Environment

Login as oracle user.

su - oracle

Create scripts directory.

mkdir ~/scripts

Create environment script.

vi ~/scripts/setEnv.sh

Add:

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=rhel9-oracle.localdomain

export ORACLE_BASE=/Chetan/practice/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1

export ORACLE_SID=cdb1

export PDB_NAME=pdb1

export DATA_DIR=/Chetan/practice/u02/oradata

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Load environment automatically.

echo ". ~/scripts/setEnv.sh" >> ~/.bash_profile

Reload profile.

source ~/.bash_profile

 

9. Extract Oracle Software

Navigate to Oracle Home.

cd /Chetan/practice/u01/app/oracle/product/19.0.0/dbhome_1

Unzip software.

unzip -oq /stage/oracle/LINUX.X64_193000_db_home.zip

10 . Run Oracle Installer

Start installer.

./runInstaller

Select:

Install Database Software Only

Edition: Enterprise Edition

Oracle Base:

/Chetan/practice/u01/app/oracle

Oracle Home:

/Chetan/practice/u01/app/oracle/product/19.0.0/dbhome_1

________________________________________

11. Start Oracle Listener

Switch to oracle user.

Start listener.

lsnrctl start

Verify listener.

lsnrctl status

________________________________________

12. Create Database Using DBCA

Run Database Configuration Assistant.

dbca

Select:

Create Database

General Purpose Database

Create Container Database

Example configuration:

SID:

cdb1

PDB:

pdb1

 

Datafile location:

/Chetan/practice/u02/oradata

13. Verify Database

Connect to database.

sqlplus / as sysdba

Check database.

select name, open_mode from v$database;

Check PDB.

show pdbs;

Installation Completed

Oracle Database 19c is now successfully installed.

Oracle Home:

/Chetan/practice/u01/app/oracle/product/19.0.0/dbhome_1

Database files:

/Chetan/practice/u02/oradata

Oracle Database 23ai Architecture: AI-Native Internals for DBAs

What Actually Changed Inside the Engine — Beyond the Marketing

16 March 2026

Chetan Yadav — Senior Oracle & Cloud DBA

⏱️ 11–12 min read

⏱️ Estimated Reading Time: 11–12 minutes

AI Vector Search • Select AI • JSON Duality • True Cache • SQL Domains • Lock-Free Reservations

⚙️ Environment Used in This Article

Oracle Database: 23ai (23.4) Enterprise Edition  •  Platform: Oracle Linux 8.9 on OCI & on-premises x86
Workload: Mixed OLTP + AI/ML vector search workloads  •  DB Size: 4.2 TB
New Features Tested: AI Vector Search, Select AI, JSON Duality Views, True Cache, SQL Domains, Lock-Free Reservations, Boolean datatype, Schema Privileges

Oracle called it "23ai" for a reason. This is not a routine point release with incremental improvements. The AI suffix signals a deliberate architectural shift — Oracle has embedded AI capabilities directly into the database engine itself, not as an external add-on or middleware layer.

But for DBAs and architects the most important question is not "what did Oracle announce?" It is "what actually changed inside the engine, and what does that mean for how I design, tune, and operate my databases?" The marketing materials will tell you Oracle 23ai is revolutionary. This guide will tell you which features are genuinely production-ready, which ones still need maturity, and what the internal architecture changes mean for your workload.

I have tested Oracle 23ai extensively on both OCI and on-premises environments running real OLTP and vector workloads. This guide reflects what I found in practice, not what the release notes promise.