0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<(args.length-2); i+=3) if ((obj=findObj(args[i]))!=null) { v=args[i+2]; if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v='hide')?'hidden':v; } obj.visibility=v; } } //Define function to show one layer and hide others: function show(whichLayer) { if(layerDisp) { showHide(layerDisp,'','hide'); } showHide(whichLayer,'','show'); layerDisp = whichLayer; } //Define function to keep score and display feedback: function Engine(question, answer, layerSuffix) { if (answer != ans[question]) { show('incorrect'+layerSuffix); } else { if (!done[question]) { score++; } show('correct'+layerSuffix); } done[question] = -1; } //Define function to verify answer for checkbox: function checkAnswer(question, whichform, whichbox) { var checkTotal = 0; with (whichform) { for (i = 0; i < whichbox.length; i++) { if (whichbox[i].checked == true) { checkTotal = checkTotal + eval(whichbox[i].value); } } } Engine(question,checkTotal,question*10); } //Define function to show correct answer for checkbox: function showAnswer(question, whichform, whichbox) { var residue = ans[question]; var currAnswer = 1; if(layerDisp) { showHide(layerDisp,'','hide'); } with (whichform) { for (i = 0; i < whichbox.length; i++) { if ((residue>0) && (residue%(currAnswer*2)==currAnswer)){ whichbox[i].checked = true; residue-=currAnswer; } else { whichbox[i].checked = false; } currAnswer*=2; } } } //Define function to init a form function clearForm(form) { //Set all checkboxes and radio buttons on form to unchecked: for (xx=0; xx < form.elements.length; xx++) { if (form.elements[xx].type == 'checkbox' | form.elements[xx].type == 'radio') { form.elements[xx].checked = false; } } } //Define function to init all forms on reload: function InitForm() { clearForm(document.form1) clearForm(document.form2) clearForm(document.form3) } // End --> function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i

OBE Home > Database 10 g > 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.

 

 

 

Left Curve
Popular Downloads
Right Curve