Tag: Oracle

MuShop – A cloud-native reference app for Oracle Cloud

MyShop RunningMuShop is a cloud-native reference showcase app of several Oracle Cloud services. The app implements an e-commerce site for cat products built as a set of Microservices. The name MuShop leans on the term Microservices: Microservices –> μ –> Mu –> Meow –> MuShop. The code itself is hosted on GitHub. There are two implementations of MuShop, one is the Basic Deployment which runs entirely on the Oracle Cloud Free Tier. The other one is the Complete Deployment which is deployed on a Kubernetes cluster such as Oracle Kubernetes Engine (OKE). In this post, I will cover the Basic Deployment of MuShop.

Continue reading “MuShop – A cloud-native reference app for Oracle Cloud”

5 ways to get an Oracle Database

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”

How to install Oracle Database 18c XE on Windows

Get up and running with the free Oracle Database edition on Windows

Oracle Database 18c XE Successful InstallationIn 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.

Oracle 18c XE Download page

Once you have downloaded the zip file, extract it anywhere.

Oracle Database 18c XE extracted folder

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

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”