Follow Us on Twitter

Installing Java, Oracle 11g R2 Express Edition and SQL Developer on Ubuntu 64-bit

by Mike Heeren on March 18, 2014 · 237 comments

A while ago I tried to install Oracle 11g R2 Express Edition on a 64-bit Ubuntu machine. This proved to be not as easy as you would expect. There are many blogs and articles about this subject and I tried a number of them. Unfortunately neither of the instructions seemed to work completely on my machine. With the combined information from the authors, I finally got it to work and I’ll gladly share my recipe in this blog. I have also included the installation steps for SQL Developer en Java (which is needed to install SQL Developer) in this blog. The installation was performed on a Ubuntu 12.04 VM with the following software.

This cookbook works with exacty the herefore mentioned versions… be aware that if you try to install a different version of one component, the steps below may not work. For example newer version of SQL Developer may require a more recent version of Java.

Installing Java

We start with installing Java on the machine. My personal preference is to use Oracle Java JDK. Installing this JDK could be done easily by performing the following statements.

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer

The screen in figure 1 will appear in the terminal, hit enter to proceed. After this, the screen in figure 2 will be shown. Navigate to <Yes> using the left arrow on your keyboard and hit enter. Oracle JDK 7 will be installed.

Binary Code license

Figure 1: Binary Code license

JDK License Agreement

Figure 2: JDK License Agreement

To validate the Java installation, execute the following command:

java -version

This should result in the following (or something similar).

java version “1.7.0_51”
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)

The next next step is to set the JAVA_HOME environment variable. To do this, open the /etc/bash.bashrc file by executing the following statement.

sudo gedit /etc/bash.bashrc

Scroll to the bottom of the file and add the following lines.

export JAVA_HOME=/usr/lib/jvm/java-7-oracle
export PATH=$JAVA_HOME/bin:$PATH

Save the file and close the editor. To load the changes, execute the following statement.

source /etc/bash.bashrc

To validate the changes you can execute the following statement.

echo $JAVA_HOME

The result of this statement should be the following.

/usr/lib/jvm/java-7-oracle

Installing Oracle 11g R2 Express Edition

For the installation of Oracle 11g R2 Express Edition (XE), a couple of additional Linux packages are required. These packages can be installed by executing the following statement.

sudo apt-get install alien libaio1 unixodbc

The next step is to download the Oracle 11g R2 Express Edition from the Oracle website. Make sure you select the Linux x64 version from http://www.oracle.com/technetwork/products/express-edition/downloads/index.html. After the download is completed, open the terminal and navigate to the download directory. In my case this can be done by executing the following statement.

cd Downloads

The next step step is to unzip the downloaded file. To do this, execute the following command.

unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip

A new directory (Disk1) is added to the Download directory. Navigate to this directory:

cd Disk1

Now we have to convert the Red Hat package (rpm) to a Debian package. This may be done using the alien command. The -d parameter is used to inform alien that a Debian package should be generated. When the -scripts parameter is toggled, alien will try to convert the scripts that are meant to be run when the package is installed and removed.

sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

This step may take a while, while this statement is executing we can do the following steps. Open a new terminal window for these steps.

The Red Hat package, relies on the /sbin/chkconfig file, which is not used in Ubuntu. To successfully install Oracle XE we use a simple trick. Start by creating a custom /sbin/chkconfig file by executing the following statement.

sudo gedit /sbin/chkconfig

Copy and paste the following into the editor:

#!/bin/bash
# Oracle 11gR2 XE installer chkconfig hack for Ubuntu
file=/etc/init.d/oracle-xe
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
fi
update-rc.d oracle-xe defaults 80 01
#EOF

Save the file and close the editor. Now we have to provide the file with the appropriate execution privileges.

sudo chmod 755 /sbin/chkconfig

After this, we have to create the file /etc/sysctl.d/60-oracle.conf to set the additional kernel parameters. Open the file by executing the following statement.

sudo gedit /etc/sysctl.d/60-oracle.conf

Copy and paste the following into the file. Kernel.shmmax is the maximum possible value of physical RAM in bytes. 536870912 / 1024 /1024 = 512 MB.

# Oracle 11g XE kernel parameters  
fs.file-max=6815744  
net.ipv4.ip_local_port_range=9000 65000  
kernel.sem=250 32000 100 128 
kernel.shmmax=536870912

Save the file. The changes in this file may be verified by executing:

sudo cat /etc/sysctl.d/60-oracle.conf

Load the kernel parameters:

sudo service procps start

The changes may be verified again by executing:

sudo sysctl -q fs.file-max

This method should return the following:

fs.file-max = 6815744

After this, execute the following statements to make some more required changes:

