The company that I work for uses Apex. There are several simple
applications and reports created using Apex. There is also a development
instance which runs Oracle 11.2.0.2 on RH Linux 5.6, 64 bit. So far, the
developers have been using Apex 3.2, running of an Apex instance, Oracle
home version 10.2, with the standard mangled Apache server, modplsql and
"marvel.conf". It was a nice little 32 bit machine which has reached its
end of commercial life and was scheduled to be decommissioned.
I was told to install the Apex server on the new shiny development box,
with 24GB of RAM, 64 bits and 2 4-core CPU's, which also hosts the new
development instance, the aforementioned RDBMS 11.2.0.2.

Unfortunately, there is no Oracle's version of Apache any more. The old
10.2 version will not install on RH 5.6 - one of the libraries is missing
symbols, will not start. The good news is that Oracle has integrated Apex
3.2.1 with Oracle 11.2. RDBMS can assume the role of a web server and it
is even in DBCA. One needs only to enable RDBMS to serve HTTP pages by
using DBMS_XDB.SETHTTPPORT and voila, everything is cool and simple.
There is, however, a problem. Apex server needs to be on the same machine
as the database. Database and web serving are typically two very
different types of load and it would be rather hard to properly configure
the box which would be very active web server, as well as a very active
RDBMS server. Fortunately, there is a solution for that, too. It is
delightfully simple and is called Oracle Apex Listener:

http://www.oracle.com/technetwork/de...ener/overview/


It is essentially a single jar (actually "war") file which is a breeze to
configure, and so far extremely reliable. It is run simply as:

java -jar apex.war

That's it! It is configured using web interface. No installation, just
unzip. I've created a short bash script that is run using "nohup" and
voila, here is a full fledged Apex server. It does require JDK 1.6.0.20
or newer. Well done, Oracle! Here is my "launcher":

[oracle@oracle2a apex]$ cat launcher
#!/bin/bash
set -am
JAVA_HOME=/usr/java/latest
PATH=$JAVA_HOME/bin:$PATH
ORACLE_BASE=/software/oracle/base
ORACLE_HOME=/software/oracle/base/product/11.2.0/dbhome01
TNS_ADMIN=$ORACLE_HOME/network/admin
ORACLE_SID=MCST
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$ORACLE_HOME/bin:$PATH
WAR=$HOME/apex/apex.war
APEX=$HOME/apex
IMAGES=$HOME/images
cd $APEX
exec java -Dapex.images=$IMAGES -jar $WAR

The "images" directory is the /i/ directory from the former Apache
installation. I copied the old 3.2.0 directory and it works perfectly.
Log file is very verbose and is, of course, called "nohup.out":

[oracle@oracle2a apex]$ head -5 nohup.out
INFO: Starting: /home/oracle/apex/apex.war
See: 'java -jar apex.war --help' for full range of configuration options
INFO: Extracting to: /tmp/apex
INFO: Using classpath: file:/tmp/apex/apex/____embedded/start.jar:file:/
tmp/apex/apex/WEB-INF/lib/apex.jar:file:/tmp/apex/apex/WEB-INF/lib/
commons-fileupload-1.2.1.jar:file:/tmp/apex/apex/WEB-INF/lib/
je-4.0.103.jar:file:/tmp/apex/apex/WEB-INF/lib/ojdbc6.jar:file:/tmp/apex/
apex/WEB-INF/lib/ojmisc.jar:file:/tmp/apex/apex/WEB-INF/lib/ucp.jar:file:/
tmp/apex/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/tmp/apex/apex/WEB-
INF/lib/xmlparserv2-11.2.0.jar:file:/tmp/apex/apex/WEB-INF/lib/
xdb-11.2.0.jar:
INFO: Starting Embedded Web Container in: /tmp/apex
[oracle@oracle2a apex]$

Once again, well done! No more tedious httpd.conf and marvel.conf fixing
and tuning.
--
http://mgogala.byethost5.com

Mladen Gogala wrote,on my timestamp of 17/07/2011 9:05 AM:

