How to install Python 3 on Oracle Linux

Oracle Linux 7 doesn’t come with Python 3 by default but only with Python 2. Luckily, installing Python 3 can be done with two simple steps:

  1. sudo yum install -y oracle-epel-release-el7
  2. sudo yum install -y python36

The first step installs and enables the Oracle EPEL yum repository (EPEL – Extra Packages for Enterprise Linux) which includes the Python 3.6 version. In case the repository is already installed, yum will detect that and do nothing. So nothing will go wrong if you execute the command unnecessarily or twice.

Continue reading “How to install Python 3 on Oracle Linux”

How to enable auto start/shutdown for Oracle Database 18c Express Edition on Linux

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:

  1. systemctl daemon-reload
  2. systemctl enable oracle-xe-18c

These commands will have to be executed either via the root user or with root privileges:

[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.

How to install Oracle Database 18c XE on Linux

The new version of the free Oracle Database edition, Oracle Database 18c Express Edition, just got released for Linux 64-bit. Getting started is really simple on Oracle Linux, basically a three step process of downloading the RPM file, installing it and then configuring the database. On other Red Hat  compatible Linux distributions you will also have to download the Oracle Database Preinstall RPM alongside the XE RPM file. Here is a quick guide on how to setup Oracle Database 18c XE.

tl;dr

Oracle Linux

  1. Download the RPM file from Oracle Technology Network
  2. Run “yum -y localinstall oracle-database*18c*
  3. Run “/etc/init.d/oracle-xe-18c configure

Other Red Hat compatible Linux distribution

  1. Download the RPM file from Oracle Technology Network
  2. Download the Oracle Database Preinstall RPM via “curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
  3. Run “yum -y localinstall oracle-database*18c*
  4. Run “/etc/init.d/oracle-xe-18c configure

Continue reading “How to install Oracle Database 18c XE on Linux”

Oracle Database 18c Express Edition is Generally Available!

Oracle just released the new version of Oracle Database Express Edition (XE), a free edition of Oracle Database. This release means something special to me, as I have been closely involved in it and with the great team that brought us Oracle Database 18c XE.

Continue reading “Oracle Database 18c Express Edition is Generally Available!”

Autonomous Database: Creating an Autonomous Data Warehouse Instance

In my previous post I have shown how quick and easy it is to create an Oracle Autonomous Transaction Processing instance. In this post I want to show that the same applies for an Oracle Autonomous Data Warehouse, short ADW, instance. As a matter of fact, both services are running on the very same Oracle Autonomous Database infrastructure so you will see that the steps are the very same as with Autonomous Transaction Processing.

Just like with ATP, you can try ADW yourself today via the Oracle Free Cloud Trial.

tl;dr

To create an instance you just have to follow these three simple steps:

  1. Log into the Oracle Cloud Console and choose “Autonomous Data Warehouse” from the menu.
  2. Click “Create Autonomous Data Warehouse
  3. Specify the name, the amount of CPU and storage, the administrator password and hit “Create Autonomous Data Warehouse

Continue reading “Autonomous Database: Creating an Autonomous Data Warehouse Instance”

Autonomous Database: Creating an Autonomous Transaction Processing Instance

In this post I’m going to demonstrate how quick and easy one can create an Autonomous Transaction Processing, short ATP, instance of Oracle’s Autonomous Database Cloud Services. Oracle’s ATP launched on the 7th of August 2018 and is the general purpose flavor of the Oracle Autonomous Database. My colleague SQLMaria (also known as Maria Colgan 😉 ) has already done a great job explaining the difference between the Autonomous Transaction Processing and the Autonomous Data Warehouse services. She has also written another post on what one can expect from Oracle Autonomous Transaction Processing. I highly recommend reading both her articles first for a better understanding of the offerings.

Last but not least, you can try ATP yourself today via the Oracle Free Cloud Trial.

Now let’s get started. Provisioning an ATP service is, as said above, quick and easy.

tl;dr

To create an instance you just have to follow these three simple steps:

  1. Log into the Oracle Cloud Console and choose “Autonomous Transaction Processing” from the menu.
  2. Click “Create Autonomous Transaction Processing
  3. Specify the name, the amount of CPU and storage, the administrator password and hit “Create Autonomous Transaction Processing

Continue reading “Autonomous Database: Creating an Autonomous Transaction Processing Instance”

Autonomous Database Blog series

Oracle has just released the Oracle Autonomous Transaction Processing Cloud Service. This is the second service of the Oracle Autonomous Database Cloud Services, after Oracle Autonomous Data Warehouse Cloud Service which launched earlier this year. I have been asked to produce some collateral for the new offerings which will surface here as well as on other sites. I hope they will be interesting for you and give you some insights into the technologies, how they work, and how you can get the most out of them.

All blog posts will be marked with the tag Oracle Autonomous Database to make it easier for you to filter them.

If you are interested and want to read and hear even more on Oracle Autonomous Database you should also follow SQLMaria‘s blog: https://sqlmaria.com/category/autonomous-database/

Setting up Docker on Oracle Linux 7

Docker has become widely popular in the last couple of years. I use it on a regular basis these days for running Oracle databases on my laptop. Docker is available on all popular Linux distributions, as well as Mac and Windows, and of course Oracle Linux is no exception. Since a long time Docker ships with the Oracle Linux 7 addons yum repository. Having setup Docker on Oracle Linux numerous times, I thought it would be good for me to document my steps for others to follow.

tl;dr

  1. Update Oracle Linux and UEK to the latest version (OL 7 and UEK5): yum upgrade
  2. Install yum-config-manager, if not already installed: yum install yum-utils
  3. Enable the addons yum repo: yum-config-manager --enable *addons
  4. Install docker-engine: yum install docker-engine

Continue reading “Setting up Docker on Oracle Linux 7”

Upgrading UEK kernel on Oracle Linux 7

linux_penguin_with_logoIn general I work almost exclusively on Macs these days. However, for work and various other reasons I always tend to have a VM with Linux on my Mac to test, run, script things. My VM runs Oracle Linux (OL) on VirtualBox. Oracle Linux just makes a lot of sense for me as we run everything on Oracle Linux internally and in general it is a solid Linux distribution. Of course, once in a while I have to update my Linux version as well to make sure that my Linux environment remains on the latest and greatest. Right now is such a time again as Oracle Linux 7 Unbreakable Enterprise Kernel 5 just released. In the past I was always a bit scared about upgrading kernels because I had little clue of what I was doing. 🙂 Turns out that it is a lot easier than one might think, and here is how you do it:

tl;dr

  1. Download new repo list: wget http://yum.oracle.com/public-yum-ol7.repo
  2. Enable the new repo: yum-config-manager --enable ol7_UEKR5
  3. Upgrade the environment: yum upgrade
  4. Reboot the environment: reboot

Continue reading “Upgrading UEK kernel on Oracle Linux 7”

Creating an Oracle Database Vagrant box

Oracle recently launched a new GitHub repository for providing people with Oracle software inside Vagrant boxes. If you have ever setup an Oracle database inside a VirtualBox VM, whether it is as your sandbox environment, to explore Oracle database, or to use it as a full-on development environment, things have just gotten a lot easier for you. With Vagrant, you can now provision an Oracle database inside VirtualBox in a matter of a couple of simple steps.

Continue reading “Creating an Oracle Database Vagrant box”