QuickStart to Development using Oracle Database FREE 23ai Container Images

QuickStart to Development using Oracle Database FREE 23ai Container Images

Happy Friday Y'all!

This is a quick blogpost on setting up an Oracle 23ai FREE Container Image locally and getting started with Database Adventures with Oracle 23ai!


Step1: Create a Docker Network

docker network create --driver=bridge --subnet=192.168.11.0/24 --gateway=192.168.11.1 oracle23ai-bridge-network        

You are free to use whatever subnet you wish.

Step 2: Pull down the Oracle23ai FREE Image from Gerald Vinzl's Repository on either Docker hub or Github Container Registry


The links are below

Docker Hub - gvenzl/oracle-free - Docker Image | Docker Hub

Github - Package oracle-free


Step 3: Run the Container

Note: You will need to put in a Password with the Environment Variable of ORACLE_PASSWORD as shown below

You may use your custom name and hostname and password.


docker run -itd --name anil23aiFREE --hostname anil23aiFREE -p 1577:1521 -e ORACLE_PASSWORD=YourStr0ngP@$$W0rd --network  oracle23ai-bridge-network gvenzl/oracle-free  bin/bash        

Now run

docker ps

d24bbdf2ddc5   gvenzl/oracle-free   "container-entrypoin…"   33 minutes ago   Up 33 minutes   0.0.0.0:1577->1521/tcp   anil23aiFREE        

Finally let's login to the container and execute lsnrctl status and connect to the Container DB and show our PDBs



LSNRCTL Status


SQLPLUS



SHOW PDBs


Finally let's connect from VSCode using the SQL Developer Extension for VSCode


Create a Connection



SQL Developer for VSCode

Congrats! you have just setup a fully working Oracle 23ai FREE 23.6 environment using Containers!

Stay tuned for more tutorial setups...

#Oracle23ai

#Docker

#DockerContainers

#DatabaseManagement

#OracleDatabase

#DevOps

#CloudComputing

#Containerization

#TechTutorials

#DatabaseContainers

#OracleDev

#DatabaseDeployment

#TechGuides

#OracleDocker

#SoftwareDevelopment



要查看或添加评论,请登录

Anil Mahadev的更多文章

社区洞察

其他会员也浏览了