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