| How-To Document
Install and Configure Oracle Application Express (formerly called HTML DB) for use with Oracle Application Server 10
After completing this How-To, you should be able to:
Table of Contents
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 18.104.22.168 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:
On UNIX or Linux based systems, it could look like the following:
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.