Installing Oracle Express Edition 10.2 (32-bit) in Ubuntu 12.04 (32-bit)

After Searching the Internet I came-up with this step by step guide
sudo apt-get install libc6-i386

The next thing to do is download the files needed. It’s libaio_0.3.104-1_i386.deb and oracle-xe-universal_10.2.0.1-1.1_i386.deb. You could use wget for this

wget -c http://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/oracle-xe-universal_10.2.0.1-1.1_i386.deb

After your downloads are finished,
Type
sudo apt-get install bc

You could try to install with usual dpkg -i

sudo dpkg -i libaio_0.3.104-1_i386.deb

sudo dpkg -i oracle-xe-universal_10.2.0.1-1.1_i386.deb

And after the installation is finished, you need to configure it

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

Enter [YOUR DEFINED PASSWORD]

and edit your ~/.bashrc

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID=XE
export PATH

That’s it, the oracle xe is ready. You could go to http://127.0.0.1:8080/apex from your browser.

Testing the Oracle-supplied example database

Oracle have thoughtfully provided a dummy database for you to play with. There is a user called HR with some tables in them. It provides a good test to check that everything is up-and-running.

sqlplus sys/[YOUR DEFINED PASSWORD]

Gain admin access using ‘sqlplus sys as sydba’ (shown above). Choose a password for user HR (which I will denote by $password) and then type


alter user HR account unlock ;
alter user HR identified by $password ;
exit

Now attempt to examine the database as user HR:

sqlplus HR/$password

SELECT table_name FROM user_tables;
SELECT * FROM regions ;
INSERT INTO REGIONS (REGION_ID, REGION_NAME) VALUES (666, 'Outer Mongolia') ;
COMMIT ;

The first SELECT statement should give you a list of user tables that you can play with (in this example, they are: REGIONS, LOCATIONS, DEPARTMENTS, JOBS, EMPLOYEES, JOB_HISTORY, COUNTRIES). The second SELECT statement shows a list of entries in the REGIONS table. Hopefully everything will show up fine. In the INSERT INTO line, I add a record to the database so that we can prove what database we are connected to. COMMIT just commits the new item.

Advertisements

8 responses to “Installing Oracle Express Edition 10.2 (32-bit) in Ubuntu 12.04 (32-bit)

  1. You are wonderful mate thanks for your wonderful website
    I am really happy I nearly tried 10 days unsuccessfully to install Oracle in my 32 bit laptop
    Oh dear I am really happy
    Thanks For this post mate

  2. Hi brother! thankx for this page…
    i am not able to edit the following command

    and edit your ~/.bashrc…. outcome is permission denied

  3. hola. tu post me a ayudado mucho, pero hay algo que no puedo entender y es lo siguiente

    “y editar su ORACLE_HOME export ORACLE_SID = XE export PATH” no se como hacer esto.

    la pregunta es que archivo debo escribir esas lineas de codigo.

    gracias.

  4. it does not work for me even if i have the same version of ubuntu. the first command ‘apt-get install libc6-i386″ does not work: the package does not exist. i’ve tried to add the source to /etc/apt/sources.list but it does not solve the probrem please help!!

  5. the above steps are good..but when i restart my system, i do not see the oracle server running …what to do ?

  6. problem in installing—
    dpkg: error processing libaio_0.3.104-1_i386.deb (–install):
    trying to overwrite ‘/usr/include/libaio.h’, which is also in package libaio-dev 0.3.109-2ubuntu1

    watll I do???help me

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s