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. It automates the tedious parts of a local environment. It works with Docker, Podman, and any other container runtime.
You get a complete Oracle 26ai database with APEX and ORDS on your machine, with SSL. You also get bash scripts for the daily tasks. Each task is one command: create a workspace, run a backup, clear a schema, or test a script or an APEX application.
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 environment is for Oracle APEX developers who need a local development database. You can do the following with it:
- Develop Locally: Work on APEX applications without a remote database, a cloud instance, or apex.oracle.com
- Test Installation Scripts: Clear a schema and install an APEX application again, as many times as you need
- Rapid Prototyping: Create a new workspace and a test schema in one command
- Debug PL/SQL Code: Use the VS Code SQL Developer debugger. The scripts add all necessary grants
- Manage Workspaces: Create and manage many APEX workspaces and database schemas
- SSL: Run ORDS with SSL, the same as in production. This prevents protocol mismatch errors
- Automated Backups: One script exports all your schemas, APEX workspaces, applications, and ORDS modules
- Safe Testing Environment: Try new APEX features without a risk to production or to a shared development database
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: More than 20 bash scripts for common development tasks, through one wrapper
- Development Grants: All necessary permissions for debugging, DataPump, and workspace management
- SQLcl Integration: Every new user is in the connection store of SQLcl
- VS Code Integration: Every new user is in the VS Code SQL Developer extension, with PL/SQL debugging
Important Note
Section titled “Important Note”⚠️ Do not use this environment in production. It is insecure by design. It stores the passwords in plain text and relaxes all security features. Run backups regularly.