Search for a command to run...
"Bumpy roads lead to beautiful places"
No comments yet. Be the first to comment.
This series will walk through the steps in order to install a local development environment that includes Oracle 23ai, ORDS & APEX.
Running Oracle Database 23ai & ORDS Locally via Containers
I saw Dimitri's post on SQL Assertions today and it piqued my curiosity. Putting more business rules closer to data is almost always a great idea, as you can now call DML from any technology and rest
Almost 20 years ago to the date, I submitted my resignation to Oracle to go start my own company. It was a difficult decision to make, as APEX - or HTML DB as it was called then - was just starting to gain traction. However, I was presented with an o...
One of the more difficult parts of the software development lifecycle is deployment. While it seems simple on the surface - just write some scripts and run them - it gets pretty complicated pretty quickly as the level of sophistication of your system...
Another AI-centric tool that has raised a lot of interest is Claude Desktop. Like Cline, Claude Desktop uses the same reasoning engine at the core - Claude Code - to assist with development tasks. While they share the same engine, there are use cases...
When I first heard the term MCP used in the context of AI, I was immediately taken back to the 80s when the movie Tron was released. For those who have not seen it, Tron is a futuristic movie about a curious user who is literally sucked into a comput...
In our last post, we added DBMS_CLOUD to our Oracle 23ai Container. Since that change was done via adding database objects, the version of our container is now different than what we had downloaded. Additionally, we’ve upgraded the database objects for APEX a couple of posts back, adding more delta from the container we downloaded.
Thus, if we wanted to quickly spin up a new, fresh database that looks like the one we have, we’d be out of luck. While upgrading APEX & adding DBMS_CLOUD only take minutes, it could get repetitive if we need to do this regularly. And that’s just all that’s different today - things will change as we add more features & applications over time.
To solve this issue, we can create a new image from our container. That image can then be used to create new containers - just like we’ve used the images provided by Oracle.
To wrap up this series, let’s walk through how we can create an image based on our container so that we can spin up new containers that have DBMS_CLOUD, APEX and anything else we want pre-installed.
We’ll start by creating a new image.
oracle container.It is important to stop the container before committing it, otherwise you risk saving a corrupt container.
podman commit oracle
This will take a few minutes to complete. You should see something similar to the screenshot below as this is running:
Next, let’s get a list of all images on our local repository.
podman images
You should see something similar to the screenshot below:
Take note of the IMAGE ID of the REPOSITORY named <none>.
Run the following command, replacing [IMAGE ID] with the IMAGE ID from the previous step.
podman tag [IMAGE ID] oracle-new
localhost/oracle-new. This is the image that was just created and tagged.
Create a new container from the new image by clicking on the Play button.
Optionally enter a Container Name and click Start Container and you should be up and running right where you left off!
Ideally, you would destroy your original Oracle Database container first and then use the command line to create a new one based off of the new image. You can do that by running this code:
podman run --name oracle --ip 10.88.0.2 -p 1521:1521 localhost/oracle-new
Creating a new image based on a changed container is a helpful way to preserve your work, should you need to start over from a specific place. Keep in mind that if a new Oracle 23ai image was posted by Oracle, you would need to pull that down and re-apply all of the infrastructure changes there. Thus, it’s a good idea to try to keep any of these changes scripted so that they can be applied quickly and in a single script.
This post will likely wrap up the series Containerized, Local Oracle 23ai Environment - at least for now. I’m sure that I’ll find additional things that I want to add to my local development environment, and when I do, I’ll be sure to add them to this series.
If you haven’t already, be sure to start at the first post and go through all of them. I’ve tried to be as specific as possible and provided detailed steps, code snippets and screen shots. Having said that, there’s likely issues and/or typos that make things less than perfect. Please let me know if you find one of those, as I can quickly correct it if and when necessary.
Photo by Samsung Memory on Unsplash