APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn


Installation & Configuration


Changing the APEX http port with apache

Written by Richard Weug on Friday, 17 February 2012 09:07. Posted in Installation

After you have installedAPEX on your database with Oracle http webserver / Apache as webserver, your APEX installation will be accesible from port 7777 by default. As this is not the standard http port, you might want to change that to 80, which is.


Oracle XE on port 80 in Linux

Written by Richard Weug on Friday, 17 February 2012 09:02. Posted in Installation

Route traffice on port 80 to port 8080 in Linux. Useful voor running Oracle XE on port 80, which is normally not authorized to. Run as root:

# iptables -A PREROUTING -t nat -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8080

# iptables-save 

Original article written by Bart Meijer

Link to original article:  http://www.bnhmeijer.nl/node/74


Upgrading to APEX 4.1 on Oracle

Written by Richard Weug on Wednesday, 25 January 2012 09:03. Posted in Installation

I have been upgrading a lot (and I mean a lot) of APEX environments to 4.1 and never had any issues until ...
well until I encontered the infamous error : "ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters".

Upgrading APEX is very simple. You just have to run the apexins.sql script and voila.
So the question is , what to you do if this script fails.


Change webserver (EPG)

Written by Richard Weug on Tuesday, 24 May 2011 12:13. Posted in Installation

Please imagine the following, You started out with apex. And because it was the easiest installation scheme (apart from copying the ready-made virtual machine offered by Oracle free-of-charge ;-), you used the EPG-installation scenario. Lets suppose that by now you have gained a bit of experience and you want to use a proper webserver to publish your newly gained expertise. At this moment the question becomes: how can I do this, without needing to reinstall all of APEX or even installing a whole new database? This blog shows a quick way to ‘upgrade’ your installation to a webserver


Installation of Apex 4.0 - TomCat - Apex Listener in Ubuntu 10.04

Written by Richard Weug on Thursday, 24 March 2011 14:10. Posted in Installation

This guide describes how to install Apex 4.0 with TomCat and Apex Listener as 
backends in Ubuntu 10.04 server.

In this guide we make assumptions:
First of all, setup Oracle XE database. 
Add Oracle XE repository. Create empty file: