Oracle 10g XE on Ubuntu Server

Install Oracle 10g XE on Ubuntu Server

Download

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

from

http://www.oracle.com/technetwork/products/express-edition/downloads/102xelinsoft-102048.html

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
Output:

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 "http://127.0.0.1:8080/apex"

To access the Database Home Page go to http://127.0.0.1:8080/apex. Open a web browser and type url (you need to use username “system” and password setup earlier)

 

oracle-xe

 

$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:

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

 

Oracle 10g XE (Express) Web Interface Remote Access

By default the web interface for Oracle 10g Express is limited to localhost connections only (http://127.0.0.1:8080/apex).

To change it to allow remote connections you can execute:

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

Start the sql command line  :

SQL*Plus: Release 10.2.0.1.0 – 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:

Connected.

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

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:

sqlplus

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:

SQL>

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:

SQL> EXIT

 

The imp and exp command

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

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