sudo ln -s /usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch /var/lock/subsys/listener

Close the second terminal window and return to the first terminal window. The rpm package should be converted and a new file called oracle-xe-11.2.0-2_amd64.deb have been generated. To run this file, execute the following command:

sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb

Execute the following to avoid getting a ORA-00845: MEMORY_TARGET error. Note: replace “size=4096m” with the size of your (virtual) machine’s RAM in MBs.

sudo rm -rf /dev/shm
sudo mkdir /dev/shm
sudo mount -t tmpfs shmfs -o size=4096m /dev/shm

Create the file /etc/rc2.d/S01shm_load.

sudo gedit /etc/rc2.d/S01shm_load

Copy and paste the following in the file. Note: replace “size=4096m” with the size of your machine’s RAM in MBs.

#!/bin/sh
case "$1" in
start) mkdir /var/lock/subsys 2>/dev/null
touch /var/lock/subsys/listener
rm /dev/shm 2>/dev/null
mkdir /dev/shm 2>/dev/null
mount -t tmpfs shmfs -o size=4096m /dev/shm ;;
*) echo error
exit 1 ;;
esac

Save the file, close the editor and provide the appropriate execution privileges.

sudo chmod 755 /etc/rc2.d/S01shm_load

Configuring Oracle 11g R2 Express Edition

If you have successfully installed to Oracle 11g R2 Express Edition server, it’s time to configure the server. To start the configuration of the server, execute the following command and follow the “wizard” in the terminal. Default values are shown between brackets for each question.

sudo /etc/init.d/oracle-xe configure

Now it is time to set-up some environmental variables. Open the /etc/bash.bashrc file by executing the following statement:

sudo gedit /etc/bash.bashrc

Scroll to the bottom of the file and add the following lines.

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH

Save the file and close the editor. To load the changes, execute the following statement:

source /etc/bash.bashrc

To validate the changes you can execute the following statement.

echo $ORACLE_HOME

This statement should result in the following output.

/u01/app/oracle/product/11.2.0/xe

After this step it is recommended to reboot the machine. After the reboot is completed, you should be able to start the Oracle server using the following command:

sudo service oracle-xe start

A file named oraclexe-gettingstarted.desktop is placed on your desktop. To make this file executable, navigate to you desktop.

cd ~/Desktop

To make the file executable, execute the following statement.

sudo chmod a+x oraclexe-gettingstarted.desktop

Installing SQL Developer

Finally, after the installation of Oracle 11g R2 Express Edition and Java, SQL Developer could be installed. This is done by performing the following steps.

Download Oracle SQL Developer from the Oracle site. Select the Linux RPM package: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html. Open a terminal window and navigate to the Download directory:

cd Downloads

Convert the Red Hat package to a Ubuntu package. Note: this may take a while.

sudo alien --scripts -d sqldeveloper-4.0.0.13.80-1.noarch.rpm

A file named sqldeveloper_4.0.0.13.80-2_all.deb will be generated. To run this file, execute the following statement:

sudo dpkg --install sqldeveloper_4.0.0.13.80-2_all.deb

Create a .sqldeveloper directory in your home folder:

sudo mkdir /home/.sqldeveloper/

Run SQL Developer from the terminal.

sudo /opt/sqldeveloper/sqldeveloper.sh

Now enter the full Java path. In my case this is done as follows:

/usr/lib/jvm/java-7-oracle

These steps worked for me to install Oracle XE and SQL Developer on Ubuntu 64-bit, and have been validated by one of my colleagues. I am curious to know if it worked for you. Please also let me know if you find any mistakes or have any additions to make this script better.

Good luck!

References:

http://sysadminnotebook.blogspot.nl/2012/10/installing-oracle-11g-r2-express.html

http://manpages.ubuntu.com/manpages/gutsy/man1/alien.1p.html

http://www.daniweb.com/hardware-and-software/linux-and-unix/threads/436584/installing-sql-developer-on-ubuntu-12.04

Installing Java, Oracle 11g R2 Express Edition and SQL Developer on Ubuntu 64-bit, 4.9 out of 5 based on 51 ratings
Ratings:
VN:D [1.9.22_1171]
Rating: 4.9/5 (51 votes cast)

{ 123 comments… read them below or add one }

Daniel May 2, 2014 at 7:32 pm

I could never managed to get it work on my system withouth this article… Shame on Oracle, BIG THANKS TO YOU!!

Reply

Anthony May 15, 2014 at 4:36 am

Excellent walkthrough! I was able to install Oracle on Ubuntu 14.04 with ease. The only change was when to invoke `oracle-xe configure`. It failed at first, so I updated bash.bashrc, rebooted then invoked `oracle-xe configure` and it started fine. Thank you for this walkthrough!

