4 Oracle HTML DB Post-installation Tasks

4.2.1 Copying the Images Directory When Upgrading

If you are upgrading from a previous version of Oracle HTML DB, you should rename the existing images directory for Oracle HTML DB to reflect the release number (for example, images_1_5). By renaming the images directory, you have the option reverting to it later on.

To locate images directory on the file system, review the following files for the text alias /i/:

• Oracle9i HTTP Server Release 2, see the httpd.conf file

• Oracle HTTP Server 10g, see the marvel.conf file

• Oracle Application Server 10g, see the marvel.conf file

4.2.2 Copying the Images Directory in New Installation

On a Windows system, you can copy the htmldb\images directory using Windows Explorer or execute a command such as the following from a command prompt:

xcopy /E /I htmldb\images ORACLE_BASE\ORACLE_HOME\Apache\Apache\images

On UNIX or Linux based systems, you can copy the htmldb/images directory by executing a command such as the following:

cp -rf htmldb/images ORACLE_BASE/ORACLE_HOME/Apache/Apache

4.3.1 Oracle HTTP Server Release 9.0.3

If you are upgrading Oracle HTML DB and are running Oracle HTTP Server release 9.0.3 or higher, you must modify the parameter password in the wdbsvr.app file and modify the httpd.conf file to add two new MIME types to support SQL Workshop.

4.3.2 Oracle HTTP Server 10g Release 1 or Oracle Application Server 10g

If you are upgrading Oracle HTML DB and are running Oracle HTTP Server 10g Release 1 or Oracle Application Server 10g, you must modify the parameter PlsqlDatabasePassword and add two new MIME types in the marvel.conf file.

To modify the parameter PlsqlDatabasePassword in the marvel.conf file:

1. Use a text editor and open the marvel.conf file:

   • For UNIX and Linux based systems, the file is located at:

     ORACLE_BASE/ORACLE_HOME/Apache/modplsql/conf/marvel.conf
     
     

   • For Windows based systems, the file is located at:

     ORACLE_BASE\ORACLE_HOME\Apache\modplsql\conf\marvel.conf
     
     

2. Find the DAD settings for Oracle HTML DB by searching for the following:

   /pls/htmldb
   
   

3. Modify the value of the parameter PlsqlDatabasePassword to match the password you provided while executing the htmldbins.sql script.

   Next, add two new MIME types to support SQL Workshop.

4. Add the following line if it does not currently exist:

   AddType text/xml             xbl
   
   

5. Add the following line if it does not currently exist:

   AddType text/x-component     htc 
   
   

6. Save your changes.

7. For Oracle Application Server 10g, execute the following commands:

   • For UNIX and Linux based systems:

     ORACLE_BASE/ORACLE_HOME/dcm/bin/dcmctl updateConfig -ct ohs
     
     

   • For Windows based systems:

     ORACLE_BASE\ORACLE_HOME\dcm\bin\dcmctl updateConfig -ct ohs
     
     

8. Stop and restart Oracle HTTP Server.

   • For UNIX and Linux based systems, execute the following commands:

     ORACLE_BASE/ORACLE_HOME/opmn/bin/opmnctl stopproc ias-component=HTTP_Server
     ORACLE_BASE/ORACLE_HOME/opmn/bin/opmnctl startproc ias-component=HTTP_Server
     
     

   • For Windows based systems:

     ORACLE_BASE\ORACLE_HOME\opmn\bin\opmnctl stopproc ias-component=HTTP_Server
     ORACLE_BASE\ORACLE_HOME\opmn\bin\opmnctl startproc ias-component=HTTP_Server
     
     

4.4.1 Oracle HTTP Server Release 9.0.3

The wdbsvr.app file contains information about Database Access Descriptors (DADs). A DAD is a set of values that specify how the Oracle HTTP Server component modplsql connects to the database server to fulfill an HTTP request. You create a DAD to specify how to connect to an Oracle HTML DB instance.

4.4.2 Oracle HTTP Server 10g Release 1 or Oracle Application Server 10g

You need to modify the marvel.conf file to include an alias that points to the file system path where you copied the images directory and add two new MIME types to support SQL Workshop.

To modify the marvel.conf file:

1. Use a text editor and open the marvel.conf file:

   • For UNIX and Linux based systems, the file is located at:

     ORACLE_BASE/ORACLE_HOME/Apache/modplsql/conf/marvel.conf
     
     

   • For Windows based systems, the file is located at:

     ORACLE_BASE\ORACLE_HOME\Apache\modplsql\conf\marvel.conf
     
     

2. Add the following line if it does not currently exist:

   AddType text/xml             xbl
   
   

3. Add the following line if it does not currently exist:

   AddType text/x-component     htc 
   
   

4. Add an alias entry that points to the file system path where you copied the images directory.

   Note you need to use the alias you specified in the fifth positional argument to htmldbins.sql. The following examples assume you specified the image directory alias as /i/.

   • Windows based system example:

     Alias /i/ "C:\oracle\ora101\Apache\Apache\images/"
     
     

     Note you must include the forward slash (/) at the end of the path.

   • UNIX and Linux based system example:

     Alias /i/ "/home/oracle/OraHome1/Apache/Apache/images/"
     
     

