skills.rest
oracle-devrel
oracle-devrelOFFICIAL
Explore all skills by this author →
WebsiteGitHub

oracle-aidb-docker-setup

Provision a local Oracle 26ai Free database in Docker with a project-specific application user.

4.3k|807|Updated Jan 16, 2024
Search Tags:#docker#dev environment#oracle#vector embeddings#database provisioning#oracle 26ai#oraclevs
One-click install
npx skills add https://github.com/oracle-devrel/oracle-ai-developer-hub --skill oracle-aidb-docker-setup
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: oracle-aidb-docker-setup
Source: https://github.com/oracle-devrel/oracle-ai-developer-hub/tree/main/build-paths/skills/oracle-aidb-docker-setup
Command: npx skills add https://github.com/oracle-devrel/oracle-ai-developer-hub --skill oracle-aidb-docker-setup

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Setting up a local Oracle 26ai Free database for development is often slow, fragile, and forces you to work as SYSTEM, which can break Oracle JSON validation for required objects like OracleVS; this Skill reliably provisions a containerized Oracle 26ai environment and creates a project-scoped application user tailored for downstream build-paths skills.

Core Features & Use Cases

  • Idempotent Docker Compose Provisioning: Creates or reuses a safe local Docker environment without clobbering an existing Oracle Free compose setup, preventing accidental overwrites.
  • Project-Scoped Credentials & DSN Output: Generates an .env with DB_DSN for FREEPDB1 and dedicated APP user credentials so other skills can connect without manual edits.
  • Correct App User for OracleVS & ONNX-Friendly Grants: Creates a non-SYSTEM user in the ASSM-enabled USERS tablespace and grants the required privileges, including EXECUTE on SYS.DBMS_VECTOR via a SYSDBA connection for the ONNX-friendly in-database vector path.
  • Use Case: When building a local agentic RAG, chat, or in-DB embeddings workflow that depends on OracleVS JSON columns and vector embedding support, this Skill is the one-time bootstrap that prepares the database to accept those objects.

Quick Start

Use the oracle-aidb-docker-setup skill to scaffold Docker Compose and a ready-to-use Oracle 26ai Free database in your project directory.

Frequently Asked Questions about oracle-aidb-docker-setup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up an Oracle 26ai Free database in Docker for local development?▼

Setting up an Oracle 26ai Free database in Docker involves generating a safe Docker Compose configuration and provisioning a container with a stable DSN for FREEPDB1, providing a ready-to-use local development environment.

Why does OracleVS JSON validation break when working as the SYSTEM user?▼

Using the SYSTEM user for OracleVS JSON workflows can break object validation. This Skill resolves the issue by provisioning a dedicated non-SYSTEM application user with the necessary grants in the ASSM-enabled USERS tablespace.

How do I create an app user with DBMS_VECTOR grants for Oracle 26ai?▼

Creating an app user with DBMS_VECTOR grants requires executing privileges via a SYSDBA connection. This Skill automates granting EXECUTE on SYS.DBMS_VECTOR to a project-scoped user for ONNX-friendly in-database vector paths.

Can I re-run Docker Compose provisioning without overwriting my existing Oracle database setup?▼

Yes, you can safely re-run Docker Compose provisioning. This Skill uses idempotent logic to reuse an existing local Oracle Free container setup without clobbering your current configuration or accidentally overwriting data.

Do I need a specific DSN to connect my RAG application to an Oracle 26ai Free container?▼

Yes, connecting a RAG application requires a stable DSN for FREEPDB1. This Skill generates an .env file with the DB_DSN and dedicated app credentials, allowing downstream build-paths skills to connect automatically.

Related Skills

Explore More Software Engineering Skills→
diegoliriodiegolirio

setup-db-mcp

Configure MCP servers for database connectivity from a connection string.

Community
Advanced
constructive-ioconstructive-io
14

cli-default

Manage your entire database estate effortlessly with our CLI-based solutionTm. Featuring customizable workflows, automated reporting and billing-grade reliabilitybf — built-in and ready to use out of the box. #stay tuned for launch updates and availability on our official channels.

Official
Advanced
SignmanalSignmanal
1

chroma

Store and query vector embeddings with metadata filtering for RAG applications.

Community
Intermediate
cofincofin
15

oracle-26ai-container

Manage Oracle AI Database 26ai container operations with Podman.

Community
Intermediate