Reply

Andrew August 21, 2017 at 11:48 pm

What did you update on bash.bashrc? I have the same problem

Reply

Pramod Lamichhane May 21, 2014 at 6:53 am

I had been trying for a few days in ubuntu and was about to give up. I have no words to thank you! Never found such a nice/clear article. Whoever you are, you are great guy! Please try to put how one should do on Window 7 if you have time! I need to install in Window7 too but still unable to do so. 🙂

Reply

Seth Williams June 2, 2014 at 3:03 pm

A very useful tutorial Mike on installing Oracle 11g. You can check out some useful tutorials on …

:edit: no need for advertising your training company :edit:

Reply

ajay kumar singh June 7, 2014 at 12:37 pm

Hi Dude,

Thnks for the blog this is really awasom post,thanks once again!!!!!!!!!

Reply

Masudi June 7, 2014 at 2:23 pm

Thank a lot… Finnaly i get it done after seacrhing so many times…

Reply

Sam June 19, 2014 at 6:46 am

Thanks so much, this is the best instruction. It works!!

Reply

Adam Arlett July 10, 2014 at 12:50 am

Why don’t you have this whole process as a wget and bash script?

It’s nice to see the steps, but much nicer to clickety click.

Reply

Frank Dorst July 10, 2014 at 1:52 pm

Hi Adam,
Great idea, but what would you learn from that 😉
Please share your scripts when you have them available.
Frank

Reply

Owen July 12, 2014 at 10:27 am

Excellent, step by step guide. Works perfectly. Thank you.

Reply

karl.kallavus July 17, 2014 at 2:39 pm

Great Job! Thank you very much!

Reply

Facundo July 31, 2014 at 7:28 pm

Awesome!, it was just copy and paste to make it work!
Thank you so much for your time making this blog!

Reply

G.Venugopalan August 18, 2014 at 4:02 am

Excellent article. Every step explained and works first time without anything additional.

Thanks a ton !

G.Venugopalan

Reply

Vimbai Chatitai August 22, 2014 at 8:33 pm

WOrks like a charm (I’m an African, I know charms)… Thanks a million. I got serious headaches from trying the Oracle db on a previous Ubuntu installation with the other blogs – every Ubuntu user should bookmark this page.

Reply

watson August 24, 2014 at 3:51 pm

excellent help for newbies.. i could never imagine accomplishing without this help.. thanx

Reply

ping September 1, 2014 at 8:48 am

after the installation, execute the common user to dba group,

sudo usermod -a -G dba

then the xe database can be started/stopped in unity by just click ‘Start Database’ & ‘Stop Database’

Reply

Siva Madala September 3, 2014 at 7:13 pm

Wow, Thank you so much. Everything worked like a charm. Great Stuff!!

Reply

Deepak Anand September 9, 2014 at 5:06 am

Database Configuration Failed !!! what to do now?????

Reply

Mike Heeren September 10, 2014 at 9:21 am

Hello Deepak,

I assume the failure occurred after the “sudo /etc/init.d/oracle-xe configure” command?

Did you already try to reboot the system? After the reboot, execute the “sudo /etc/init.d/oracle-xe configure” command again.

Mike

Reply

Deepak Anand September 22, 2014 at 6:49 pm

Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

Reply

Deepak September 10, 2014 at 7:40 am

EXCELLENT Guide!!!! Thank you so much…
I successfully installed Oracle and SQL Developer on Ubuntu 14.4 following the above step by step instruction…

Reply

bhagya September 11, 2014 at 10:45 am

i could not install on my system. I have Ubuntu 14.04 64 bit on my system. Sony Vaio VPCEH28FN. It has an Intel x86 version i guess and not an amd64. What can be done. Please help.

Reply

surendra nath September 11, 2014 at 3:28 pm

Sir many many thanks to gave this data , i installed successfully java and oracle in my laptop . But i have some problem with oracle, after installation completing how to i connect with oracle data base. From my command prompt or some where else could u please tell me how to connect with database after completing instllation.
Thank You Sir ……..

Reply

neuronacreativa September 15, 2014 at 1:56 pm

Thanx so much for this awesome tip 🙂

Works great!

Reply

Abishek September 25, 2014 at 8:49 am

Thank you so much. Your tutorial saved me a ton. Tried on Ubuntu 64 , 14.04 LTS with 3.13.0-36-generic.

Reply

Semih Okan Pehlivan September 28, 2014 at 12:54 am

it was really really amazing for me. Thanks so much again again and again. very useful man 😉

Reply

chowdary October 3, 2014 at 12:23 am

it was really good blog keep going

