Installing and Configuring Oracle Application Express 2.0 (formerly HTML DB)

Purpose

This tutorial describes how to install and configure Oracle Application Express 2.0 (formerly HTML DB) into an existing Oracle Database 10g Release 2.

Time to Complete

Approximately 30 minutes

Topics

This tutorial covers the following topics:

	Overview
	Prerequisites
	Installing Oracle HTTP Server
	Installing Oracle HTML DB 2.0
	Copying Images
	Configuring HTTP Server to Run Oracle HTML DB
	Creating a New Workspace
	Logging In to Your Workspace
	Summary

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Overview

Installation of Oracle HTML DB requires you to run a SQL script that loads all the PL/SQL packages into your database so that you can run Oracle HTML DB. In addition, Oracle HTML DB requires that HTTP Server be installed and configured to run HTML DB.

Back to Topic List

Prerequisites

Before you perform this tutorial, you should:

Perform the Installing Oracle Database 10g on Windows tutorial.

Back to Topic List

Installing Oracle HTTP Server

Oracle HTML DB is an application that runs using Oracle HTTP Server. Oracle HTTP Server is installed from the Oracle Database 10g Companion CD or Oracle Application Server 10g. In this tutorial, you install Oracle HTTP Server from the Oracle Database 10g Companion CD. Perform the following steps:

1.	Download and unzip the Oracle Database 10g Companion CD.
2.	Execute the installer via setup.exe.
3.	At the Welcome window, click Next.
4.	Select the third option Oracle Database 10g Companion Products and click Next.
5.	You need to install Oracle HTTP Server in a new Oracle Home. Specify the Name and Path, then click Next.
6.	Select Apache Standalone and click Next.
7.	The installation verifies that your system has the minimum requirements. When done, click Next.
8.	Click Install.
9.	The progress window appears.
10.	The Configuration Assistant window appears.
11.	Once the installation completes successfully, click Exit, then Yes.
12.	Before you can install HTML DB, you need to make sure your PATH Environment Variable is set correctly. Select Start > Settings > Control Panel, then double-click on System.
13.	Click the Advanced tab. Then click Environment Variables.
14.	In the System variables section, select Path and click Edit.
15.	Make sure that the first directory in the path is set to your Oracle Database 10g Database home, not the Apache HTTP Server home. Then click OK.

Back to Topic List

Installing Oracle HTML DB 2.0

To install the Oracle HTML DB software, perform the following steps:

Download the software from OTN.

Unzip htmldb_2.0.zip.

Open a terminal window and execute the following commands:

cd <htmldb dir>
sqlplus /nolog
connect / as sysdba
@htmldbins oracle SYSAUX SYSAUX TEMP /i/ orcl

The above statement is dependent on your configuration

@htmldbins <password> <tablespace_htmldb> <tablespace_files> <tablespace_temp>
 <images> <connect>

Oracle HTML DB is installed into the database.

Back to Topic List

Copying Images

You need to copy the images that Oracle HTML DB uses to the appropriate directory. Perform the following steps:

Open a DOS window and execute the following commands:

cd <http_install_home>/Apache/Apache   
mkdir images   
cd images   
xcopy /s <htmldb_software_location>/images/*.*

<http_install_home> is the directory during the HTTP install where you specified the oracle_home (i.e. c:\oracle\product\10.2.0\http_1)

<htmldb_software_location> is the directory where you unzipped the htmldb zip file and made available for install.

Note: you may also copy the files using Windows Explorer.

Back to Topic List

Configuring HTTP Server to Run Oracle HTML DB

In order to run Oracle HTML DB, you need to configure an application in HTTP Server. Perform the following steps:

Create the <HTTP_ORACLE_HOME>\Apache\modplsql\conf\marvel.conf file and add the following statements:

Alias /i/ "<http_oracle_home>\Apache\Apache\images/" 
AddType text/xml       xbl 
AddType text/x-component       htc 
 <Location /pls/htmldb>
	 SetHandler pls_handler
	 Order deny,allow
	 Allow from all
	 AllowOverride None
	 PlsqlDatabaseUsername      HTMLDB_PUBLIC_USER
	 PlsqlDatabasePassword      oracle
	 PlsqlDatabaseConnectString <dbhostname>:1521:<dbsid>
	 PlsqlDefaultPage           htmldb
	 PlsqlDocumentTablename     wwv_flow_file_objects$
	 PlsqlDocumentPath          docs
	 PlsqlDocumentProcedure     wwv_flow_file_manager.process_download
	 PlsqlAuthenticationMode    Basic
	 PlsqlNLSLanguage           AMERICAN_AMERICA.UTF8
</Location>

Note:
<dbhostname> refers to the name of the host where your database is resides.
<dbsid> refers to the connect string to your database

Modify the <HTTP_ORACLE_HOME>\Apache\Apache\conf\httpd.conf file and add the following lines to the end:

# Include the Oracle configuration file for HTML DB
include "<http_oracle_home>\Apache\modplsql\conf\marvel.conf"

Stop and start the HTTP Server with the following commands:

cd <http_oracle_home>\opmn\bin
opmnctl stopall
opmnctl startall

Back to Topic List

Creating a New Workspace

Before you create an application, you need to create a workspace. Perform the following steps:

1.	Open your browser and enter the following URL: http://<hostname>:7777/pls/htmldb/htmldb_admin Enter admin as the username and enter your password oracle (or what ever the password you specified during the installation). Then click Login.
2.	Under Manage Workspaces, click Create Workspace.
3.	Enter obe as the Workspace Name and click Next.
4.	For "Re-use Existing Schema?" select No. Enter obe for the Schema Name and Password, and select Medium: 5 Megabytes for the Space Quota. Then click Next.
5.	Enter obe as the username, and enter your password and your e-mail address. Then click Next. Note: A new administrator user is created in addition to the workspace.
6.	Review your workspace request, and then click Create.
7.	Your workspace and user is now created. Click Done.
8.	You now want to login as the obe user for the obe workspace. Click Logout.

Back to Topic List

Logging In to Your Workspace

You want to log in to the workspace that you just created. Perform the following steps:

Click Login.

Enter the following details, and click Login.

Workspace: obe
Username: obe
Password: obe

The Workspace Home Page appears.

Back to Topic List

Summary

In this tutorial, you learned how to:

	Install and configure Oracle HTML DB
	Create a new workspace
	Log in to Oracle HTML DB

Back to Topic List