2026 DB&T Oracle Database October Meet-Up

From Runbook to Playbook: Automating Oracle Database Lifecycle with Ansible and Terraform

Much of a DBA’s work repeats on every server: preparing the OS, installing database software, creating and configuring databases, and patching and upgrading them. When DBAs do these steps by hand, they are slow, drift from server to server, and cause many production incidents. Small differences in paths, settings, and steps add up.

This session shows how to replace manual DBA runbooks with repeatable, version-controlled automation, using two widely adopted DevOps tools. We start with a quick comparison of the main options (Ansible, Terraform, Jenkins, Puppet, Chef, Salt) and why agentless tools suit DBA teams and consultants so well. Then we go into real examples. You’ll see an Ansible role that silently installs Oracle Database software across multiple servers, plus  a three-phase upgrade playbook (pre-upgrade, upgrade, and finalize) that builds in backups and guaranteed restore points. We’ll also cover the OCI Ansible collection for provisioning compute and Autonomous Database, and Terraform for infrastructure as code on OCI, including variables, outputs, data sources, and a sensible project layout.

Attendees will leave with a practical blueprint and sample code they can adapt immediately to their own environments.

BIO

Osama Mustafa is a cloud and DevOps architect with hands-on experience and technology leader with more than 18 years of hands-on production experience. He is part of accenture enkitec group and holds recognition from four of the world’s leading technology vendors: he is the first Oracle ACE in the Middle East, the first Alibaba Cloud MVP in the region, a Microsoft MVP, and an AWS Community Builder.

A recognized community builder, Osama founded and leads the Jordan Amman Oracle User Group (JAOUG), Jordan’s first user group dedicated to Oracle technology. He works across major cloud platforms, including AWS, Microsoft Azure, Oracle Cloud Infrastructure (OCI), Google Cloud, and Alibaba Cloud, designing and delivering automation, DevOps, and database projects for clients worldwide.

Osama has authored three technical books: The Complete Guide to DevOps with AWS, Oracle Database Application Security, and Expert Oracle TimesTen In-Memory Database. He has spoken at more than 45 international conferences and has published over 100 articles in leading publications such as IOUG, UKOUG, and OTECH Magazine.

Since 2011, he has shared his knowledge through his blog, Technology Geek (osamaoracle.com), with more than 1,000 posts covering cloud architecture, DevOps, infrastructure as code, identity and security, and Oracle databases.