Radu Cotescu's professional blog

g33k w17h pa45510n

How to Install Oracle Application Express 3.1.2 on Oracle Database 10g XE

Before upgrading to Oracle APEX 3.1.2 from the Oracle APEX 2.1 that comes with Oracle Database 10g XE you should carefully read this page to know all the facts that you might loose and win. After that follow the next guide. The Oracle’s one has a minor problem.

  1. Download APEX from here.

  2. Unzip it to a convenient directory (/opt on a Linux machine or C:\oraclexe\apex on a Windows machine)

  3. Start an SQL*Plus session from that directory

     sqlplus / as sysdba
  4. Install APEX:

     @apexins SYSAUX SYSAUX TEMP /i/
  5. Reconnect to your database.

  6. Set the images PATH for APEX (APEX_HOME is the folder where you have unzipped APEX; e.g.: /opt, C:\oraclexe)

     @apxldimg.sql APEX_HOME
  7. Set the Administrator password for APEX:

     @apxxepwd.sql secret
  8. Restart your XE instance.

  9. Your new APEX is available at http://localhost:port/apex or for administration purposes at http://localhost:port/apex/apex_admin

How To, Oracle

« vsFTPd and symbolic links Linux strongly attacks Windows in Switzerland »