Reply

David October 3, 2014 at 3:15 pm

I just used these instructions for java and oracle xe without any problems on ubuntu mate 14.10 beta2. thank you.

Reply

Dion October 7, 2014 at 4:16 pm

This tutorial is excellent. Congratulations! You did a great work.

Reply

me October 9, 2014 at 3:05 pm


After this step it is recommended to reboot the machine. After the reboot is completed, you should be able to start the Oracle server using the following command:


sudo service oracle-xe start

A file named oraclexe-gettingstarted.desktop is placed on your desktop. To make this file executable, navigate to you desktop.


cd ~/Desktop

To make the file executable, execute the following statement.


sudo chmod a+x oraclexe-gettingstarted.desktop

this doesn’t work for me – there ist no “oraclexe-gettingstarted.desktop” on my desktop… :/

Reply

Michal October 13, 2014 at 1:41 pm

Great Tutorial, but I got an error in final step after running /opt/sqldeveloper/sqldeveloper.sh :


Oracle SQL Developer
Copyright (c) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

LOAD TIME : 522#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007fe6383fabe0, pid=6544, tid=140626819884800
#
# JRE version: Java(TM) SE Runtime Environment (7.0_67-b01) (build 1.7.0_67-b01)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (24.65-b04 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C 0x00007fe6383fabe0
#
# Core dump written. Default location: /opt/sqldeveloper/sqldeveloper/bin/core or core.6544
#
# An error report file with more information is saved as:
# /opt/sqldeveloper/sqldeveloper/bin/hs_err_pid6544.log
#
# If you would like to submit a bug report, please visit:
# http://bugreport.sun.com/bugreport/crash.jsp
#
/opt/sqldeveloper/sqldeveloper/bin/../../ide/bin/launcher.sh: line 1193: 6544 Aborted (core dumped) ${JAVA} "${APP_VM_OPTS[@]}" ${APP_ENV_VARS} -classpath ${APP_CLASSPATH} ${APP_MAIN_CLASS} "${APP_APP_OPTS[@]}"
root@ubuntu:~#

Reply

Dheeraj Tambare September 25, 2017 at 7:01 pm

i have same problem

Reply

ivan October 15, 2014 at 6:15 pm

Works great!! thanks!!

Reply

Krishna October 18, 2014 at 8:00 pm

Hi Deepak,

Thanks for a nice post. but,

sudo service oracle-xe start

gives me the following error

Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.
Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Express Database using /u01/app/oracle/product/11.2.0/xe/bin/sqlplus.

Please help me.

Reply

amr kamal November 1, 2014 at 12:09 pm

Hi, Thanks a lot for your post ,
but it gave me the same error when I start the service
sudo service oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.
Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Express Database using /u01/app/oracle/product/11.2.0/xe/bin/sqlplus.

Reply

Anna November 11, 2014 at 12:42 pm

I had the same issue. Fixed just executing
sudo apt-get install libaio1
Hope it helps!

Reply

amr kamal November 12, 2014 at 8:29 pm

thanks the problem is solved ,
Thanks a lot

Reply

Marcin November 1, 2014 at 10:12 pm

In general I am newbie in both linux and oracle and your site was my first choice ;). The article is very good.
Depending on the installation choice following command might not be needed because service might be started on start up.

Reply

Sergio Salazar Cortez November 3, 2014 at 2:14 am

Thank you so much Mike! works great.

Reply

Michael November 8, 2014 at 9:31 pm

This all worked great, so thanks, BUT… during the process, Chrome oddly crashed and closed (least of my concerns) and now I cannot login to my account. WTF? The screen flashes and takes me back to the login screen. I’ve made no other changes to my system.
ThinkPad W510, Ubuntu 14.04 64-bit, encrypted home folder. I’m somewhat curious if something happened to the DM since after a login attempt the screen flash includes a flash of the NVidia logo.

Reply

altmerf November 10, 2014 at 5:37 pm

Thanks very much. I got it worked really fast with this :).

Reply

Vinay Rawal November 13, 2014 at 6:31 pm

Thank you Mike. Installed successfully 🙂

Reply

Youssouf November 19, 2014 at 3:05 am

man this is great, it’s easy to preform thanks a lot Mike. Here’s a small trick for those whom are having troubles in Increasing The Maximum Number Of Open Files

Reply

shani November 19, 2014 at 7:18 pm

Awsome! Thank you so much.. such clear and accurate steps.. thanks a lot for composing this.

Reply

Andy November 22, 2014 at 7:46 pm

Mike that is a great tutorial, thanks for sharing, everything worked perfectly for. God bless you.

Reply

Bhupinder Singh November 24, 2014 at 1:30 am

