How-To Document

Install and Configure Oracle Application Express (formerly called HTML DB) for use with Oracle Application Server 10 g

Date: 19-Feb-2004
NOTE: This document applies only to HTML DB installations performed using the Oracle 10g Companion CD. For manual installations, please see the Installation Guide.

After completing this How-To, you should be able to:

  • Install Oracle HTML DB
  • Configure Oracle Application Server 10 g for use with Oracle HTML DB

Table of Contents

Introduction

To Install Oracle HTML DB for use with Oracle Application Server 10 g you will start by following the same process as using it with Oracle HTTP Server 10 g. You use the companion CD to do a complete install of Oracle HTML DB with Oracle HTTP Server. Then you manually configure the Oracle Application Server 10 g instance to be able to access Oracle HTML DB. Finally, you can optionally remove the Oracle HTTP Server 10 g home. Note that the database you specify to install in may be version 9.2.0.3 or later.

Install Oracle HTML DB

Use the operating system specific installation instructions on the companion CD to install Oracle HTML DB and Oracle HTTP Server 10 g in a new Oracle home. You may alternatively follow the Oracle By Example document called Installing and Configuring Oracle HTML DB.

Copy Images

For the rest of this document the environment variable ORACLE_HOME_OAS will refer to the path on the file system to the existing Oracle Application Server 10 g home that you wish to use, and ORACLE_HOME_HTMLDB will refer to the path on the file system to the Oracle 10 g home you created in the first step.

You must recursively copy the images directory located in ORACLE_HOME_HTMLDB/marvel/images to somewhere on the file system that contains ORACLE_HOME_OAS. On a Windows system you can simply use the Windows Explorer or execute a command from the command prompt like the one that follows.

  C:\>xcopy /E /I %ORACLE_HOME_HTMLDB%\marvel\images %ORACLE_HOME_OAS%\images


On UNIX or Linux based systems, you execute a command like the following.

  # cp -r $ORACLE_HOME_HTMLDB/marvel/images $ORACLE_HOME_OAS/images


Copy and Modify marvel.conf

The next step is to copy and modify the file marvel.conf, located ORACLE_HOME_HTMLDB/Apache/modplsql/conf/marvel.conf to ORACLE_HOME_OAS/Apache/modplsql/conf/marvel.conf. Open the file in a text editor and modify the file system path next to Alias /i/ to point to the path where you copied the images in the previous step. On Windows systems the Alias line may look like the following:

  Alias /i/ "E:\oracle\ora10\images/"


Notice the forward slash (/) at the end of the path. It is important to include this. On a UNIX or Linux system, the path may look like:

  Alias /i/ "/home/oracle10/product/10.1.0/oas/images/"


Modify oracle_apache.conf to Include marvel.conf

Now you inlcude the path to marvel.conf in the oracle_apache.conf, located ORACLE_HOME_OAS/Apache/Apache/conf/oracle_apache.conf. Open this file in a text editor, and add a line to include the marvel.conf that you copied and modified. For example, on a Windows system the line could look like:

  include "E:\oracle\product\10.1.0\oas\Apache\modplsql\conf\marvel.conf"


On UNIX or Linux based systems, it could look like the following:

  include "/home/oracle10/product/10.1.0/oas/Apache/modplsql/conf/marvel.conf"


To ensure that your changes to oracle_apache.conf are properly recorded and preserved, execute the following additional command:

  # $ORACLE_HOME_OAS/dcm/bin/dcmctl updateConfig -ct ohs     
     


On a Windows based system, execute:

  C:\>%ORACLE_HOME_OAS%\dcm\bin\dcmctl updateConfig -ct ohs
    


Stop and Start Oracle HTTP Server

In order for your changes to take affect stop and start Oracle HTTP Server. On windows you can execute the following commands:

  C:\>%ORACLE_HOME_OAS%\opmn\bin\opmnctl stopproc ias-component=HTTP_Server
  
  C:\>%ORACLE_HOME_OAS%\opmn\bin\opmnctl startproc ias-component=HTTP_Server


On a UNIX or Linux based system, execute:

  # $ORACLE_HOME_OAS/opmn/bin/opmnctl stopproc ias-component=HTTP_Server
  
  # $ORACLE_HOME_OAS/opmn/bin/opmnctl startproc ias-component=HTTP_Server


Remove Oracle HTTP Server 10 g and HTML DB Home

By completing the above steps you no longer have a need for the Oracle home where you installed Oracle 10 g HTTP Server and HTML DB in the first step. All of the Oracle HTML DB code is now compiled as PL/SQL inside the database server you specified at install time, and you copied the images directory to your Oracle Application Server home. If you are not going to use Oracle HTTP Server 10 g run the Oracle Universal Installer from the 10 g HTTP Server home and select the Deinstall Products option.

Feel free to discuss this how-to in the OTN HTML DB Discussion Forum.