Hello guys, its been more than 8 months since i published my last article. Sorry for the delay.
Lately, I have been facing a problem which i am sure many of us faced once in a while and that’s “How to \”Successfully\” install Oracle Express Edition on ubuntu 14.04″. Well let me tell you one thing straight, its not as easy as installing oracle in windows and lots of article out there tell you the same thing and this article is not standing out. But i tell you things from my perspective and the problems i faced and how i successfully install oracle.
Firstly, download oracle express edition from here. (You probably need a free oracle account in case if you don’t have one). After downloading the RPM file, first you need to place it in some other base folder where all your oracle directories reside. So copy paste it from downloads to your /home/basefolder.
First thing you need to learn is that the downloaded file is in RPM format and your ubuntu uses .deb (Debian) format, So you need to convert RPM package to .deb Package.
In order to convert RPM package to .deb package you most probably need alien software program written by Joey Hess. It converts between LSB (Linux Standard Based) , LSB based RPM packages , .deb Packages and solaris (.pkg) and many more. Just install the package by following command (in case you don’t have one)
sudo apt-get install alien
After installing alien and copying oracle RPM package to some base folder just unzip that package using unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip.
After unzipping oracle zip file , Disk1 named folder is created which contains your RPM package of oracle. So type in:
Now you need to convert this RPM package to .deb package, for this just type in:
sudo alien –scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm
This command converts your RPM package to .deb package. (Note that this command takes some time to execute, so you have to wait for some time. Meanwhile you can proceed to other tasks).
Now create a file in /sbin/ folder named as chkconfig and paste following in that file:
# Oracle 11gR2 XE installer chkconfig hack for Ubuntu
if [[ ! `tail -n1 $file | grep INIT` ]]; then
echo >> $file
echo ‘### BEGIN INIT INFO’ >> $file
echo ‘# Provides: OracleXE’ >> $file
echo ‘# Required-Start: $remote_fs $syslog’ >> $file
echo ‘# Required-Stop: $remote_fs $syslog’ >> $file
echo ‘# Default-Start: 2 3 4 5’ >> $file
echo ‘# Default-Stop: 0 1 6’ >> $file
echo ‘# Short-Description: Oracle 11g Express Edition’ >> $file
echo ‘### END INIT INFO’ >> $file
update-rc.d oracle-xe defaults 80 01
Save above file and provide following privileges:
sudo chmod 755 /sbin/chkconfig
Next step is to set some kernel parameters
sudo gedit /etc/sysctl.d/60-oracle.conf
After executing above command a file named 60-oracle.conf opened in gedit. Add following lines in it and then save it.
Starting Oracle Database 11g Express Edition instance.
SQL*Plus: Release 184.108.40.206.0 Production on Tue Jul 5 00:14:10 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Oracle Database 11g Express Edition Release 220.127.116.11.0 – 64bit ProductionSQL>