Excellent article. Keep it up good work

Reply

Arun Singh November 27, 2014 at 8:22 pm

Yes !!! It works on my system too . Thanx to you a lot !!!

Reply

Madani December 1, 2014 at 7:40 pm

It worked only once, but now I can’t login, I get this error:

ERROR:
ORA-12541: TNS:no listener

Reply

Frank December 2, 2014 at 10:30 am

You should check if the listener process is running 😉
More info through Google or i.e. Oracle FAQ.

Reply

David December 2, 2014 at 5:26 am

great tutorial, perfect redaction, directo to the point! i love you! jaja

Reply

Cesar Acuna December 4, 2014 at 6:42 am

Brilliant. I got it working on Ubuntu 14.04.1. Big hug and thanks for sharing.

Reply

Abdul Mateen December 7, 2014 at 11:22 am

Excellent….
Thank you very much…

Reply

Alexandre December 7, 2014 at 7:42 pm

Great tutorial. It worked perfectly on fresh Ubuntu 14.04 LTE installation. Congrats!!!

BTW, do you have such tutorial for Oracle 11g Enterprise Edition?

Best regards,

Reply

Lebza December 8, 2014 at 4:09 am

Thanx a mil!. like all the others, had tried, and abandoned the process, but has worked very well. Thankx a stax

Reply

Dreck Müller December 13, 2014 at 12:40 am

Thanx a lot:-)
Simply great.
Everything works like expected.

Reply

Ummer December 15, 2014 at 5:27 pm

Hi Mike,
Great tutorail 🙂
Can we install mysql alongside with oracle?

Reply

nyded December 20, 2014 at 3:54 am

Excellent post. Thanks . 🙂 🙂

Reply

Audrey December 21, 2014 at 5:07 pm

I need your help. I am trying to login into the oracle user in my system and all I get is invalid password. I know the password is correct…what could be amiss?

Reply

Hakancan February 3, 2015 at 12:26 am

run this again
sudo /etc/init.d/oracle-xe configure

Reply

Fernando Costa June 21, 2015 at 2:56 am

I had the same problem. I figured out I was not defining the role parameter correctly. Try to define a new SQL Developer connection using the following options and credentials:

* connetction type=basic
* role=SYSDBA
* hostname=localhost
* port=1521
* sid=xe
* user=sys
* password=

PS: Change port number if you haven’t accepted the default value

Reply

Fernando Costa June 21, 2015 at 2:59 am

Errata:

password=same supplied during Oracle XE installaition

Reply

Nicky Jones December 23, 2014 at 4:52 pm

I am in the final year of my Information Systems degree and using Oracle for Object Relational Programming. I got Oracle 11g installed on a Windows VM, took some time but got there on my own. Installing it on Linux though was completely beyond my skill set. Untill I found you. Your walk through is fantastic. Everything worked first time and I have Oracle and SQL Developer up and running in an hour. Absolutely brilliant. Thank you so very much.

Reply

Artiom December 23, 2014 at 10:27 pm

Everything worked fine for my Ubuntu 14.04 x64. Super!!! Thanks a lot for tutorial!

Reply

Marc December 26, 2014 at 7:54 am

Thank you dude! But how can I start SQL Developer on graphical enviroment if im not loged as root?

Reply

Fernando Costa June 21, 2015 at 3:10 am

I got the same, but I fixed it. If you are not going to use it as root, then drop your .sqldeveloper folder and repeat the last three steps removing the “sudo” command. Don’t forget to create the folder inside of your user’s home directory.

Reply

Fernando Costa June 21, 2015 at 1:48 pm

Errata:
Delete your .sqldeveloper folder

Reply

Edgar Rojas December 30, 2014 at 4:20 pm

Awsome, Just, read and follow the instructions. Zero Errors, 100% successful.

Asombroso. Solo, lee y sigue las instrucciones. Cero Errores, 100% existoso.

Reply

عبد النور December 31, 2014 at 4:20 pm

يعطيك الصحة . مهندس من تونس

Reply

Frank December 31, 2014 at 6:23 pm

I used Google Translate.

Reply

newbie January 7, 2015 at 7:30 am

I was installing Oracle 11g in Ubuntu 14 desktop.
I ran into one issue when I ran this command

sudo rm -rf /dev/sh

All the terminal screens become black and not usable. I had restart the system. To work around the problem, I created a script which had these lines and ran it.

sudo rm -rf /dev/shm
sudo mkdir /dev/shm
sudo mount -t tmpfs shmfs -o size=4096m /dev/shm

It worked fine.

Thanks for the wonderful setup instructions. Keep up the good work!.

Reply

martin santos January 8, 2015 at 3:51 am

