At first, I thought of a private one that would only be visible to me.
#Oracle database xe free
Luckily, Docker (still) provides free repositories. Next, I needed to put the images into some repository from where I could pull them. A git repository was obviously the way to go, and so I did. So I ventured off on a journey of stripping down the XE installation and quickly realized that I needed to document those steps for when a new version of XE will come out. The only way I saw to provide the best of both worlds was to offer them by providing a small, stripped-down image and a big one with all the great bells and whistles of Oracle XE. More functionality means more libraries and files in the $ORACLE_HOME and that, in turn, means a bigger image. Sure, sometimes I want to be able to just quickly pull a small image to test a bunch of INSERTs, but I also want to be able to use, e.g., Oracle’s Spatial functionality. While I was at it, I thought of the many conversations that I had about the trade-off between image size and additional functionality. And about five months later, the outcome is yet another Docker Hub repository: Why a repository? So, on some Saturday, I sat down to “quickly” put together some new build files for XE, applying some of the lessons learned in the process. I too needed a quick and easy XE Docker image, yet Oracle’s Container Registry did not host an XE image yet (it does now, since about two weeks ago), and all images on Docker Hub that I could find were old 11g R2 XE ones.
#Oracle database xe how to
However, my own needs for some of my private projects such as #csv2db have also caused me to think about how to better streamline and integrate Oracle XE into my own pipelines. A lot of things have changed since then, and I’m happy that my engineering colleagues at Oracle have taken on the maintenance and further enhancements of Oracle’s official Docker build files and images, and integrated them into the internal processes. Pretty much ever since I put together the first official build scripts for Oracle Database, people have asked for faster image pull and startup times to speed up their continuous integration tests. More details about the announcement are here.One of the things that kept me busy lately was experimenting with how much an Oracle XE database setup could be streamlined inside a Docker image for things like CI/CD consumption. In addition, Oracle Application Express (APEX), Oracle’s popular low-code app development platform, can be easily deployed on top of Oracle Database 21c XE!Īlso worth mentioning is Connor McDonald's easy installation video as well as the Quick Start Guide. Data access can also be REST-enabled, when combined with Oracle REST Data Services, allowing interaction with the data over standard RESTful web services. This version provides all the features of a true converged database, providing support for Relational, JSON, XML, Graph, Spatial, Blockchain, Object, and Key/Value data for free.
#Oracle database xe update
Gerald also mentioned an important update to Oracle Database 21c XE: it lifts the restriction on the number of pluggable databases! Unlike the previous version of Oracle Database XE, which only allowed up to 3 Pluggable Databases (PDBs), Oracle Database 21c XE now includes all functionality of the Multitenant feature! Today, Gerald Venzl announced the general availability of the free version of the Oracle database 21c: the eXpress Edition (or XE) for Linux platforms (direct links are provided inside the original announcement, see at the end of this post).
0 kommentar(er)