5. Add an DAD entry for Oracle HTML DB using the following syntax. Replace the values PlsqlDatabasePassword, PlsqlDatabaseConnectString, and PlsqlNLSLanguage with values appropriate values for your environment.

   <Location /pls/htmldb>
    SetHandler pls_handler
    Order deny,allow
    Allow from all
    AllowOverride None
    PlsqlDatabaseUsername      HTMLDB_PUBLIC_USER
    PlsqlDatabasePassword      htmldb
    PlsqlDatabaseConnectString localhost:1521:htmldbdv ServiceNameFormat
    PlsqlDefaultPage           htmldb
    PlsqlDocumentTablename     wwv_flow_file_objects$
    PlsqlDocumentPath          docs
    PlsqlDocumentProcedure     wwv_flow_file_mgr.process_download
    PlsqlAuthenticationMode    Basic
    PlsqlNLSLanguage           AMERICAN_AMERICA.AL32UTF8
   </Location> 
   
   

   If either the territory portion or the language portion of the NLS settings contain a space, you must wrap the value in double quotes, like the following example:

   PlsqlNLSLanguage     "ENGLISH_UNITED KINGDOM.AL32UTF8"
   
   

6. Save and exit the marvel.conf file.

7. (Oracle Application Server only) Execute the following commands:

   • For UNIX and Linux based systems:

     ORACLE_BASE/ORACLE_HOME/dcm/bin/dcmctl updateConfig -ct ohs
     
     

   • For Windows based systems:

     ORACLE_BASE\ORACLE_HOME\dcm\bin\dcmctl updateConfig -ct ohs
     
     

8. Stop and restart Oracle HTTP Server.

   • For UNIX and Linux based systems, execute the following commands:

     ORACLE_BASE/ORACLE_HOME/opmn/bin/opmnctl stopproc ias-component=HTTP_Server
     ORACLE_BASE/ORACLE_HOME/opmn/bin/opmnctl startproc ias-component=HTTP_Server
     
     

   • For Windows based systems:

     ORACLE_BASE\ORACLE_HOME\opmn\bin\opmnctl stopproc ias-component=HTTP_Server
     ORACLE_BASE\ORACLE_HOME\opmn\bin\opmnctl startproc ias-component=HTTP_Server
     
     

4.6.1 Viewing the Number of JOB_QUEUE_PROCESSES

There are currently three ways to view the number of number of JOB_QUEUE_PROCESSES:

• In the installation log file

• On the About HTML DB page in Oracle HTML DB

• From SQL*Plus

SELECT VALUE FROM v$parameter WHERE NAME = 'job_queue_processes'

4.6.2 Changing the Number of JOB_QUEUE_PROCESSES

You can change the number of JOB_QUEUE_PROCESSES by running a SQL statement in SQL*Plus:

To update the number of JOB_QUEUE_PROCESSES:

1. Log into the database as SYSDBA using SQL*Plus.

2. In SQL*Plus run the following SQL statement:

   ALTER SYSTEM SET JOB_QUEUE_PROCESSES = <number>
   
   

   For example, running the statement ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20 sets JOB_QUEUE_PROCESSES to 20.

4.7.1 Obfuscating Passwords in a New Installation

In a new installation, the PlsqlDatabasePassword parameter is found in the dads.conf file. To obfuscate passwords in a new installation, run the dadTool.pl utility by following the instructions in the dadTool.README file.

4.7.2 Obfuscating Passwords if Upgrading

If you have upgraded from a previous release, the DAD information is in the file marvel.conf. Before you can run the dadTool.pl utility, you must copy the DAD entry from the marvel.conf file to the dads.conf file.

To obfuscate passwords when upgrading:

1. Use a text editor and copy the entry for /pls/htmldb from the marvel.conf file into the dads.conf file.

   • For UNIX and Linux based systems, these files are located in:

     ORACLE_BASE/ORACLE_HOME/Apache/modplsql/conf/dads.conf
     
     

   • For Windows based systems, these files are located in:

     ORACLE_BASE\ORACLE_HOME\Apache\modplsql\conf\dads.conf
     
     

2. Run dadTool.pl by following the instructions in the dadTool.README file.

3. Copy the entry for /pls/htmldb from the dads.conf file back into marvel.conf.

4. Remove the entry for /pls/htmldb from the dads.conf file.

4.8.1 Accessing the Oracle HTML DB Login Page

To log in to Oracle HTML DB, open the following URL in a Web browser:

http://hostname:port/pls/database_access_descriptor/

Where:

• hostname is the name of the system where Oracle HTTP Server is installed.

• port is the is the port number assigned to Oracle HTTP Server.

  In a default installation, this number is 7777. You can find information about your Oracle HTTP Server installation's port number from the httpd.conf file, located in ORACLE_BASE\ORACLE_HOME\Apache\Apache\conf, by searching for Port.

  You can also find the port number in the portlist.ini file, located in ORACLE_BASE\ORACLE_HOME\install. However, be aware that if you change a port number, it is not updated in the portlist.ini file, so you can only rely on this file immediately after installation.

• database_access_descriptor describes how Oracle HTTP Server connects to the database server so that it can fulfill an HTTP request. The default value is htmldb.

The Oracle HTML DB Login page appears.

In the Oracle HTML DB development environment, users log in to a shared work area called a workspace. Users are divided into three primary roles:

• Developers create and edit applications.

• Workspace administrators perform administrator tasks specific to a workspace such as managing user accounts, monitoring workspace activity, and viewing log files.

• Oracle HTML DB administrator are superusers that manage an entire hosted instance using the Oracle HTML DB Administration Services application.

If you are a developer, an administrator must grant you access to a workspace. If you are an Oracle HTML DB administrator, you need to:

• Log into Oracle HTML DB Administration Services. Oracle HTML DB Administration Services is a separate application for managing an entire Oracle HTML DB instance.

• Specify a provisioning mode. In Oracle HTML DB Administration Services you need to determine how the process of creating (or provisioning) a workspace will work in your development environment.

• Create a Workspace. A workspace is a shared work area within the Oracle HTML DB development environment that has a unique ID and name. An Oracle HTML DB administrator can create a workspace manually or have users submit requests.

• Log in to a Workspace. Once you create a workspace in Oracle HTML DB Administration Services, return to the Oracle HTML DB Login page and log in to that workspace.