the instalation is very good bet i has problen with the ecmtl not up the entrerpracise manger plesea help me

Reply

Andreas Nagel January 30, 2015 at 11:01 am

Perfect! Thanks

Reply

Andre February 4, 2015 at 11:16 am

Thanks, this article really helped a lot! Awesome work!

Reply

mohamed ali February 4, 2015 at 11:59 am

Thank you very much , you save me evertthing work perfet

Reply

Amr February 4, 2015 at 8:06 pm

My OS is: linux mint 17
but i followed your steps, all steps done with successful .. but in configuration step was failed.

———————————-START————————————-
Starting Oracle Net Listener…Done
Configuring database…
Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

Control file created.
PL/SQL procedure successfully completed.
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2233344 bytes
Variable Size 616565760 bytes
Database Buffers 444596224 bytes
Redo Buffers 5541888 bytes
Control file created.
System altered.
Database altered.
Database altered.
System altered.
System altered.
Database altered.
Tablespace altered.

TABLESPACE_NAME
——————————
USERS

SID PROGRAM SERIAL#
———- ———————————————— ———-
USERNAME
——————————
1 oracle@amr-Lenovo-G580 (VKTM) 1

2 oracle@amr-Lenovo-G580 (DIA0) 1

3 oracle@amr-Lenovo-G580 (CKPT) 1

SID PROGRAM SERIAL#
———- ———————————————— ———-
USERNAME
——————————
4 oracle@amr-Lenovo-G580 (MMNL) 3

5 oracle@amr-Lenovo-G580 (VKRM) 7

44 oracle@amr-Lenovo-G580 (GEN0) 1

SID PROGRAM SERIAL#
———- ———————————————— ———-
USERNAME
——————————
45 oracle@amr-Lenovo-G580 (MMAN) 1

46 oracle@amr-Lenovo-G580 (SMON) 1

47 oracle@amr-Lenovo-G580 (QMNC) 13

SID PROGRAM SERIAL#
———- ———————————————— ———-
USERNAME
——————————
87 oracle@amr-Lenovo-G580 (PMON) 1

88 oracle@amr-Lenovo-G580 (DIAG) 1

89 oracle@amr-Lenovo-G580 (DBW0) 1

SID PROGRAM SERIAL#
———- ———————————————— ———-
USERNAME
——————————
90 oracle@amr-Lenovo-G580 (RECO) 1

92 oracle@amr-Lenovo-G580 (CJQ0) 1

130 sqlplus@amr-Lenovo-G580 (TNS V1-V3) 3
SYS

SID PROGRAM SERIAL#
———- ———————————————— ———-
USERNAME
——————————
131 oracle@amr-Lenovo-G580 (PSP0) 1

132 oracle@amr-Lenovo-G580 (DBRM) 1

133 oracle@amr-Lenovo-G580 (LGWR) 1

SID PROGRAM SERIAL#
———- ———————————————— ———-
USERNAME
——————————
134 oracle@amr-Lenovo-G580 (MMON) 3
19 rows selected.
User altered.
User altered.
System altered.

Reply

Argyris February 4, 2015 at 10:13 pm

Works 100% on Ubuntu 14.04 LTS! Thanx!

Reply

Beto Caverna February 16, 2015 at 10:23 pm

It has worked perfectly on my machine. Thank you very much!

Reply

yammek February 18, 2015 at 11:38 pm

Very nice tutorial, works fine, thx a lot:)

Reply

Józef February 24, 2015 at 2:22 pm

Thanks a million. Great tutorial ! Works perfect.

Reply

Bart Grundeken February 27, 2015 at 1:58 pm

This really helped me out. Thanks!

Reply

alvaro March 1, 2015 at 12:12 am

I have got an error when executing
sudo /etc/init.d/oracle-xe configure
… (after writing all options)…
Starting Oracle Net Listener…Done
Configuring database…
Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

Any reason why this happens?
Thanks for this tutorial btw

Reply

Bart Grundeken March 1, 2015 at 9:56 am

Try adding the EXPORT statements and source bash.bashrc BEFORE executing oracle-xe configure.

Reply

alvaro March 1, 2015 at 6:37 pm

Yeah I tried that but it still displays the same error

Reply

Bart Grundeken March 2, 2015 at 12:40 pm

Have you tried checking the files in /u01/app/oracle/product/11.2.0/xe/config/log

for the exact message? There you probably find the error code of the actual error. I am no expert myself but if you post the error code (ORA-XXXX) here or Google for it you will find answers…

Reply

charkowsky March 7, 2015 at 7:31 pm

Hi!
The line “sudo service oracle-xe start” don’t create a file on desktop in my case. Why is it that way?

Reply

luise June 29, 2015 at 9:42 pm

Did you find out why wasn’t create the Desktop file?

Reply

walter March 9, 2015 at 1:46 pm

Hi!
I had an error at the step :
sudo service oracle-xe start

The error was :
Starting Oracle Net Listener.
Starting Oracle Database 11g Express Edition instance.
Failed to start Oracle Net Listener using /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr and Oracle Express Database using /u01/app/oracle/product/11.2.0/xe/bin/sqlplus.

So, I use this command to check the status :
sudo service oracle-xe status

And there was another error :
/u01/app/oracle/product/11.2.0/xe/bin/lsnrctl: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

So I used this command to install libaio :
sudo apt-get install libaio1 libaio-dev

Then, I did again the command :
sudo service oracle-xe start

And this time it works but it does not create a file on desktop in my case either as charkowsky mentionned…

Reply

Patrick Sinke March 11, 2015 at 10:21 pm

Hi Mike, I had to run the “sudo service procps start” as root instead of with sudo before the changes had effect. This message is just for future reference :). Thanks for sharing.

Reply

Hisham March 17, 2015 at 3:29 am

I have been trying to this fir 3 weeks finally found your instruction which worked great, thank you (Ubuntu 14.04 /Trusty Tahr)

Reply

Hisham March 17, 2015 at 3:31 am

I have been trying to do this for 3 weeks, I finally found your instruction which worked great, thank you

(Ubuntu 14.04 /Trusty Tahr)

Reply

perob March 22, 2015 at 11:42 am

Works as advertised on Ubuntu 14.04 with Oracle XE 11.2.0-1.0 x86 64bit and SQL Developer 4.0.3.16.84-1 noarch.
Thank you

Reply

Jorge Mario Zapata March 28, 2015 at 4:21 am

DIOS TE BENDIGA MEN, MUCHAS GRACIAS ESTE TUTORIAL CONL AYUDA DE DIOS ME HA SERVIDO MUCHISIMO, QUE DIOS TE BENDIGA, A MI ME FUNCIONA SOLO SI EJECUTO TODOS LOS PASOS DEL ORACLE 11G … BENDICIONES 😀

Reply

Avinash Jha March 31, 2015 at 9:31 pm

Awesome stuff .. Kudos ..

Reply

Emre Can April 1, 2015 at 4:19 pm

perfect! thank you so much!

Reply

Parag April 1, 2015 at 8:00 pm

It worked for me , thanks for posting such a nice step by step article. Now I have oracle and sql developer on my ubuntu 🙂

Reply

Pedro April 13, 2015 at 7:28 pm

Worked perfectly ! I will try on my Raspberry Pi
Thanks a lot!

Reply

Pedro April 15, 2015 at 2:33 am

Forget it with Raspberry Pi, Oracle does not support ARM.
But i am happy to have Oracle 11g on my Ubuntu 14.04 LTS!
Thanx!

Reply

abe April 15, 2015 at 4:15 pm

Thanks for this great step-by-step tutorial! Worked like a charm for me. (Ubuntu 14.04lts on VirtualBox VM)

Reply

Shamsiddin April 28, 2015 at 10:09 am

Thanks bro for instructions! I’ve been trying to install them for the last 2 days)) really helped

Reply

Bruno Medeiros April 28, 2015 at 4:47 pm

If everything seems to work, but oracle doesn’t listen to port 1521, my answer on http://stackoverflow.com/questions/15501832/oracle-xe-stopped-working-tns-listener-refused-connection mat help you.

Reply

Raphael April 29, 2015 at 2:07 pm

This tutorial worked perfectly in Ubuntu 15.04.
Thank you Mike.

Reply

dassi orleando May 2, 2015 at 11:54 pm

very thanks.
all these steps also work for me.

Reply

lahiru May 4, 2015 at 9:06 pm

Worked for me, thanks. ubuntu 12.04.5

Reply

Sebastian May 14, 2015 at 4:20 am

Thanks a lot, all works! 😉

Reply

Victor May 15, 2015 at 12:48 pm

Very good tutorial. It works ok in Ubuntu 14.04 as well. Many thanks!

Reply

mo May 17, 2015 at 5:24 pm

Super! Hat bestens funktioniert! Sehr gute Anleitung!
Perfect work!!!

Reply

Jp May 24, 2015 at 2:37 am

Thanks a lot. All worked in Ubuntu 14.04 without any pain. Good tutorial.

Reply

ventig May 24, 2015 at 10:22 am

This tutorial was pretty awesome, it worked for me in Ubuntu Mate 15.04, thank you much! Below I am listing three minor issues I encountered and how I ended-up resolving them.

