Skip to main content

Configure Reverse Proxy Apache 2 for Oracle APEX 4.0

Just taking note reminder for myself, it's about how to configuring Apache 2 HTTP Server (Not OHS come with Compl CD of Oracle Database) as a front end HTTP Server for APEX 4.0 installed in Oracle XE 10g.

Just follow the step as explain below:

  1. Install Apache 2.2 Server (Source can be downloaded from http://httpd.apache.org/download.cgi) installed with listening port configure at 8888

  2. Install Oracle XE 10g Database (Download from http://www.oracle.com/technetwork/database/express-edition/downloads/index.html) installed with listening port configure at 7777

  3. Install APEX 4.0 (Download from http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html)



After those development tools installed last thing to do is Configure Apache2 to become front server and static images server for APEX 4.0 then do the following steps:

  1. Enable/Activate module mod_proxy, proxy_http_module with LoadModule Directive. Configuration example: 

    

    LoadModule proxy_module /usr/lib/apache2/modules/mod_proxy.so

    LoadModule proxy_http_module /usr/lib/apache2/modules/mod_proxy_http.so

    

    

    

            ProxyRequests Off

    

            

                Order deny,allow

                Allow from all

                

    

    

            # Proxy Reverse to APEX

    	ProxyPass        /apex http://localhost:7777/apex

    	ProxyPassReverse /apex http://localhost:7777/apex

    

    	ProxyPreserveHost On


  2. For increasing performance let set Apache 2 to server also static images and common Javascript for APEX application. Configuration example: 

    

    	# ORiginal

    	Alias /i/ "/home/mesz/oApps/apex4/images/"

    	

    		Options None

    		AllowOverride None

    		Order allow,deny

    		Allow from all


  3. Check Configuration before start/restarting Apache with command: 

    apache2 -k

    Go to next step if result is "Syntax OK"

  4. Test Oracle APEX with new configuration



Comments

Post a Comment