Free Oracle Tips

Oracle Consulting Oracle Support
Oracle Training
SQL Tuning Consulting
Oracle Tuning Consulting
Data Warehouse Consulting
Oracle Project Management
Oracle Security Assessment
Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Internals Magazine
Oracle Links
Oracle Monitoring
Remote Support Benefits
Remote Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices

Integrating APEX with Oracle AS10g

2 March 2005
John Garmany


Lately I have been playing around with Oracle's Application Express (APEX, formerly HTMLDB).  This is a rapid development environment for small application that is entirely web based.  Unlike J2EE, the web application actually runs as PL/SQL in the database, although you can load the OHS on a separate server.

Basically a fast and surprisingly easy way to create a mod_plsql application.

One cool aspect of APEX is that it can be integrated into the application server midtier instances and take advantage of the AS10g Web Cache.

Integrating APEX into the application server is relatively straight forward since the heavy lifting is performed in the database. APEX is located on the companion disk of the Oracle 10g database.  It can also be installed in a 9iR2 database.  On the midtier instance execute the Oracle Universal Installer (runInstaller) and install  only APEX in a separate home directory.  The installer will ask for connection data for the database.  Again most of the install goes into the database. 

1.  Copy the $ORACLE_HOME (HTML DB) /marvel/images to the same directory in the midtier ORACLE_HOME. 

2.  Copy the $ORACLE_HOME (HTML DB) /Apache/modplsql/conf/marvel.conf to the same location in the midtier ORACLE_HOME.

We are finished with the APEX ORACLE_HOME and you can delete it.  Remember APEX resides in the database.

3.  In the midtier edit the marvel.conf file.  Change the Alias /i/ to the directory you copied the images to.

4.  Edit the midtier oracle_apache.conf and add the line below to include the marvel.conf file.

     include "/<midTier ORACLE_HOME>/Apache/modplsql/comf/marvel.conf"

5.  Now run dcmctl to update the new configuration in the Metadata Repository.

    dcmctl updateConfig -ct ohs

6.  Restart OHS.

You're done!  APEX in now integrated in the application server. 

On Clustered midtiers, the configuration will propagate but the file changes, marvel.conf and the images will not.


  If you are a DBA that inherited the administration of AS10g, this is the book for you.  Written by a DBA for DBAs

Oracle Application Server 10g Administration Handbook

by Oracle Press. In Book Stores Now!

Need Oracle App Server Support?

I'm now offering personal app server mentoring for Oracle DBAs who must quickly learn the intricate details of OracleAS10g.  You can have an Oracle expert right at your fingertips, anytime day or night.

We work with dozens of App Server Oracle databases every year, so we know exactly how to quickly assist you with any Oracle9iAS or Oracle Application Server 10g question. 

Call 800-766-1884 for a custom evaluation. 

Oracle just Got Scripts?

Mike Ault, one of the world's most widely-read Oracle experts, has finally consented to release his complete collection of more than 450 Oracle scripts.

Mike has priced his collection of 465 scripts at $39.95, less than a dime per script.  You can download them immediately at this link:

Need Oracle Tuning Support?

Burleson Consulting now offers a one-day performance review for your Oracle database.  Working with top experts who tune hundreds of databases each year, you can get fast expert tuning advice to hypercharge your Oracle database.

We also provide expert upgrades to Oracle9i and Oracle10g, and our DBAs can quickly show you how to implement the important new features of new Oracle releases.

Call now for remote Oracle support.


John Garmany

Burleson Oracle Consulting

Kittrell, NC, USA, 27544 


Burleson Consulting
Email: • Phone (800) 766-1884

Copyright 1996-2011 by Burleson . All rights reserved.