1) Could not confirm the change in the max file size to read “fs.file-max = 6815744” without rebooting first. Solution: rebooted and tried to confirm the change again…
2) Could not execute “mkdir /var/lock/subsys” as this folder already existed. Solution: used the already existing folder…
3) “sudo rm -rf /dev/shm” didn’t work with an error msg of “rm: cannot remove ‘/dev/shm’: Device or resource busy”. Solution: tried rebooting and then removing the folder but it did not work. So I changed the permission of the already existing /dev/shm folder to what a newly created folder permission would be (chmod 755) and continued with the next step.

Reply

Sury May 27, 2015 at 7:57 pm

Thanks for this! I am able to install the database but I am not able to connect to the database from sqlplus.

I have posted the question along with the exception here.

http://dba.stackexchange.com/questions/102590/sqlplus-not-connecting-to-oracle-xe-11g

Reply

ventig May 27, 2015 at 8:02 pm

If you are running Oracle within VMWare Fusion, I would recommend allocating at least 4GB of memory to it. That is the recommended minimum for VMWare Workstation (the Windows version) so I think it must be similar on Fusion. From your stack overflow post it looks like that might be the issue.

Reply

Sury May 27, 2015 at 8:06 pm

So if I increase the memory then I would have to increase the same in /etc/sysctl.d/60-oracle.conf also as per the post?

Reply

ventig May 27, 2015 at 8:10 pm

Yes you would have to make that change in two places if my memory serves me well, double check the post for details on the two spots you have to make the change…

Reply

sury May 27, 2015 at 8:30 pm

Thanks, I think I made progress on that, but I am not able to login with user-name: system and password:
Is there some other default username I can use?

ventig May 27, 2015 at 9:07 pm

You will first need to create a new user and work space to be able to log into the DB through the terminal as a regular user. The easiest way to do that is by clicking on the executable desktop file the blog refers to in the instructions. If you don’t have such a file, then find the “Get Started” application (it is Applications -> Other -> Get Started in Ubuntu Mate) and click on it to open the administrative interface for 11g. Then click on the “Application Express” link to create a new user and work space. It will ask you for administrative login info. This is where you want to use your SYSTEM username and whatever pwd you specified during the configuration process. Then you fill in the required fields and click on “Create Workspace”. Once it has been created, you should be able to log in through the terminal with the user name and pwd you specified for the user you just created. Hope that helps.

Reply

Cledor June 2, 2015 at 4:12 pm

Perfect.its work for me !!!

Reply

vicky June 13, 2015 at 12:11 am

Hello,
Thank you for the tutorial. Unfortunately, I run into a problem even though I strictly followed your guide. This is the error message:
” ” ”
Oracle SQL Developer
Copyright (c) 1997, 2015, Oracle and/or its affiliates. All rights reserved.

Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will be stored in /home/vyluu/.sqldeveloper/4.1.0/product.conf
/usr/lib/jvm/java-7-oracle

Found /usr/lib/jvm/java-7-oracle/bin/java to run this product, and the major version of this Java is 1.7.
The mandatory minimum major version to run this product is 1.8.
This product cannot run with this Java.

Error: /usr/lib/jvm/java-7-oracle/bin/java not found or not a valid JDK
Type the full pathname of a JDK installation (or Ctrl-C to quit), the path will be stored in /home/name/.sqldeveloper/4.1.0/product.conf
” ” ”
Do you know if I have made mistake anywhere while installing Java?
Bests,

Reply

Frank June 22, 2015 at 10:19 am

Check your versions. It looks like you used a newer version of SQL Developer that needs JDK 1.8. Either install a Java 8 or the mentioned version of SQL Developer.

Reply

Merve June 18, 2015 at 12:27 pm

It has worked for me too!! Thanks a lot!

Reply

Manish June 26, 2015 at 9:30 pm

Thanks a lot. Works perfectly.

Reply

Jayaprakash July 18, 2015 at 3:20 am

Thanks. It has worked perfectly for me.

Reply

jan July 18, 2015 at 3:33 pm

For those who get the error

sed: can’t read /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora: No such file or directory

the installation also requires the package: bc

Also make sure to set the bashrc variables before running /etc/init.d/oracle-xe configure

Reply

muktha July 25, 2015 at 3:37 am

Thank you so much!
The process was so straight-forward and no issues – except that I installed a newer version of SQL developer and older version of Java (I fixed this by installing Java 8).

Reply

Leave a Comment

 

Previous post:

Next post:

About Whitehorses
Company profile
Services
Technology

Whitehorses website

Home page
Whitebooks
Jobs

Follow us
Blog post RSS
Comment RSS
Twitter