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

Posted on May 24th, 2009 at 18:16, in How To, Oracle.

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
    4. sqlplus / as sysdba
  4. Install APEX:
    5. @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)
    7. @apxldimg.sql APEX_HOME
  7. Set the Administrator password for APEX:
    8. @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

Similar Posts:


2 Comments

Anonymus Gravatar

Craig Glendenning said

on August 13th, 2009,

at 01:45 hours

Thanks for the post!

In Oracle 10g enterprise edition, if you want to get APEX working with the pl/sql gateway (EPG) using the http server inside the XML DB, here is a step-by-step guide:
http://cglendenningoracle.blogspot.com/2009/08/how-to-install-oracle-application.html

The challenges that I had include a pop-up that the browser was displaying, and having to put user anymous into the APEX dad. I have walked through these instructions on a fresh install, and it seems to work.

Anonymus Gravatar

How to install Oracle Database 10g XE and OC4J on Ubuntu :: Create a part of your development environment | Radu Cotescu said

on December 17th, 2009,

at 22:58 hours

[...] access the OC4J EM at http://127.0.0.1:8888/em and the DB at http://127.0.0.1:8080/apex (note that APEX is not [...]

Think you've got something to say?

For leaving comments including source code or terminal output, please use the the following tags like in the next example: 

[language]
code lines
[/language]
where you substitute language with the programming laguage used throught the code example (for terminal output that would be bash), e.g: 
[bash]
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
[/bash]

To see a list of all the supported languages, please check this page.

If you want to include code bits inline, please use the code tags like in the following example: 

The <code>$USER</code> variable holds the current logged in username.

Subscribe without commenting


Bear