Oracle 10g XE on Ubuntu Server

Install Oracle 10g XE on Ubuntu Server


oracle-xe-universal_10.2.0.1-1.0_i386.deb (262,440,214 bytes) (cksum 3404538446) *Debian package


After downloading install the deb package with the gdebi installer or with sudo dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb

After-install configuration

You must configure Oracle TCP/IP port and other parameters. Simply type the following command:
$ sudo /etc/init.d/oracle-xe configure

Oracle Database 10g Express Edition Configuration
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press  to accept the defaults.
Ctrl-C will abort.
Specify the HTTP port that will be used for Oracle Application Express [8080]: [Enter key] or 
 [write your port if 8080 is in use]
Specify a port that will be used for the database listener [1521]:[Enter key]
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:secret
Confirm the password:secret
Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:y
Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to ""

To access the Database Home Page go to Open a web browser and type url (you need to use username “system” and password setup earlier)




$ORACLEHOME environment variable has to be set for proper functioning of console applications.

sudo gedit /etc/bash.bashrc

Now scroll to the bottom of page and add the following lines:

export PATH


Oracle 10g XE (Express) Web Interface Remote Access

By default the web interface for Oracle 10g Express is limited to localhost connections only (

To change it to allow remote connections you can execute:


Start the sql command line  :

SQL*Plus: Release – Production on Wed Feb 11 11:10:40 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect

Enter user-name: system

Enter password:



PL/SQL procedure successfully completed.

SQL> quit;

DONE. No restart required


Starting and Exiting SQL Command Line

To start SQL Command Line from the operating-system command prompt, enter the following:


When prompted, enter the username and password of the user account (schema) that you want to access in the local database. For example, enter HR for the username and my_hr_password for the password when prompted.

You can also include the username and password when you start SQL Command Line. For example:

sqlplus hr/my_hr_password

If you want to connect to a database running on a remote system, you need to include a connect string when starting SQL Command Line. For example:

sqlplus hr/my_hr_password@host_computer_name

After you have started SQL Command Line, the SQL> prompt displays as follows:


At the SQL> prompt, you can enter SQL statements.

When you want to exit SQL Command Line, enter EXIT at the SQL prompt, as follows:



The imp and exp command

exp system/pass FILE=/home/user/file.dmp OWNER=portaldata

imp system/pass FILE=/home/user/expfile.dmp FROMUSER=portaldata TOUSER=portaldata2