I am an enthusiastic user of Gitpod – a platform for ephemeral cloudbased workspaces. Click on a URL and a workspace is started for you (and for me). From scratch, with plenty of resources and fully installed based on a Infra as Code definition in a Git repository. I have created several Gitpod workspace definitions for various technologies, including previous ones for Oracle Database XE 21c and Free 23c. This article introduces the workspace for Oracle Database Free 23ai (23.4.0.4.24) using the “official” Oracle container image.
You click on this link, wait for 5-8 minutes and a fresh environment is available for you that looks like this picture:
A cloud based Linux (Ubuntu) environment with a running container that contains a newly created fresh Oracle Database Free 23ai (at the time of writing that means 23.4.0.. One PDB is precreated, two users are set up. SQLcl is installed outside the container and SQL*Plus is available inside the container. Connecting to the database using an SSH remote connection is quite straightforward too.
Here are the screenshots that illustrate what you will see when you run the workspace:
Run the workspace:
The Gitpod workspace opens and starts processing the initialization scripts – mainly pulling the database container (1.8 GB) and starting the database.
Terminal window 1 – connected to database in container through SQLcl running outside container:
Terminal window 2 (connected as SYS inside the container with SQL*Plus):
Terminal window 3 (connecting as user APP in PDB FREEPDB1 with SQLcl from outside the container):
Resources
Link to open the Gitpod workspace for Oracle Database 23ai – https://gitpod.io/#https://github.com/lucasjellema/gitpod-oracle-database-23ai-free-
GitHub Repository with Gitpod Workspace definition: https://github.com/lucasjellema/gitpod-oracle-database-23ai-free-
Link to Oracle Container Registry with the container image for Oracle Database 23ai to download: https://container-registry.oracle.com/ords/f?p=113:4:2674354842458:::4:P4_REPOSITORY,AI_REPOSITORY,AI_REPOSITORY_NAME,P4_REPOSITORY_NAME,P4_EULA_ID,P4_BUSINESS_AREA_ID:1863,1863,Oracle%20Database%20Free,Oracle%20Database%20Free,1,0&cs=33IH4gtTe8pk7MyXUDJbv-zEuD6C-pIcPJZthvsM3AQkjKMNpmy5OOSHIXXVkud3J4eER6KDWOqq-ev63NHJn_A
Announcing Oracle Database 23ai : General Availability – https://blogs.oracle.com/database/post/oracle-23ai-now-generally-available
Oracle Database 23ai – documentation – https://docs.oracle.com/en/database/oracle/oracle-database/23/index.html
My earlier article on Gitpod Workspace for Oracle Database Free 23c – the predecessor to 23ai – https://technology.amis.nl/database/get-going-with-oracle-database-23c-free/