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

Popular posts from this blog

Sekelumit kisah tentang Nokia N900 - Part I

Bermula dari ketertarikan dengan sebuah perangkat yg menurut review sangat (mungkin paling) mumpuni saat itu, sekitar April - Mei 2010. Setelah baca banyak review juga terhadap perangkat tersebut, akhirnya Saya memutuskan untuk menebus perangkat Nokia N900 tersebut pada 30 Mei 2010 , walaupun untuk mendapatkannya ternyata harus keliling dulu ke beberapa authorized reseller Nokia karena peredarannya agak terbatas. Dan ternyata setelah beberapa waktu menggunakannya memang terbukti sangat mumpuni and the device had satisfied me almost everything I need for a sophisticated device . Setelah hampir 7 bulan menggunakannya (awal Desember 2010), mulai terasa ada keanehan, gejalanya adalah kalo mau dicharge harus dalam posisi berdiri (dimana bagian mini USB Port nya berada diatas) dan kabel chargenya harus diposisikan kebelakang supaya bisa dicharge, kalo tidak begini proses charging nya jadi suka on/off. Waktu itu tidak banyak berprasangka aneh-aneh, cuman berpikiran mungkin emang perlu ada sed...
4 comments
Read more

Intel 3945 Wifi Card Problem Easy Troubleshoot in Ubuntu 10.10

Recently just change my mind to switch back OS to pure Ubuntu (not its derivative). I've been using Mint version of Ubuntu derivative for 2 years. Gradually move with upgrade from Mint 5, Mint 8 to Mint 9 (KDE). Last upgrade (Mint 9 KDE) was to 64 Bit version about 8 months ago. Today just upgrade to 10.10 Ubuntu and find out that I couldn't access office wireless network. After googling, I find out a simple solution from this links So just type this in your terminal: sudo rfkill unblock wifi Type 'dmesg | grep iwl' to see the result that should inform something like this: iwl3945 0000:07:00.0: loaded firmware version 15.32.2.9 And of course available Wifi Network now should appear in Network Manager applet drop down. See picture below for more verbose outcome. After this then I'll applied PAE Kernel to utilized unused 1 GB RAM in my laptop, since 32-bit linux without PAE can only used maximum 3 GB of RAM (mine is 4 GB),... hehehe I'm back to 32-bit world again,...
Post a Comment
Read more