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

How To Oracle
Sunday, May 24th 2009, 18:16
2 Comments

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

You might also like:

2 Comments

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>


CODE EXAMPLES: When you want to include 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
    [/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.

Recent Posts

Projects that I support

Recent Comments

  • nope said:
    yeah that was my first thought too, but: mount: warning: seems to be mounted read-write. too bad, would have been just perfect. more»
  • Klaus Deiss said:
    Dear Radu, I tried it on Ubuntu 10.0.4.2 and 10.0.4.3 with different kernel versions (amd64 server 2.6.32 kernel). No... more»
  • scompo said:
    Nope.. Now it’s not working again.. This printer it’s a real pain in the butt.. The other hp printer I had... more»
  • Dmitrij said:
    Thank you Peter and Patrice. Could you please post the updated script? more»
  • hd_flash_pains said:
    didn’t work for me more»

Recent Tweets

Geek blogs

Romanian blogs

Bear