Must be a Linux thing. I've got Apex 4 (the 11g version) loaded with Apache and
coexisting happy in my dev server, serving Apex pages with data from my
production 10.2 DW instance - in a totally different box not even in the same
data centre. All Aix, all dbs 10.2.0.3, all Apex 4 and yes, Apache is there and
running. Or at least the process mentions apache in its name?

"Mladen Gogala" <gogala.mladen (AT) gmail (DOT) com> wrote

Did you try the HTTP Server that comes with Oracle Fusion Middleware 11gR1?
http://www.oracle.com/technetwork/mi...ad-092893.html
Scroll down to "Web Tier Utilities 11.1.1.3.0" at the bottom.

Matthias

On Sun, 17 Jul 2011 22:57:42 +0200, Matthias Hoys wrote:

No, I didn't. Does it work? Did you try it?



--
http://mgogala.byethost5.com

"Mladen Gogala" <gogala.mladen (AT) gmail (DOT) com> wrote

Not yet, but maybe that's the one you are looking for?

Just confirmed:
ausyd-dw01dbc$ps -ef|grep Apache
oracle 856074 1110092 0 03 Mar - 1:12 /u01/app/oracle/product/10.2.0/apex/Apache/Apache/bin/httpd -d /u01/app/oracle/product/10.2.0/apex/Apache/Apache -U 2053505045
oracle 1097754 1110092 0 02 Mar - 0:04 /u01/app/oracle/product/10.2.0/apex/Apache/Apache/bin/rotatelogs /u01/app/oracle/product/10.2.0/apex/Apache/Apache/logs/access_log 43200
oracle 1110092 2969854 0 02 Mar - 3:00 /u01/app/oracle/product/10.2.0/apex/Apache/Apache/bin/httpd -d /u01/app/oracle/product/10.2.0/apex/Apache/Apache -U 2053505045
oracle 9126112 1110092 0 02 Mar - 0:00 /u01/app/oracle/product/10.2.0/apex/Apache/Apache/bin/rotatelogs /u01/app/oracle/product/10.2.0/apex/Apache/Apache/logs/error_log 43200
..
..
..

That's Apex 4.0.1 installed on my dev box in the 10.2.0.3 software dir.
This was the install download: apex_4.0.1_en.zip
I knew I was not dreaming. It looks like the non-existence of Apache is a Linux specific?

On Jul 17, 8:21*pm, Noons <wizofo... (AT) gmail (DOT) com> wrote:
Oracle HTTP Server was moved from the core DB install to the
Application Server tier in 11g. See http://www.oracle.com/technetwork/mi...ex-091236.html
"The features of single sign-on, clustered deployment, and high
availability enhance the operation of the Oracle HTTP Server. Oracle
HTTP Server 11 g is available off the Oracle Fusion Middleware 11g Web
Tier and Utilities DVD. "
The APEX install guide recommends either the Oracle HTTP Server or the
APEX listener in a multi-tier and/or RAC environment. See "Choosing an
HTTP Server" in the APEX Installation Overview:
http://download.oracle.com/docs/cd/E...ew..htm#i46634

On Mon, 18 Jul 2011 14:57:32 -0700, BicycleRepairman wrote:

Doesn't that require an additional license or two? Apex Listener works
well for me so far.



--
http://mgogala.freehostia.com

BicycleRepairman wrote,on my timestamp of 19/07/2011 7:57 AM:

What it says is that Apache can be installed separately and standalone, although
of course it can be installed as part of the Fusion middleware.
Either that, or "Integration - While Oracle HTTP Server has standalone
deployment options, it can also be deployed in a highly integrated manner with
rest of the Oracle Fusion Middleware" is not written in English...


Actually, that link points to a manual page that says no such thing anywhere...

Mladen Gogala wrote,on my timestamp of 19/07/2011 8:23 AM:
Of course not. If you only install Apache standalone, you don't need any Fusion
license. Only if you use the additional features. Which of course Apex doesn't
need or use. Oracle would be in breach of the Apache open-source license model
if they forced people to install chargeable software in order to use Apache.