Oracle XE installation at Ubuntu

Update (March 2006): With Oracle Database XE in production, it is even easier to install Oracle on Debian-based distros (thanks to Joel Becker).

There is now an apt-get repository up on oss.oracle.com for XE. Just add:

deb http://oss.oracle.com/debian unstable main non-free

to /etc/apt/sources.list and then:

# wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -
# apt-get update
# apt-get install oracle-xe

Upgrade APEX
To install the latest version of Oracle Application Express in your Oracle Database XE, first download the latest version of Application Express from the Oracle Technology Network.

1. Unzip the downloadloaded zip file:

*

Linux: Unzip .zip

*

Windows: Double click .zip in Windows Explorer

[Note: You should keep the directory tree where you unzip the files short and not under directories that contain spaces.
For example, within Windows unzip to C:\.]

2. Change your working directory to apex.

3. Start SQL*Plus and connect to the Oracle XE database:

*

Linux: $ sqlplus /nolog

SQL> CONNECT SYS as SYSDBA

Enter Password: SYS_Password

*

Windows: {Command prompt} C:\apex> sqlplus /nolog

SQL> CONNECT SYS as SYSDBA

Enter Password: SYS_Password

4. Install Application Express:

SQL> @apexins SYSAUX SYSAUX TEMP /i/


5. Log back into SQL*Plus (as above) and load images:

SQL> @apxldimg.sql APEX_HOME

[Note: APEX_HOME is the directory you specified when unzipping the file. For example, with Windows 'C:\'.]

6. Upgrade Application Express password:

SQL> @apxchpwd

Enter password for Application Express ADMIN account.


7. In a Web browser, navigate to the Oracle Application Express Administration Services application:

http://localhost:8080/apex/apex_admin

In Username, enter ADMIN.
*

In Password, enter the password entered in Step 6.
*