Installing and Configuring Oracle Application Express 2.0 (formerly HTML DB)
Installing and Configuring Oracle HTML DB 2.0 on Windows
Installing and Configuring Oracle Application Express 2.0 (formerly HTML DB)
This tutorial describes how to install and configure Oracle
Application Express 2.0 (formerly HTML DB) into an existing Oracle Database 10g Release 2.
Approximately 30 minutes
This tutorial covers the following topics:
 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.
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
Before you perform this tutorial, you should:
Back to Topic List
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
To install the Oracle HTML DB software, perform the following steps:
| 1. |
Download the software from OTN.
|
| 2. |
Unzip htmldb_2.0.zip.
|
| 3. |
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
You need to copy the images that Oracle HTML DB uses to the appropriate directory. Perform the following steps:
|
1. |
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
In order to run Oracle HTML DB, you need to configure an application in HTTP Server. Perform the following steps:
| 1. |
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
|
| 2. |
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"
|
| 3. |
Stop and start the HTTP Server with the following commands:
cd <http_oracle_home>\opmn\bin
opmnctl stopall
opmnctl startall
|
Back to Topic List
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
You want to log in to the workspace that you just created. Perform the following steps:
| 1. |
Click Login.
|
| 2. |
Enter the following details, and
click Login.
Workspace: obe
Username: obe
Password: obe
|
| 3. |
The Workspace Home Page appears.
|
Back to Topic List
In this tutorial, you learned how to:
Back to Topic List
Move your mouse over this icon to hide all screenshots.
| 
