Legal | Privacy
print Printer View e-mail E-mail this page Bookmark Bookmark

OBE Home > Database 10g > Single Instance > Installation > HTML DB

Installing and Configuring Oracle HTML DB 1.6

Purpose

This tutorial describes how to install and configure Oracle HTML DB 1.6 into an existing Oracle Database 10g Release 1.

Time to Complete

Approximately 30 minutes

Topics

This tutorial covers the following topics:

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

Viewing Screenshots

Place your cursor on this icon to display all the screenshots in the tutorial. You can also place the cursor on each individual icon in the following steps to see only the screenshot that is associated with that step.

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.

Prerequisites

Before starting this tutorial, you should have:

1.

Access to an Oracle Database 10g Installation with a database already created or follow the tutorial Installing Oracle Database 10g on Linux.

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 will 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 (Windows) or ./runInstaller.sh (Linux).

 
3.

At the Welcome window, click Next.

Move your mouse over this icon to see the image

 
4.

You need to install Oracle HTTP Server in a new Oracle Home. Specify the Name and Path, then click Next.

Move your mouse over this icon to see the image

 
5.

Select the second option Oracle Database 10g Companion Products and click Next.

Move your mouse over this icon to see the image

 
6.

Select Apache Standalone 9.0.4 and click Next.

Move your mouse over this icon to see the image

 
7.

Click Install.

Move your mouse over this icon to see the image

 
8.

The progress window will appear.

Move your mouse over this icon to see the image

 
9.

The Configuration Assistant window will appear.

Move your mouse over this icon to see the image

 
10.

You need to open another window and run ./root.sh as the root user in the <http_1 home> directory. Then switch back to this window and click OK.

Move your mouse over this icon to see the image

 
11.

Once the installation completes successfully, click Exit, then Yes.

Move your mouse over this icon to see the image

 

Back to Topic List

Installing Oracle HTML DB 1.6

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

1.

Download the software from OTN here.

 
2.

Unzip htmldb_1.6.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 will be 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:

1.

Open a terminal window and execute the following:

cd <htmldb install dir >/Apache/Apache
mkdir images
cd images
cp -r <htmldb software location>/images/* .
Note: the commands above indicate the UNIX environment syntax.

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:

1.

Add the following to the <HTTP_ORACLE_HOME>\Apache\modplsql\conf\dads.conf (Windows) or <HTTP_ORACLE_HOME>/Apache/modplsql/conf/dads.conf (Linux) file: 

Alias /i/ "<http_oracle_home>/Apache/Apache/images/"
<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.

Stop and start the HTTP Server with the following commands:

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

 

Back to Topic List

Provisioning 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.

Move your mouse over this icon to see the image

 
2.

Under Manage Workspaces, click Create New Workspace.

Move your mouse over this icon to see the image

 
3.

Enter obe as the Workspace Name and click Next.

Move your mouse over this icon to see the image

 
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.

Move your mouse over this icon to see the image

 
5.

Enter obe as the username, and enter your password and your e-mail address. Then click Next. Note: A new administrator user will be created in addition to the workspace.

Move your mouse over this icon to see the image

 
6.

Review your workspace request, and then click Provision.

Move your mouse over this icon to see the image

 
7.

Your workspace and user is now created. Click Done.

Move your mouse over this icon to see the image

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:

1.

To navigate to the Oracle HTML DB Login Page, enter the following URL in your browser:

http://<host name>:<port>/pls/htmldb/htmldb

 
2.

Enter the following details, and click Login.

Workspace: obe
Username: obe
Password: obe

Move your mouse over this icon to see the image

 
3.

The Workspace Home Page appears.

Move your mouse over this icon to see the image

 

Back to Topic List

Summary

In this tutorial, you learned how to:

Install and Configure Oracle HTML DB

Provision a New Workspace

Log In to Oracle HTML DB

Back to Topic List

Place the cursor on this icon to hide all screenshots.

 

 

 
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy