It has been more than two and a half years since Oracle 18c XE has been released for Linux. Since then things have changed and one of these changes was the release of Linux 8 about nine months later. Unfortunately, installing Oracle 18c XE on Linux 8 is no longer quite as straightforward as it was with Linux 7 – a simple
yum command. That is because the
oracle-database-preinstall-18c is not provided for Linux 8. However, installing Oracle 18c XE on Linux 8 is still possible, it just requires a few more keystrokes.
Execute all commands as
Continue reading “How to install Oracle Database 18c XE on Linux 8”
curl -OL https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm
dnf install -y /bin/bash /bin/sh /etc/redhat-release bc bind-utils binutils ethtool glibc glibc-devel initscripts ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make module-init-tools net-tools nfs-utils openssh-clients pam procps psmisc smartmontools sysstat unzip util-linux-ng xorg-x11-utils xorg-x11-xauth libnsl
rpm -i --nodeps oracle-database-xe-18c-1.0-1.x86_64.rpm
Oracle has published its Oracle Database JDBC client libraries on Maven Central. From now on you can find Oracle Database related jar files under the
com.oracle.database group id. You will find all libraries from version 126.96.36.199 (e.g. ojdbc6) to 19.3.0 (e.g. ojdbc10).
Going forward, Oracle will use Maven Central as one of the primary distribution mechanisms for Oracle Database Java client libraries, meaning that you will also be able to find new versions of these libraries on Maven Central in the future.
To get the latest Oracle Database JDBC driver, use the following dependency GAV in your Maven POM file:
Continue reading “Oracle Database client libraries for Java now on Maven Central”
With great technology comes great possibility
Do you want to get your hands on an Oracle Database but don’t know how? Here are 5 ways to get you going.
Continue reading “5 ways to get an Oracle Database”
Get up and running with the free Oracle Database edition on Windows
In my previous post, I demonstrated how you can install Oracle Database 18c XE on Linux. In this post, you will learn how you can install Oracle Database 18c XE on Windows. I am performing the installation on Windows 10 but it should remain the same for all Windows versions.
Preparing for the installation
Before you can start the installation, you will have to download the Oracle Database 18c XE Windows installer zip file. Head over to https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html, click on “Accept License Agreement” and download the “Oracle Database 18c Express Edition for Windows x64” zip file.
Once you have downloaded the zip file, extract it anywhere.
Continue reading “How to install Oracle Database 18c XE on Windows”
Oracle Database 18c Express Edition can be enabled for automatic startup and shutdown with the Linux operating system. This will not only allow you not to worry about starting and stopping the database but it will also ensure that the database is properly shutdown before the machine is powered off. Enabling auto startup/shutdown is done via two simple commands:
systemctl enable oracle-xe-18c
These commands will have to be executed either via the
root user or with
[root@localhost ~]# systemctl daemon-reload
[root@localhost ~]# systemctl enable oracle-xe-18c
oracle-xe-18c.service is not a native service, redirecting to /sbin/chkconfig.
Executing /sbin/chkconfig oracle-xe-18c on
For more information about starting and stopping Oracle Database XE, have a look at the documentation.