Ubuntu Linux Install Oracle Database XE Server
Q. How do I install Oracle Database XE Server on my Ubuntu Linux desktop system?
A. An Oracle database consists of a collection of data managed by an Oracle database management system. You can download Oracle Database XE server for Debian, Mandriva, Novell, Red Hat and Ubuntu Linux distributions. First you need to get databases up and running in order to use Oracle. The Oracle database has had a reputation among new Linux users as difficult to install on Linux systems. Now Oracle Corporation has packaged recent versions for several popular Linux distributions in an attempt to minimize installation challenges beyond the level of technical expertise required to install a database server.
Make sure you have enough disk space and memory
If you have less than 1GB memory run the following commands to create swap space:
$ sudo dd if=/dev/zero of=/swpfs1 bs=1M count=1000
$ sudo mkswap /swpfs1
$ sudo swapon /swpfs1
Debian / Ubuntu Oracle installation
First modify /etc/apt/sources.list file:
$ sudo vi /etc/apt/sources.list
Append following line:
deb http://oss.oracle.com/debian unstable main non-free
Save and close the file. Next import GPG key:
$ wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -
Update package database:
$ sudo apt-get update
Finally install Oracle:
$ sudo apt-get install oracle-xe
Output:
Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: linux-headers-2.6.20-15-generic linux-headers-2.6.20-15 Use 'apt-get autoremove' to remove them. The following extra packages will be installed: libaio The following NEW packages will be installed: libaio oracle-xe 0 upgraded, 2 newly installed, 0 to remove and 2 not upgraded. Need to get 221MB/221MB of archives. After unpacking 405MB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 http://oss.oracle.com unstable/non-free oracle-xe 10.2.0.1-1.1 [221MB] .... ....
Post-install configuration
You must configure Oracle TCP/IP port and other parameters. Simply type the following command:
$ sudo /etc/init.d/oracle-xe configure
Output:
Oracle Database 10g Express Edition Configuration ------------------------------------------------- This will configure on-boot properties of Oracle Database 10g Express Edition. The following questions will determine whether the database should be starting upon system boot, the ports it will use, and the passwords that will be used for database accounts. Pressto accept the defaults. Ctrl-C will abort. Specify the HTTP port that will be used for Oracle Application Express [8080]: [Enter key] Specify a port that will be used for the database listener [1521]:[Enter key] Specify a password to be used for database accounts. Note that the same password will be used for SYS and SYSTEM. Oracle recommends the use of different passwords for each database account. This can be done after initial configuration:secret Confirm the password:secret Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:y Starting Oracle Net Listener...Done Configuring Database...Done Starting Oracle Database 10g Express Edition Instance...Done Installation Completed Successfully. To access the Database Home Page go to "http://127.0.0.1:8080/apex"
To access the Database Home Page go to http://127.0.0.1:8080/apex. Open a web browser and type url (you need to use username "system" and password setup earlier)
References
Linux Powered Asus EEE Laptop PC From $299
E-mail
Print
Can't find an answer to your question? Contact us
Related Other Helpful FAQs:
Discussion on This FAQ
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!
Tags: database server, debian oracle installation, install oracle on ubuntu linux, Linux, linux distributions, oracle, oracle database management, oracle on debian linux, ubuntu linux oracle, ubuntu oracle installation, wget command
June 30th, 2007 at 1:30 am
Nice and simple. Please note that any use of the Oracle Database Express Edition is subject to the following limitations;
1. Express Edition is limited to a single instance on any server;
2. Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server;
3. Express Edition may only be used to support up to 4GB of user data (not including Express Edition system data);
4. Express Edition may use up to 1 GB RAM of available memory.
So it is good for workstations and laptop and good for home user and students
July 5th, 2007 at 8:53 am
Oracle XE is only compiled for i386 - 32bits - and has some problems trying to install it under x86_64 machine. Some websites explain how to solve this. I wrote a entry in my blog with the extra steps to get XE running under Ubuntu AMD64. Is in Spanish, but I think that is not difficult to extract the steps even without knowing Spanish. In the same entry I put a link to another site what explains the same process in English.
Hope can help
Regards
D.
July 5th, 2007 at 12:59 pm
dballester,
Thanks for pointing out 64 bit issue.
October 1st, 2007 at 8:51 am
Thank you very much for this HOWTO. I followed it on Ubuntu server 7.04 and also on Freespire (based on Ubuntu 7.04) and it worked perfectly. Thank you for making your knowhow available.
Johan Blignaut
December 9th, 2007 at 5:10 am
Thanks for the tips. This really helped.
February 19th, 2008 at 11:19 pm
Thanks, very useful!
April 18th, 2008 at 10:33 pm
My laptop has 512MB RAM. Is it advisable to intall Oracle Express?? If not is there any other option.??
May 30th, 2008 at 10:25 am
XE will run pretty badly with only 512 meg of ram, but it depends on how hard you’re going to be working it. Have you looked into MySQL / PostgreSQL?
July 19th, 2008 at 3:33 am
Here’s what I did:
1) added this to /etc/apt/sources.list: deb http://oss.oracle.com/debian unstable main non-free
2) ran: wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -
3) ran: sudo apt-get update
4) via the Synaptic package manager, clicked on “oracle xe”. This package was installed along with libaio.
5) checked my applications menu and saw that oracle had appeared.
6) ran: sudo /etc/init.d/oracle-xe configure (I changed the port for Oracle Application Express to 9090 so it wouldn’t conflict with Tomcat, which uses port 8080. I indicated that I didn’t want the database server to launch on boot. I was planning launching as needed from the applications menu).
Now I thought that I was ready to go. So I went to the applications menu and selected start database. A terminal window popped up warning me that I wasn’t a member of the dba group. I added myself to the dba group. I restarted my computer and tried starting the database once again from the applications menu.
This time no warning terminal came up. Basically I didn’t get any feedback as to whether the database server was actually running. So I tried accessing:
http://127.0.0.1:9090/apex. I was told the browser couldn’t establish a connection with the database. I selected “run sql from the command line” from the applications menu. This didnt’ work either. The terminal window that came up began like this:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
I also checked my logs:
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
[ OCRUTL][3067549888]u_set_comp_error: Parameter was NULL
[ OCRUTL][3067549888]u_set_ocr_error: Parameter was NULL
2008-07-18 22:18:24.502: [ OCROSD][3067549888]utgdv:2:ocr loc file cannot be opened
2008-07-18 22:18:24.502: [ OCROSD][3067549888]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
[ OCRUTL][3067549888]u_set_gbl_comp_error: Parameter was NULL
2008-07-18 22:18:24.502: [ OCRRAW][3067549888]proprinit: Could not open raw device
2008-07-18 22:18:24.502: [ default][3067549888]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][3067549888]u_set_ocr_error: Parameter was NULL
2008-07-18 22:18:24.502: [ CSSCLNT][3067549888]clsssinit: error(33 ) in OCR initialization
Any suggestions?
July 24th, 2008 at 1:24 am
To the last user —
have you tried going to:
http://localhost/apex
(from the machine you installed XE on) .. i had the sane issue as you.
July 26th, 2008 at 6:58 am
i typed the command for install oracle in ubuntu 8.04
sudo apt-get install oracle-xe
it shows :
” E: Could not get lock /var/lib/dpkg/lock - open (11 Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it? ”
how do i solve this??…please give instructions..
July 29th, 2008 at 10:41 am
what you do is:
sudo rm /var/lib/dpkg/lock
and it should work
August 27th, 2008 at 7:07 am
hi ,
i did the same thing that u hav wrriten but ….m not able to start the database as i get the error on the screen that comes after i select APPLICATION->ORACLE 10g express edition “Operation failed. bikramjit is not a member of ‘dba’ group.”
November 2nd, 2008 (3 weeks ago) at 3:10 pm
u have to add yourself to dba gruop
then:
start database
launch SQL command line
type: connect / as sysdba
then type: exec dbms_xdb.sethttpport(8181);
and finally try: http://127.0.0.1:8181/apex
and u should be able to use web interface