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

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

Installation of Ubuntu 17.04 (Zesty Zapus) on VMWare Workstation

-
About two years since my second post on installing a Linux distro on VMWare Workstation , I think it's time for a new update. Today, I got hold of an ISO image of Zesty Zapus ( Ubuntu 17.04 64-bit ) on the cover disk of Linux Format (June '17) and went immediately to "work"... What follows is my latest "recipe": Ingredients a downloaded ISO image of your favourite distro a newly created virtual machine with 4-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 Linux account has the same username as the one on your host OS (Windows, OS X). Once the installation finishes and the VM boots up, log in with your newly created user account and password and admire the new clean desktop. It wo...
Read more

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