Gitpod Workspace for Oracle Database Free 23ai–click and run, free and in 7 minutes image 110

Gitpod Workspace for Oracle Database Free 23ai–click and run, free and in 7 minutes

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:

image

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:

image

The Gitpod workspace opens and starts processing the initialization scripts – mainly pulling the database container (1.8 GB) and starting the database.

image

Terminal window 1 – connected to database in container through SQLcl running outside container:

image

Terminal window 2 (connected as SYS inside the container with SQL*Plus):

image

Terminal window 3 (connecting as user APP in PDB FREEPDB1 with SQLcl from outside the container):

image

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/


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.