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