Oracle XE Installation on Hortonworks Data Flow (HDF)

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.

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

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.

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.

 

 

Apache Kafka Producer Example With Java

 6,025 views last month,  2 views today

About Deniz Parlak

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 [email protected]

Leave a Reply

Do NOT follow this link or you will be banned from the site!