Quick Setup
Get Oracle 26ai with APEX 24.2+ and ORDS running in minutes using any container runtime (Docker, Podman, etc.) with automated setup scripts.
Oracle APEX Local Development Environment - Containerized Setup
Set up Oracle APEX local development in minutes. A containerized environment that makes building and testing APEX applications on your machine effortless.
uc-local-apex-dev is a containerized Oracle APEX development environment that automates the tedious parts of administering a local environment. Works with Docker, Podman, or any container runtime. Get a complete Oracle 26ai database with APEX and ORDS (with SSL) running on your machine, plus convenient bash scripts that handle workspace creation, backups, schema clearing, and script/APEX application testing with a single command.
Key Features
Section titled “Key Features”Oracle 26ai
Run the latest Oracle Database 26ai Free with all features enabled and pre-configured for development.
One-Command Operations
Simple wrapper script (local-26ai.sh) turns complex tasks into single commands: create users, backup workspaces, clear schemas, test installs.
Automated User Management
Create users and workspaces with optimal development grants using a single command. Users are automatically registered in SQLcl and VS Code for instant access.
Backup & Restore
Built-in Oracle DataPump integration for easy backup and restore of schemas, workspaces, and applications with a single command.
Installation Testing
Test APEX application installs and SQL scripts repeatedly in isolated test users. Automatically validates dependencies and installation success.
HTTPS/SSL Ready
ORDS runs with SSL support using self-signed certificates for secure local development matching production environments.
PL/SQL Debugging
Pre-configured with all necessary grants and settings for VS Code SQL Developer debugger and SQLcl development.
Perfect for Local APEX Development
Section titled “Perfect for Local APEX Development”This containerized environment is specifically designed for Oracle APEX developers who need a local development database and want to:
- Develop Locally: Work on APEX applications without needing a remote database, cloud instance, or apex.oracle.com
- Test Installation Scripts: Clear schemas and test APEX application installs multiple times with zero hassle
- Rapid Prototyping: Spin up new workspaces and test schemas instantly for experimenting with ideas
- Debug PL/SQL Code: Use VS Code SQL Developer debugger with all proper grants pre-configured
- Manage Workspaces: Create and manage multiple APEX workspaces and database schemas with ease
- SSL: Run ORDS with SSL locally to match production environments or to not run into protocol missatch errors
- Automated Backups: A single script to export all your schemas, APEX workspaces, and applications, plus ORDS modules
- Safe Testing Environment: Experiment with new APEX features without risk to production or shared development databases
What’s Included
Section titled “What’s Included”- Oracle Database 26ai Free: Latest Oracle database with all development features
- Latest Oracle APEX: Full APEX installation with admin access
- Oracle ORDS with SSL: REST Data Services pre-configured with self-signed certificates
- Automated Scripts: 20+ bash scripts for common development tasks via simple wrapper
- Development Grants: All necessary permissions for debugging, DataPump, and workspace management
- SQLcl Integration: All created users automatically registered for instant connections
- VS Code Integration: All created users available in VS Code SQL Developer extension and PL/SQL debugging support
Important Note
Section titled “Important Note”⚠️ This is not for production use! The environment is intentionally configured to be unsecure and optimized for ease of development. Passwords are stored in plain text, all security features are relaxed, and the focus is on speed and convenience over security. Use at your own risk and run backups regularly.