Oracle DBA Lab — DevOps Edition

Built a 45-day hands-on Oracle DBA DevOps lab in Oracle DBA environments to level up on automation, security, and performance using Oracle 23c, Bash, Python, SQL, Linux and DevOps best practices. Packed with real-world challenges and ready to fork, tweak, and learn from. This lab showcases essential skills for database administration, automation, performance tuning, and cloud migration. Always growing and happy to collaborate!

---

🚀 Features

• 🧑‍💻 Multi-schema Oracle DB (e.g. dev_user, analyst_user)
• 💾 Automated backups via Bash + cron
• 🐚 Shell scripts for health checks, log analysis, space monitoring
• 📈 Performance insights using dynamic V$ views
• ☁️ Portable with Docker Compose or deployable to Oracle Cloud ATP
• 🔐 OS + DB security hardening examples

---

🧪 Lab Preview

Users

• dev_user – Developer schema with full object privileges
• analyst_user – Read-only access to shared views and reports

Sample Scripts

• db_backup.sh – Full export with expdp
• listener_check.sh – Check Oracle listener status
• space_monitor.sh – Tablespace alert script
• schema-create.sql – Setup sample tables, users, and data

---

📦 Quick Start (Docker)

🐳 Run the full lab locally using Docker Compose.

git clone https://github.com/crispusomollo/oracle-lab-x.git
cd oracle-lab-x/docker
docker-compose up -d

🧠 Technologies

• Oracle 23c Free / XE
• Oracle Linux (WSL + Cloud)
• SQL*Plus + SQL Developer
• Bash scripting
• Docker (optional)
• Terraform / OCI CLI (optional)

📂 Project Structure

See lab-scripts/ and docker/ for core files.

📸 Screenshots

🎓 Skills Demonstrated

• ✅ Oracle user & schema administration
• ✅ Tablespace + quota management
• ✅ Data Pump exports (expdp) & imports (impdp)
• ✅ Bash scripting with cron, alerts, log rotation
• ✅ SQL tuning with V$SQL, V$SESSION, V$SYSTEM_EVENT
• ✅ Dockerized deployment + optional cloud migration

💡 Future Improvements

• GitHub Actions for nightly script testing
• Terraform template for full OCI IaaS + ATP setup
• Blog post walkthrough or YouTube video
• SQL query challenge workbook

🗺️ Learning Roadmap

roadmap.md – 45-day learning + build plan

License

This project is licensed under the MIT License, a permissive open source license that allows you to freely use, modify, and distribute the code.

It comes without warranty, so use it at your own risk.

If you plan to contribute or use the code in your projects, please review the LICENSE file for details.

🙌 Contributing / Feedback

Contributions welcome!

Fork, star, suggest improvements, or open issues