Oracle APEX Listener / Apache Reverse Proxy Configuration

Spotlight

NumaraCloud Online!

Numara FootPrints 11 Launched!

Track-It! 10.5 Released

Tenable Named Fastest-Growing Private Company in Enterprise Security Software by Inc. Magazine

GB Advisors, Inc.

PR: +1 (787) 708-6734
US: +1 (786) 272-2370

info@gb-advisors.com

Tech Blog‎ > ‎

Oracle APEX Listener / Apache Reverse Proxy Configuration

posted Dec 2, 2011 12:57 PM by Alexander Guedez [ updated Dec 2, 2011 1:00 PM ]

Many people are interested in how to configure the Oracle APEX listener and Apache in a reverse proxy architecture utilizing AJP. This configuration has resulted to be very efficient (Free) compared to the other Weblogic (Costly) alternative configurations. Below you will find a diagram with what we want to accomplish.

Assumptions:

This environment is Linux CentOS 5+ 64 Bit
Oracle XE 11g and Oracle APEX is already installed and configured. If you need help setting this environment up you can check our previous tech blog entry "Oracle XE 11g, Oracle APEX upgrade and APEX Listener Installation"
Oracle APEX images directory are located in /oracle/apex/images

First we make sure our system is updated. As root:

# yum update

Install Apache httpd if its not already installed. As root:

# yum install httpd

Configure the httpd service to run reverse proxy with the APEX Listener

First make a backup of the httpd configuration file, as root:

# cp /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.original

Modify your httpd.conf file to add the reverse proxy calls from and to the Apex Listener. As root user:

# vi /etc/httpd/conf/httpd.conf

Add at the end of the file httpd.conf:

ProxyRequests Off

<Proxy *>

Order deny,allow

Allow from all

</Proxy>

ProxyPreserveHost On

ProxyPass /apex ajp://localhost:8009/apex

ProxyPassReverse /apex ajp://localhost:8009/apex

ProxyPass /i ajp://localhost:8009/i

ProxyPassReverse /i ajp://localhost:8009/i

Restart the httpd service for the changes to take place. As root:

# service httpd restart

Download the latest Oracle Apex Listener version:

http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html

Unzip the Apex Listener compressed file in /oracle/listener . As oracle user:

# unzip apex_listener.zip

The first time you run the Apex Listener you must run in the command prompt without the "&" at the end. The reason is that the configuration requires the administrator to assign a user and password to the Listener Admin and Manager. As oracle user:

# java -Dapex.home=/oracle/listener/apex -Dapex.images=/oracle/apex/images -Dapex.ajp=8009 -Dapex.erase -jar /oracle/listener/apex.war

(Optional) The subsequent times you run the Apex listener you can use "&". For example:

# java -Dapex.home=/oracle/listener/apex -Dapex.images=/oracle/apex/images -Dapex.ajp=8009 -Dapex.erase -jar /oracle/listener/apex.war &

The first time you log in you need to go to the listener configuration website and add the connection information for your database and APEX_PUBLIC_USER user account:

http://localhost/apex/listenerConfigure

Enjoy your new Apex using your reverse proxy configuration!!!

	Search this site