Oracle XE Installation on Hortonworks Data Flow (HDF)

Hi, in this artile, i will show you how to install Oracle Express Edition (XE) on HDF (Hortonworks Data Platform).

First of all, I assume that HDF platform is installed in your Virtual machine (Oravle VM or VMware), connect to the virtual machine with ssh from the web browser or any ssh tools.

 

Before installing the Oracle database, please install the rpm package that will install the necessary packages and users.

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

After this process, you should see the preinstall package as in the picture.
blank

yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

After installing the Preinstall package, we can start installing the oracle xe version.

wget https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm
blank
The download may take some time. After the download is finished, you can install it with the code below.
yum -y localinstall oracle-database-xe-18c-1.0-1.x86_64.rpm

blank

After the installation is complete, you should run the following command for configuration;
/etc/init.d/oracle-xe-18c configure
After running the command, it will ask you for a password for SYS, SYSTEM and PDADMIN, after entering the password, it will start configuring for installation.
blank

We have to set the required enviroments for Oracle in our operating system,

 

export ORACLE_SID=XE
export ORAENV_ASK=NO

. /opt/oracle/product/18c/dbhomeXE/bin/oraenv

Now we can connect to the database from the terminal with sqlplus.

blank

 

 

Apache Kafka Producer Example With Java

 4,342 views last month,  211 views today

About Deniz Parlak

blank
Hi, i’m Security Data Scientist & Data Engineer at My Security Analytics. I have experienced Advance Python, Machine Learning and Big Data tools. Also i worked Oracle Database Administration, Migration and upgrade projects. For your questions parlak.deniss@gmail.com

Check Also

blank

Apache Kafka Producer Example With Java

Hi, everyone in this tutorial we will make Kafka producer example with Java. There are …

Leave a Reply