Installing Oracle 10g Express Edition on Ubuntu

-
This was a bit tricky... So here it goes, in case anybody else in the world would like to do it. Full installation instructions can be found here, however I hope that these steps will help:

0. Downlad the Debian pacakge (oracle-xe-universal_10.2.0.1-1.0_i386.deb) from http://www.oracle.com/technology/software/products/database/xe/index.html.

0. First of all, you need to su as root, and unfortunatelly sudo is not enough! Oracle will not install properly unless you do that:

sudo -s


You might want to add 1GB of swap space space. Use these commands:

mkdir /swap
dd if=/dev/zero of=/swap/swapfile_1gb bs=1024 count=1048576
mkswap /swap/swapfile_1gb
swapon /swap/swapfile_1gb


To make the swap file stick add the following lines to /etc/fstab:

/swapfile swap swap defaults 0 0


To check that the swap file is used, type:

swapon -s
free


1. Install libaio1 if you don't have it:

apt-get install libaio1


2. Start the installation:

dpkg -i ./oracle-xe-universal_10.2.0.1-1.0_i386.deb


3. Configure your instance, remember to write down the password:

/etc/init.d/oracle-xe configure


4. Add the Oracle environment shell script in your .bashrc. Edit the file with vi and add the following line at the bottom:

. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh


Oracle 10g XE is now installed and running on your Ubuntu system. In order to be able to use its graphical UI remotely, do the following:

5. Using sqlplus log in as SYSTEM. At the prompt, type:

exec DBMS_XDB.SetListenerLocalAccess(false);


That's it. To SQL*Plus from a remote system use this TNSNAMES.ORA entry:

UBUNTU_XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ubuntu)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)


From any Oracle 10 client system, type:

tnsping ubuntu_xe

... to check it your Ubuntu-based XE is accessible. To connect to it use:

sqlplus system@ubuntu_xe


Hope this helps.

When things go wrong
I have had a few problems, which I have sorted by ensuring that:
- I had enough swap
- I had done everything as root
- I chose the right port numbers

Comments

Post a Comment

Popular posts from this blog

GetDIBits vs. Scanline vs. Pixels[] in Delphi Bitmaps

-
I've been always wanting to sit down one day and solve this problem; test the speed of manipulating pixels on a Bitmap using the three options: - the convenient but understandably slow Pixels[], - the "interesting" Scanline property and - the Windows API GetDIBits and SetDIBits. I have been traditionally using Pixels for quick work and the Get/SetDIBits for low-level pixel manipulation such as the filters used in ToolBox . Never really used the Scanline property in anger, I was always thinking, DIBits "had" to be quicker. Little I knew... I have been experimenting with two tools that I've written and never released to the public domain. The first is the BMPCreator which I wrote in order to create 256-level grayscale bitmaps, the other is the IconCreator which uses a grayscale bitmap and applies color maps to it, giving you the ability to create different colored versions of the same icon (like in my database visualization tool VirtualTreeNavigator ). Yesterd...
Read more

Installation of Mint 17.1 Cinnamon on VMWare

-
It's been 2.5 years since I posted an installation guide of installing Ubuntu 12.10 on VMWare Workstation but the release of Linux Mint 17.1 has prompted me to write an updated guide. This is the third of my guides, acting mostly as a memo for a quick install of new distros on VMWare, my first one written in 2009 ( Linux on VMWare with later additions of other posts full of little hints and reminders (e.g. fonts, keymaps)). Ingredients Please note that these instructions work for most distros, although this post focuses on Mint 17.1 A downloaded ISO image of your favourite distro ( Mint , Mint LMDE , Ubuntu , Debian ) A newly created virtual machine with 2-8GB of RAM, a 40-60GB disk and a couple of CPU cores. Installation Mount the ISO image to your VM's optical drive and boot it up, then follow the instructions to install your distro selecting your preferences (timezone, keyboard layout, etc.). For accessing your VM via ssh from your host, it helps if your Lin...
Read more

Chrome Packaged Apps

-
Image
For a few years now I use Windows, Linux, OS X daily. For years, I've been looking into a language/framework/product that will allow me to build (desktop) applications that can run on all of these OS's. I've looked into QT , PyQT , Java Swing and others. I've looked into the cloud , PaaS , web applications but I couldn't find something that I liked. Of course, HTML5 has gained a lot of momentum and I've been following it from the very first day, so I was "double" happy when I found out about the Chrome Packaged Apps that look and behave like desktop apps, they can however live perfectly in the cloud and are built purely with web technologies. The fact they can run on my Chromebook too, is the cherry on top. Hello World! No time to lose, I jumped into the proverbial Hello World app, which run on my stable Chrome 27.0.1448.0 without a glitch. You have to follow instructions on the previous link to enable the Experimental Extension APIs on chro...
Read more