APEX

Hi,

My company is tight on computing power so we're using an older machine to run our Oracle XE instance and our Apache web server. The Apache server is using port 80 to host the website, while Oracle XE is using port 8080 for APEX.

Initially this did not pose any problems, but as when our consultants were at clients sites they weren't able to access port 8080. This was a huge problem for us since we use APEX for our time sheet system.

I could have used a 2nd computer to host the APEX engine on port 80 (if you want to know how to do this just search the forum), but I didn't have an extra machine at my disposal.

After doing some reading I found that I could modify the Apache httpd.conf file (/etc/httpd/conf/httpd.conf for linux systems) to handle this. I thought I'd post my results for others in the same situation:

- #Search for the mod_proxy section and add the following:
- ProxyRequests Off
- #This maps the :8080/apex to :80/apex
- ProxyPass /apex http://www.mydomain.com:8080/apex
- ProxyPassReverse /apex http://www.mydomain.com:8080/apex
- #This maps the :8080/i/ (for images) to :80/apex.
- #YOU NEED THIS since all images and js calls reference the /i/ directory
- ProxyPass /i http://www.mydomain.com:8080/i
- ProxyPassReverse /i http://www.mydomain.com:8080/i

- #Search for Alias and add the following:
- #This is optional. It will allow a simple url for your users to access a common application
- Redirect /myapps http://www.mydomain.com/apex/f?p=100

Of course you can add some restirctions, and verification for the apache module to the conf above, but I thought I'd keep it basic for this example.

Hope this helps others in the same sitation.