Sunday, March 6, 2011

Install and start Oracle 10g Express in Ubuntu 10.10

Here are The steps to download, install and start Oracle Express 10g getting the History and Arrow Keys to work in Terminal.

Add this line to /etc/apt/sources.list file:

deb unstable main non-free

Next, you will need to add the GPG key.

wget -O- | sudo apt-key add -

As root, type:

apt-get update

To install the XE database server, apt-get 'oracle-xe-universal' or 'oracle-xe' (Western European support only).

apt-get install oracle-xe-universal

If you only need the XE client, type

apt-get install oracle-xe-client


As root, type:
/etc/init.d/oracle-xe configure

Edit your .bashrc file to include the lines:

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

Start a new bash shell for the changes to take effect.

To log in as a database administrator:
conn sys as sysdba ; Then write your password

To Access database home from HTTP

To add new user to the system and give him dba privilages, write the following in the SQL Plus CMD

create user write_user_name identified by write_user_password;
grant dba to user_name;

To unlock the HR account to work with examples provided by Oracle.

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


To get the history and arrows keys to work:
Download qgplus , Click Here

after you download gqlplus,

1. find your path variable:
echo $PATH
you should see this path in there:

2. Extract the gqplus file you have downloaded and take out the gqlplus executable from the linux folder inside it.

3. place the executable in any of the path directories.

e.g. Copy it here :/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

Then from the terminal run it.


Have Fun :) .





No comments: